Definitely 2 (or more). I use RDP a lot and that is the primary use for the second screen. With high use programs like Outlook, SSMS, IE, RDP,...

Thanks, I've attempted to connect to SSIS remotely in the past but was unsuccessful. If I ever have the need to do it again, this will be very helpful.

In...

I couldn't live without Idera's SQLsafe and Red Gate's SQL Compare and Data Compare. Does that answer the question? 🙂

Solution does not work for me either, Win 7 x64. Since Windows 2008 Server R2 is also x64, maybe the issue lies there.

Nice article, thanks. I'm about to implement TDE on a couple of servers so very timely.

As you noted:

Sean Elliott (UK) (3/8/2011)

---

...my site only has one database that uses TDE...

c.masca (1/6/2010)

---

Thanks for the script - it lists scheduling info, but lists the job name as is. Would it be possible to also 'decrypt' the job name, somehow. we have...

chris.watson (12/18/2009)

---

Does any one have any experience in running integration services and reporting services under 2005 and upgrading to 2008 - are there bigger benefits here - I wonder as...

FYI for reference, another article that basically says the same thing, 2000 to 2008 or 2005 to 2008 Enterprise is worth it: Review: SQL Server 2008

Drew Salem (12/15/2009)

---

TerryS (12/15/2009)

---

Nice article. This appears to be a single server job monitoring tool. My need would be to do something similar for about 20 SQL servers...

Nice article. This appears to be a single server job monitoring tool. My need would be to do something similar for about 20 SQL servers scattered across 3...

Dave Coats (12/10/2009)

---

I have found that storing them to msdb on the server by choosing "File | Save Copy of Package AS" works best. Important: You have to...

FAST_FORWARD 🙂

Found the answer (of course seconds after I posted the question):

http://support.microsoft.com/default.aspx?scid=kb;en-us;826161

Awesome, I'll give it a try. I definitely think that'll save some time. Thanks for you help.

Terry

David,

Thanks for your reply. I dug into it yesterday and ending up writing the exact syntax you provided. Confirmation is always great.

My next question, is there an easy...