Yeah I think I know that guy

I believe xp_cmdshell runs under the context of the SQLServer service account. You can set a proxy in Enterprise Manager, adn you might want to set this to your account...

I tend to agree. Even if you stop broadcast requests, I can still scan ports trying to log in and I'll get the login response. It's fairly trivial to...

You need either a backup or go buy Lumigent/ApexSQL/LogPI log recovery tool and attempt to undo everything.

Aside from Remi's thoughts. The server will check itself for integrity and let you know that transactions are rolled back or forward. The checkdb should get any other issues....

Jay is mostly right. There's one other thing. If you can't fix it, you can blame the vendor in closed source. You can't blame anyone in particular in open source,...

Grrr, I hate when people move links.

http://www.informationweek.com/blog/IWKconferences/archives/2005/04/the_plight_of_t.html

Sorry, they seem to come in waves, like everything else. Writing questions is hard. Want to try and send in a few? (articles@sqlservercentral.com)

The answers are in the books

http://www.sqlservercentral.com/store.

Or cut logs more often (back them up) and copy them to another file system.

Maybe slightly dated:

http://www.sqlservercentral.com/columnists/sjones/whodoyouhire.asp

I do think that Open Source has a place. And I certainly would like to see SQL Server as a Shared Source with customers that can afford to and want...

AFAIK, Derrick is correct. This makes it look like it's just an admin action

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0461.mspx

Put the simple script in a stored procedure?

There is no way to do this and the big guys, SAP, Oracle, Peoplesoft, etc. don't try.

I can always run profiler and see which queries you send and what data...