Not necessarily. I just did a test and the drop database did not get recorded to the ERRORLOG. The "starting up database" did for the create, but that's it.

K. Brian...

Truncate table basically is faster because of how it "removes" the data. There are limitations:

1) Must be db_owner, db_ddladmin, or table owner.

2) You can't use it on a table referenced...

Also, please don't crosspost. Most folks look at all the new forum topics. You've had answers in several different forums now.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server...

It can. Clients will have to be set to use the new port.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Short of resorting to torturing all with the appropriate rights... I'm in an evil mood!

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring...

Unfortunately, nothing like this is built in. You can, however, build it yourself fairly easily:

http://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritythedb_executorrole.asp

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Take a look at sp_change_users_login using the report option.

USE MyDatabase

GO

EXEC sp_change_users_login @Action = 'Report'

GO

It'll report any orphaned users for the given database. There are some...

I'll look for the article. I think I saw it on the SecurityFocus site.

Since you brought up Terminal Services... Another idea that comes to mind is the use of IPSec...

You can restrict what snap-ins a given user account can view using MMC and you'd have to do that for this particular user. That requires a group policy and Active...

quote:

---

I do not really want the users to be able to see any of the tables or sprocs etc.So, I thought that...

My advice would be to cite this a security risk and ask to get the password for this account changed. It should then be put in as few hands as...

You may want to take a look at the following article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;137983

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

You can see the duration using SET STATISTICS TIME ON and then executing the query, but this is probably only useful if you're manually running queries in QA or something...

quote:

---

have an angel of a three year old daughter. (I am soooo wrapped around her finger!)

---