You can look at my PushFTP article for sample text file creation. Also here's the ref from MS:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vtoriobjects.asp

Steve Jones

steve@dkranch.net

Your welcome. It'd be interesting to see how it goes. Let us know what works and what doesn't.

Steve Jones

steve@dkranch.net

Don't forget about your backups and how you manage them.

Steve Jones

steve@dkranch.net

I'd write a process to look for open transactions. If you find one, you can kill the conneciton and let the dba know. dbcc opentran will identify opn transactions. Of...

When you post, pls also let us know the physical as well as logical setup of the sever. Better yet, write it up as an article and send it to...

Someone go to TechEd and let us know!!!!

Steve Jones

steve@dkranch.net

That's funny.

I use EM everyday. I'm not trying to boot the tool, but it shouldn't, IMHO, be THE tool for scripting changes for your db. The biggest...

You are welcome. This one stumped me for quite awhile.

Steve Jones

steve@dkranch.net

My vote is to push what you can to the clients AS LONG AS IT DOES NOT substantially imopact the perceived performance of the client. You can upgrade the db...

I like Pauls suggestion.

Steve Jones

steve@dkranch.net

dbcc freebuffers or something like that. Search for it.

Steve Jones

steve@dkranch.net

If it's not too many jobs, I'd do as Robert suggested.

Steve Jones

steve@dkranch.net

Does the software connect via SQL Auth or Windows Auth? Can you run profiler and see if a connection is getting to the server?

Are you sure (just checking) you are...

Robert has my sugestion, but this might not do it all. Are teh connection passwords the same? Are all paths valid on the new server? Do the packages reference the...

Sorry for the delay, but let me weigh in here.

0% downtime isn't possible. No system in the history of the world runs with 0% downtime for any length of...