I guess it would depend on if it is a production server and what the performance looks like with only one instance.

I only use it on our support environments after my nightly restores.

Good post, I was wondering the same thing. I was installing SQL2k8 yesterday on a VM for DEV with WS2008 as the OS and after the first instance I...

I see the same thing when i run dbcc shrink file in 08.

SK (6/9/2009)

---

There is a 2005 version which should work the same in 2008.

This URL takes you to that article:

http://support.microsoft.com/kb/918992

I haven't tested this out on 2008 yet, but the...

I could run the reports and then export them to a fileshare however that is painful for me. Any ideas?

I thought sp_help_revlogin was no longer available in SQL2k8.

I don't want to transfer them. I want to script them out to a .sql file so that I could restore them if the server catches fire. The...

Looks like this would be great for when rollback scripts aren't provided during deployment time!

It sounds like you need a fully functional "QA" environment. You should be able to take a backup of the database restore it to the "QA" environment, deploy the...

It sounds like you need a job that will purge and archive data on a scheduled basis.

About how many tables are involved? Do you have some sort...

I would think you would want to roll the changes out to a "QA" or "Staging" environment first.

This was a good article about my question.

http://www.intelligententerprise.com/channels/business_intelligence/showArticle.jhtml;jsessionid=WZC1VF2ZIT00QQSNDLPCKHSCJUNN2JVN?articleID=216900096

You could create a stored procedure and execute the stored procedure from vb

Try to disable the job and then enable it.

It worked for me.