All,
I'm using SQL 2000 and have:
* created a role
* granted execute to my procs for that role

I'm using SQL Server 2005 and am wondering if there is a way to determine who
created a stored procedure?  I've looked in sys.objects, but all it gives me
is the original create date and the last modified date.

i was wondering instead of implementing my own security schema inside my
application code is it recommended to depend on SQL Security so a user will
connect with user name and password and if he dont have a permission on SQL
to delete or update he will egt an message i feel its ...

I have a WSS 3.0 running on SQL Server 2005 Standard. It was upgraded from
SQL Server 2005 Express edition. Everytime I restart server I have 4 events
in the event log as follows:
1)

Suppose I should know this answer, but I'm drawing a blank.
For auditing purposes, I need to "Obtain a system generated listing of users
with production access for the systems" .
Basically, I'm looking for a stored procedure or something that will give me

I am running into an issue that I really need resolved today. Simply put, I
am getting the error:
The server principal "dhtest" is not able to access the database "dhtest2"
under the current security context. (Microsoft SQL Server, Error: 916)

I have messages in event viewer several times per minute that say "Login
failed for user ....". The errors rotate through all the accounts that I have
setup in SQL.
I need direction in how to determine what is trying to login and how to

SQL 2005 sp2
We're replacing our old Prod server with a new box.  What's the best way to
setup my users on the new box so when I restore a backup from the old Prod
server the users will be in place, and I don't have to go through the