Have you tried Microsoft Security Base Analyzer that check products for what levels of service packs and what patches need applied? That would do the trick.

I would love to, except all of our purchased apps require a SQL Svr authenticated login to use the app.

Up for discussion:

If you have a SQL Server at SP3 and then install Ent. manager on workstation and try and open up a DTS package on the workstation can you...

I second that from 'Veteran'. Does not exist today but will have something along those lines in SQL 2005. I have been wanting:

lock out the account after XX number of...

I know... it makes absolutely no sense. I did not do the install but the person who here did it said they will be creating a 15 gig database with...

Interesting thoughts... I (We) will be setting up a disaster recovery site a few states away next year and I have no experience in Log shipping... You have brought up...

Or, in Ent. Manager goto Taskpad of TEMPDB, look at create date. The TEMPDB gets recreated when SQL Server is stopped and started.

When you go into Ent. Manager and just review the service side options for Memory, Security etc you will get this message even if you do NOT change anything. If...

Another thing that one may forget about. If there IS a disaster who has key logons and passwords for connection pools to the databases? Are they recorded somewhere or does...

You are most likely correct. However, that is provided that you have good documentation and that it is up-to-date. I take documentation and disaster recovery very seriously. Anytime anything changes...

I agree with the article. However, if you purchase an app. alot of them insist that it MUST be done this way. I don't like it but have to live...

Since there have been no patches for SQL Server in quite a while some servers have been up for 6 months or more. About the only reason they get rebooted...

The nice thing is that yes, you can administer DB2, Oracle, and SQL Server (which we do here) all via the same interface. What I LOVE about DBArtisian is that...

I would be very careful. If you want to look for another job with another company that is fine. If you think you can goto your boss and demand a...

I guess what I don't understand is this db has existed for 4 months, running fine and then all of a sudden the failure.... Why now, why not from the...