Very well put Phil. This is what separates the 'wheat from the chaff'. Anyone who uses profanity (including blesphemy) is lowering themselves in my estimation; that is, my respect for...

Brad,

I think all of your points are spot on! I'm not sure why people are complaining about the last one - after all, being an 'atheist' is a form of...

As a follow up: I've dropped the server-level event notification and it now works. Recreated a database-level event notification and it still works. Could this be a bug in SQL...

I am sysadmin on the particular test server. Nothing unusual in the msdb database.

I tried it on a secondary server and it works fine there. I do use Event...

Times are changing and the technology with which DBAs have access to and use have improved greatly. Think of the great many monitoring tools out there!

I really think that a...

Read this DM best practice article from Technet: http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx

We recently had an issue that required PSS help. The reply from one of Microsoft's SQL Server Support Specialist was as follows:

So, in order to correct this problem I really...

That's how I use to do it. But now I'm not so sure. I think it depends alot on the environment that you are working in, whether retail, professional services,...

With SQL 2000 there were security hot fixes which are not optional. It would appear that most of the fixes in 2005 are not of this nature. However, if you...

When I double-click on a job in 2005 it does bring up the properties window. It looks like your computer is associating a double-click with a 'new job' window instead...

To keep an eye on the disk space, you could set up a job to alert you when the disk space is getting close to your comfort level. I have...

What's the point of that! Unless they are not 100% sure that everything will work in 90 mode? Don't trust your vendors and fully test your system yourself I would...

Which is why it is very important to perform an analysis using the migration wizard as a first step!

Paul

Well, according to msdn, this is what it has to say about sys.database_mirroring:

"Contains one row for each database in the instance of SQL Server. If the database is not ONLINE...

What you could do is to create a single job that checks the status of the database participating in database mirroring.

Essentially, this SQL Agent job polls every minute or so...