Nevermind. I found it. That users email property in "Operators" had two addresses in it.

Yes we are on SQL 2005 and yes DMMail is setup.

Do you have a link to an "Idiots guide" on how to setup SQL job notifications?

Doesn't that feature require a MAPI client like Outlook to be installed?

Did you set the intial RAM size in SQL to at least 10240MB (10GB)?

Are you just looking from "Task Manager"? If so, it will not show the eunning instance of...

Nevermind, I found it. http://msdn.microsoft.com/en-us/library/ms187797.aspx

Murphy's law, post your question and you'll find the answer 2 minuteas afterwards....

lol..

No dice. It doesn't look like it is returning the entire trigger script. These triggers have at least a min on 100 lines it them. Your scrip only returns the...

My fault, I forgot to do outout as text.

OK looks like it may work but the addition of the 'Go' statement isn't there. I'll tweak it a bit...

The text formatting is all over the place and I get the error..

Incorrect syntax near 'inserted'.

Most likely because the text is all on a single line.

Any way of changing it...

Thanks but no.

I may have not been clear on what I want. I need to script out EVERY trigger as like a "Create to..." to a text file so I...

lol...

I was thinking the same thing.

She must speak in HEX.

"Restart the SQL service."

I knew you were going to say that.

What drew it to my attention is the test server ran out of space. I increased it to add a...

I checked the db properties and the physical size of the tempdb.mdf.

If they do not decline in size, what is the process to kill the tables other than rebooting?

Thanks

"table variables"?

These tables are taking 30GB of space for the tempdb.mdf. Will SQL eventually delete these?

Just curious, what's the CPU usage and the disk i/o? if both are pinned then you have a major issue. If both are not pinned then I don't see anything...

This may sound convoluted but it's only to protect your production data....

Take the same DB "AM20" and restore over a SQL 2000 server as a different name "AM20_Convert". Fix the...