The only semi-good use of it I have ever seen was in a table that was for user-defined fields. The table included a "field type" and the data allowing...

rem

I would start by ignoring the disconnect issue for now.

You should set up a new maintenance process. It should not include rebooting the server or doing anything with the...

I'm low on ideas here.

I would try to copy the data into Excel and switch the connection manager out. Possibly try an ODBC driver for text files or the...

Do you have a specific reason you cannot simply select the count?

Well said Gail.

You care correct - you cannot use log shipping. Replication works fine though.

There is nothing really special to set up. Configure your publication on the SQL 2005 server...

A lot of it can depend on what technology you have on-hand and what type of data transfer you are doing.

For example, if you are transferring data from one SQL...

I have tested Diskeeper and found that it could leave corruption in tables with BLOB fields on large, heavy-transaction databases.

I was working on a document management system and it would...

What I meant was that writing great code is sometimes not a profitable endeavor. Everything has to be balanced. Corporate IT often means you compromise making the assumption...

Ok, so I went back and looked through your original post in some more detail also.

So if I am reading this correctly, when you run the package using the shell...

You are probably trying to argue at too detailed a level.

Management at most companies care about money and time. Ignore the "right way" argument completely and try to deal...

I have not found any tools that don't cause problems on databases of significant size (10gb or more) that have activity during the process.

It is the replacement for xp_SendMail. It uses SMTP to send email rather than needing outlook and a MAPI profile.

It works pretty well - look it up in BOL.

I'll re-read this in a minute in more detail to try to help a bit more, but right away I can tell you that the RUNNABLE process you are seeing...