cant you run a profiler trace on users or certain people, whom you suspect of doing so. And if you catch them, then fire them?

see if you can put your requirements in the text field. I used to have a similar situation, but even limiting to dbid and objectid( that what i also had)...

Steve,

It is correct. So let me repeat my original question. If I saved original (old) links without forumid (relying on the design of a website), how can I access it...

Change a recovery mode to Simple, do a reindexing and change back to Full. Last step could be Backup and Verify. You could do that in a 4-Step Job. ...

PSSDIAG is very space consuming, and if I remember correctly is has to run from C Drive(?!). We had an issue about 6 months ago when we were running it...

can you change your recovery mode to simple when reindexing is being done?

we have 2 production databases at 600GB running on DataCenter. I would suggest to configure propertly RAID (we use 1+0) and filegroups, tempdb ( you may need much more then...

shot in a dark: do you have the same service packs/MDACS applied on all machines?

boot.ini should be there. It could'be been hidden.

Yes, we have about 200 hundred SQL Servers(6.5-2000; up to DataCenter). We have 3 companywise prod DBA on top of the other DBAs who work closely in each of the...

what you can do ( that we do in my company with few hundreds servers):

Create one central server, where you will be keeping all essential info about your servers. Link...

shot in a dark: Can it be open connections to your Server, AFAIR each open connections occupies 24kb. Also check out sp_who2 (sp_who2 active)

Shot in a dark, but you can add 0 ( zeroes) to the first union with the smaller amount of rows:

Select Customerid, 0 from Orders

Union

Select CustomerID, MemberID from your table

Which Service Pack you have? As far as I remember sp2 for SQL Server has memory issues....

My 0.02 cents

In addition you can/should monitor:

Logshipping (if any);

Replication (if any);

SQL Server logs;

Events Logs;

Failed Jobs;

Space Issues.........

I have over 15 items in my checklist, but as it was mentioned above, it largely depends on...