I can see the reason for keeping databases segregated when you have a number of databases that each services an individual client and the databases are of high visibility to...

Perhaps my sense of humor is twisted, but the funniest thing about this prank are the replies from the people who are upset by it.

Thanks for the laugh.

phillip.snipes (1/19/2010)

---

Jason,

I'd like to give this approach a try as it fits our use case scenario quite well but, I do not see the table creation scripts for the objects...

Nice article. Thank you for taking the time to do this.

Thanks Nick. It looks interesting and if it's not too much to ask, I would like to see your solution published in an article so I can explore what it...

nlarge (1/13/2010)

---

Thanks Jason for your comment.

I would be very grateful if you could explain [or point me in the direction of] an explanation of how to extract information like the...

I would strike the word delete from this list and add DBCC CheckDB, alerts for fatal errors and error 825.

nlarge (1/12/2010)

---

Jason,

Just like in IT there is *most* of the time a solution that suits the problem. In this case, although the desired result is to *run* a package...

You are correct macqueen, the end conversation is missing.

Thank you.

Ben Sullins-437405 (1/12/2010)

---

Would this work if the SQL Database Engine was not installed on the same box as SSIS? To my knowledge SSIS packages can only be called locally and...

If you use the stored procedure, "start dtexec" won't be executed, but "dtexec" will and it will wait for the command to complete.

There is another advantage to using this as opposed to SQL Agent. You can regulate the number of packages that execute concurrently by setting the max_queue_readers value.

The following example would...

I rebooted and now it seems to be hung at the point where it tries to import the perfmon data. It's been hung at this point for about 10 minutes...

I found something somewhere in a google search where they were able to get it to work after a reboot. I'm going to give it a try later. I'll update...