Thank you Steve for articulating this challenge for it was very well stated.

Gail,

I have to say that I'm very impressed by your post and articles. You add a lot to the forum.

Thank you,

Welsh

Perhaps a distinquest professional that is a member of this forum could add or dispute my suggestion with respect the use of the SQL DIag Utility or any other diagnostic...

SQL Server Consolidation Professional Consultants as well as Microsoft SQL Server Server Support Staff use the SQL Diag Utility to assess the feasibility of consolidation of candidate databases as well...

Please try goggling on the error. I found various hits but I was not sure which scenario matched your situation.

Have you tried the DTS export wizard?

If you wish to become more advanced you can go into the DTS Designer and/or write code to accomplish this simple objective.

I would happy...

I have preformed many Access to SQL server and Oracle Conversions.

I would suggest that you do not use a migration wizard.

You should carefully examine the differences in the data types...

Please chack the following links:

http://www.phwinfo.com/forum/ms-sqlserver-server/340709-db-mail-error-formatting-query-probably-invalid-parameters.html

http://social.msdn.microsoft.com/Forums/en/sqltools/thread/bac7ecee-a156-4313-b532-ba15813a0700

http://relatedterms.com/ViewThread.aspx?t=1628286

If this does not adress y9our problem I would sugesst that y9ou google and I;m sure that you will find a solution to your problem.

Regards,

Welsh

Have you ever used the SQL Server SQLdiag Utility?

This is a very usefull utility used in analyzing in the databases consolidation process:

http://msdn.microsoft.com/en-us/library/ms162833.aspx

Posted by mistake...

I have to agree that Brad's response was excellent

Gail's article was excellent as expected.

Good point on the Transaction Log Backups.

I worked at a place where I found that they were truncating the transaction log backups and sending an Alert when they became full.:hehe:

Also...

I would advise you to routinely test your backup & recovery.

You may think that you can recover but when a disaster strikes you may find that you do not have...

I wrote a program years ago that would delete records as defined by batch size.

The batch size was defined in a control table. I also had a column that defined...

Please refer to the following links:

http://drsql.spaces.live.com/blog/cns!80677FB08B3162E4!281.entry

http://www.coderjournal.com/2008/08/deadlocked-read-committed-snapshot-explained/

http://decipherinfosys.wordpress.com/2008/04/18/

I hope this helps...