This list is extremely helpful. I can never seem to find the info at Microsoft. Would you please add the link for the your 2012 list? (http://www.sqlservercentral.com/articles/SQL+Server+2012/87518/)

Sorry, you are correct I should have sent an example. Here is the code that goes into the policy based management expression field of the condition:

ExecuteSql('Numeric', 'SELECT Isnull(SUSER_SID(@Name),0)')

As I stated...

Yes, that is what I am doing. I was just hoping that I would be able to use the supplied column. Thanks.

No, it is added to the results if you go to OPTIONS->Query Results->Multiserver Results-> and make Add server name to the results TRUE.

Russel,

Thank you very much. Your links lokk like exactly what I was looking for. As usual I have been handed an assignment that tie me up for the next 1...

Thank you very much for the link and pointing me to EPM Framework. I googled it and found a recorded webcast that is very interesting on this subject.

Thanks ALZDBA, I was rather tunneled vision and was googling DBCC TRACEON 1140.

Thanks Rahul, We are running SQL Server 2008 SP1 (10.0.2531). Did Microsoft give you any KB for this Traceflag? I have tried to google it and what little I have...

Jeff, Would the execution plan show anything if it usually runs fine but then suddenly goes into a loop that will fill the tempdb no matter how large we make...

It is the data file. I am not sure about the cursor use. Like I said this is a very complex routine. It looked like once when we looking at...

We have put a limit on tempdb. But this still doesn't look like it will tell me what is actually being written to tempdb. He has temp tables tat are...

MY APOLOGIES!!

Elliott, Thank you for forcing me to use my brain for something other than to just keep the sides of face from collapsing in. All the items you asked...

I would just truncate the table.

San, You are correct I am wanting to ad "non-maintenance plan tasks" from the Control Flow Items toolbox.

What I am referring to is let's say at midnight I do a full back up of all databases and no other updates are done to them. Then an electrical...