We have been using virtual SQL Servers for testing for some time and even have one (smallish) live database on a VM. We've had no problems. We are getting...

How about using the Profiler?

I'm not sure what you mean by creating the environment, but what you are looking for in SQL 2012 is SSIS not DTS.

You will need to have a date field if you are going to query by date. Well, do it easily anyway. You could write a query to pull...

Rimmer

If you can't get the powers-that-be to agree to buy a SQL Server license and server you might want to try to put in SQL Express (it's free). I...

It sounds like you might have missed or incorrectly set a setting on the Advanced screen of the New Job Step. There are two fields, what to do on...

As long as production users aren't being affected I don't see a problem with it and I think the only limit is your hardware.

You're fine, the update you applied was cumulative.

This will give you table name and rows:

SELECT sysobjects.name

, sysindexes.Rows

FROM

sysobjects

INNER JOIN sysindexes

ON sysobjects.id...

Is objects a user table or do you mean sys.objects (which you don't want to 'update')? Where are you getting the values for object number? What is...

Sorry, I don't have much time today to help, but there's one thing... have you looked at the records that were successful and compared them to the ones that were...

When you are running the import and you get to the 'Select source tables and views' screen have you tried to edit the mappings to match your existing table?

You could...

Got me there. I should have said who among my US East Coast friends who constantly give me grief about the rain here can laugh now.

BTW I do hope...

47 degrees and sunny here in the Pacific Northwest. Now who's laughing!