Not that I think it's the best way to go about it, but technically...

It should be possible, using the sql server agent in a couple of different ways, to send...

You can write a ddl trigger to be as narrowly focused as you wish.

Why is your structure changing so frequently?

http://msdn.microsoft.com/en-us/library/ms189826(v=SQL.90).aspx

http://msdn.microsoft.com/en-us/library/bb510741.aspx

"To find more information about any specific statement, either search for the statement by name in SQL Server Books Online, or use the Contents to browse...

http://msdn.microsoft.com/en-us/library/ms144259(v=sql.90).aspx

-Edit Sorry for posting what you already did Scott.

ScottPletcher (1/3/2012)

---

First, make a copy of the existing master data file(s) and log file (in Windows, not a SQL BACKUP). You may be able to read some data out...

Well, you could restart the database in single user mode and rebuild the master. But that puts you back to the default system configuration.

This means any logins,...

How important is this instance of sql server?

Do you have a recent backup of the master database?

What does your windows event log say?

Sounds like you want DDL triggers.

http://msdn.microsoft.com/en-us/library/bb522542.aspx

http://msdn.microsoft.com/en-us/library/ms186406.aspx

I wish it worked that way. :hehe:

Though I'll settle for happy...

Sounds like neither virtualization, nor throwing even more hardware at the problem will fix it.

We've had pretty good success in partnering with our vendors in sharing performance data such as...

What are you planning on doing with the data?

Ultimately does table B need to match table A?

If so you could do a snapshot replication, a trunk and load, merge statement...

I'm sure there is a better way. This was just fast to throw together.

This assumes you have dbmail setup and a valid operator.

Run this on the server you want...

I've seen a similar thing when there is a hard return in the subject line.

Is any part of the recipients, subject line, or body dynamically created?