Grr. Rural satellite wireless connection = double post.

Sound advice, and I'll give it the try. The uphill curve is that I'm new at this company and thus the "other" DBA (of two), and my opinion doesn't carry...

Sound advice, and I'll give it the try. The uphill curve is that I'm new at this company and thus the "other" DBA (of two), and my opinion doesn't carry...

Do you have foreign key constraints? If the table being deleted is a "parent" table, then for every row being deleted SQL will check ALL related child tables to make...

The best you can do (that I've ever heard of) is to write a trigger that logs when an insert, update, or delete hits a table. There's no way (again,...

Don't know if this will help, but it's what we did back when:

 - SQL 7.0 default instance on the "source" server

 - SQL 7.0 default instance on the "target" server

 - Standard...

If you're trying to block users from connecting to (an instance of) SQL Server (as opposed to a single database), the quickest trick I've found to block logins is to...

When it comes right down to it, you can't convert SQL job durations to datetime values, because the duration is a measure of passed time--an interval--and a datetime is a...

A quick clarification: the backup problem had been going on for weeks, while the single user mode issue just cropped up yesterday (when they tried to apply the service pack)....

You can't stop SysAdmins, but you can slow them down. There was one table I didn't want anyone, particularly myself, from inadvertently messing up. I put a trigger on it...

Without actually reviewing the databases, maintenance plans, folder architecture, and files therein, this is very hard to address. Unless you've got very pressing issues dependent upon the presense or absence...

This issue got resolved, sorta. Details can be found in this thread (I hope the link works):

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=201317&p=2

   Philip

Have I mentioned recently that I hate databases in general, and SQL Server in particular?

Now it works.

I don't know why, and I probably never will know why.

All I do know...

If by "defined to SQL" you mean "granted login rights to the SQL Server instance", then yes, they are, and they have been added as memebers of the SysAdmin server...

Database maintenance plans (as generated and managed within Enterprise Manager) do not support the "no init" switch on the backup command. (At least not directly; I'm not familiar with the...