Here are some more free tools that I use a DBA. You can google the names to get the to the web sites.

DTSBackup2000 - Backup and restore DTS packages. Easy...

Your question is a good one, but I think the question needs a little tweak. I think the question should be

"Should MS make a new release every 2-3 years...

Why are "New Features" being released with a "Service Pack"? Why can't MS just put all the bug/fixes into Service Packs and newer feature into Feature Packs? This way we...

Yes! Thank you for all your time on this. Now I can make the auditors happy.

Rudy

Thanks Greg but not really. Below is the output I'm looking for

DB_Name: Northwind2

User_Name: jsmtih

Table_Name Access_Type

Customers INSERT/UPDATE/DELETE

Sales ...

I too am not looking forward to retirement, but when I do I think I will continue to play with computers as his passion started as a hobby at 16...

I have seen this problem before and here are 3 thing to try.

1) Using this script to see if SQL is clustering

--

xp_cmdshell 'Ping -a 127.0.0.1' --to see which node is...

Here are the tools that I use. I am the only DBA for over 300 instances of SQL 7.0.2000 and 2005.

-SpotLight for SQL/Server - great monitoring/diagnostic tool.

-DTSBackup 2000...

Since I have over a 100 DB servers (7.0, 2000 and now 2005), it took a long time to check just the status of the jobs that ran on these...

I'm currently using SQL SpotLight by Quest. (http://www.quest.com/spotlight_sql/) It works great and also has a very nice GUI front end to it too.

Excellent!! Works very nicely Do you have any code that will dump(to a file) all user permission, writes, etc so that once I...