Something else to try:

master..xp_cmdshell 'C:\"Local Folder"\Something.bat'

The user cannot be dropped because they owner objects in the database.  Run this to find out which objects (change the name FRED to the user you are trying to drop):

   ...

A few ideas:

1. If possible, try restarting SQL Server Agent.  When we have had similar problems it has been because of SQL Jobs and SQL Mail.

2. PING your SQL Servers and check the...

I reckon you can't just discount soccer (or football to everybody else outside US  ).  The TV stats have gone crazy in the last...

If you are in a hurry then you could always run sp_detach_db, delete the log file and then run sp_attach_single_file_db.

Once you get the database up and running again then you...

Just in case you are still having problems:

http://support.microsoft.com/kb/293422

Make sure that the Active Directory account the MSSQLServer service is logging in as has "Send...

I agree with the above that the best way would be to force your users to use a particular account which does not have permission to update the tables.

However, if...

You do need Outlook installed on the server which alot of people don't like.

You also need to remember to start the SQL services using a valid windows account and not "local...

Ref my message in a previous thread... my favourite:

"There are only 10 types of people in the world: those that understand binary, and those that dont."

Artful Dodger featuring Craig David - Re-Rewind The Crowd Say Bo SELECTa

Ace Of DATABASE - All That She Wants

Chi-Lites -...

For what its worth, I don't usually go online to answer the question of the day but would like to see the available answers in the newletter (like we used...

I have got a question/suggestion: Is it worth checking the fill factor??  If you reduce this does it reduce the size of the database??

Other than that I agree with the...

I think that you can remove MDAC using a "comcheck" program which is available on the Microsoft website.

Component Checker: Diagnose problems and reconfigure MDAC installations

http://support.microsoft.com/default.aspx?scid=kb;en-us;307255

"Note: Removing or replacing...

I could be getting totally the wrong idea here but you could try this:

1. Right click on the pivot table and select "Pivot Table Wizard".

2. Click "Options..."

3. Under the "Data...

In our case, we have a separate SQL instance for the HR database as it contains alot of sensitive information.  With two instances you can have a different "sa" password...