Scott,

Thanks for your post. We are planning our SQL Server 2008 installation, and this should help get that effort started. By the way, do you know if there is a...

I have a partial resolution. Our Desktop PCs are locked down pretty tight. An administrator logged onto my PC and ran:

assoc .sql=

This blew away the association, and I can at...

Tommy Bollhofer (12/9/2009)

---

Have you attempted to re-associate the file type via windows explorer? Right-click the *.sql file in windows explorer and select properties. Click the change button under opens with...

Tommy Bollhofer (12/9/2009)

---

Have you attempted to re-associate the file type via windows explorer? Right-click the *.sql file in windows explorer and select properties. Click the change button under opens with...

I spoke too soon. I closed Management Studio, and the old behavior is back. I double checkted the "Text Editor" information, and it is still blank. I'm not sure where...

It was empty earlier (prior to my post), but setting it for .sql didn't seem to make a difference.

Hmmm....

I just double checked. I thought I had cleared that out, but...

The white paper has a lot of what I am looking for. Thanks!

Hmmm... Is there any way to check on the health of SQL Server via SNMP? We have WhatsUp Gold Premium v12 installed here, and I don't know if it would...

Steve,

I created a SQL Agent job that intentionally fails so I can test this, and I tried the following command to read the SQL Agent job:

exec xp_readerrorlog 0, 2

However, I...

Thanks, Bru. I am very interested in seeing what you come up with.

Great! Thanks for the link!

FYI -

I found this article which expands on a way to collect a running history of drive free space using xp_fixeddrives.

http://www.databasejournal.com/features/mssql/article.php/3080501/Using-xpfixeddrives-to-Monitor-Free-Space.htm

Great! Works like a champ. Thanks!

GilaMonster (11/19/2009)

---

Since you're using SQL 2005 (or I assume you are, since this is posted in the SQL 2005 forums), use sys.databases instead. The statuses are neatly broken down in...

Sorry I don't see 65536 in the link...