Erin, I appreciated the great articles, but we are not up to SQL 2005 yet:crying:.

Do DBA's still stuck in SQL 2000 have any way to script a baseline capture?

Bill Beadenkopf

Stonegate...

One possibility is that the server is checking Windows authentication first, automatically. The user would only see the dialog box where she enters the 'sa' log-in.

I ran...

I already was a local admin, but that thought got me to trying an osql command using the windows login.

OSQL -E -S "Servername" -d master -Q "EXEC sp_defaultdb 'Login', 'New...

There is definitely something to say for user managed reporting. I don't know how many 'great' projects I have created that are now gathering dust, because nobody is using...

I did get it to work. Right now I don't remember exactly what I did, but I think the key was saving it to a file named using the...

The recovery model is set to Simple. I guess it was set to Simple because we had no need for the point of failure recovery at the time. ...

I triggered an automatic backup by changing the scheduled time for backup, so I think I'm safe, but I would still like to know how to do a manual one.