How about logging some status messages from within your stored procedures? Can be something as simple as logging the current datetime and a message to a table.

EG:

26/08/2005 12:00 PM job...

Best option would be to create a dataset that has the date range you want. Then set your report parameter to be query-based.

"Simple Recovery" or "frequent transaction log backups" won't help if the conversion is one large transaction.

Simple Recovery mode will clear the log once a checkpoint is reached, like a commit...

The error 0x80004005 is access denied. Check the permissions and accounts used for the services and in the Linked Server setup.

Robocopy has an annoying "feature" in having non-zero return codes that indicate success. What I used to do was execute ROBOCOPY in a VBScript. Capture the return code and exit...

Nice procedure. However, I'd use some sort of flagging instead of a GOTO loop. If you combine the SET assignment with a query, you can return the status with extra...

Also, you can "roll-back" to prior versions by opening the old version and saving the package again. which creates a newer version.

I posted this in the script library ages ago to remove old versions.

http://www.sqlservercentral.com/scripts/contributions/606.asp

This removes the version and the logs associated with that version.

It might be an idea to setup a...

What's probably happening with the DTS packages is that you've got more than one version for each package. Every time you save a package, even if you don't make any changes,...

There is no such thing as being lucky in the DBA world

Make sure you run it in the msdb database. As shown by the output, this list is from the master database.

Also, just a tip, I wouldn't be letting anyone...

Ahh ... no ... what would be the point? How could you guarantee the integrity of the data given that you'll be missing a whole pile of transactions. Its most...

If the column already has data, then you can't change it to an Identity.

If you can clear the table, then you can alter the column to an identity. If the...

Sorry, forgot that sp_MSforeachtable only iterates through user objects. Try this instead,

SELECT 
    db_name() as db
    , sObj.[name] as TblName
    , sInd.[name] as IndName
    , CONVERT(int, sInd.rowcnt) as...

You can adjust the size of the commit by playing around with the 'Fetch Buffer Size' and 'Insert Batch Size' figures on the Options tab of the Datapump properties dialog....