A much quicker way if you can get away with it... 🙂

1) Send an e-mail out to everyone who has a good knowledge of your environment with a list...

Does Litespeed not have something built into it to help you set that up?

Just out of curiosity, anyone ever actually created (or seen) a server with 50 instances of SQL installed on it? Most I've ever done is 6.

We had a simlar thing happening several months ago on several non-clustered SQL servers after upgrading to SQL 2005.

We ended up finally tracking it down to a 3rd...

Good question!

No, it was a tear of Joy!

None that I've ever encountered.

Wonderful...brought a tear to my eye!

Jack Corbett (12/23/2008)

It sure is. I think a lot of resumes...

So should posters take it as a compliment that someone was able to fake an interview with SSC posts, or as an insult?

I've also looked at a post or two...

Oh, yea, if you have the DB attached somewhere you can just query out of the system tables.

I'm not sure that will make the script any easier to...

You can use RESTORE FILELISTONLY to get a list of the files in the database.

I would argue that a snapshot is a form of backup. I realize it can't be used if the source database is physically gone, but you can revert from...

What type of web app is this? (i.e. ASP, .NET, JAVA, PHP...)

If it's reasonable, can you post the code that calls that SP and your configuration settings for the...

Might play arround with the built-in alerts that SQL has. In SSMS, drill into the SQL Server Agent node and right-click on the Alerts folder and click new alert.

It...