ThomasRushton (6/3/2010)

You could do that, but it's horribly slow......

you wont be able to do it that way as you are only specifying one query,

to do this you have a number of options;

if your queries are a simple select...

you can export different tables from SQL server using the import/export wizard, you just need to select multiple tables in the source.

Or perhaps i am not understanding your issue?

select name as 'Database Name',CONVERT(char(10), crdate, 103) as 'Created Date', filename as 'MDF Location' from dbo.sysdatabases

you can use an Insert... Select.. combined with a delete from tableb at the end.

Then most likely the problem is as you stated in the first post, the different date formats are causing the issue.

I would run a select statement with a cast on...

no worries, a good way to see what is going on 'under the hood' of these stored procs is to run sp_helptext

sp_helptext sp_rename

quite often the comments at the top...

SP_Rename only works on the current database

Then thers is possibly data in that column that is not a true datetime and SQL will not be able to implicity convert this to a valid datetime.

Run a select...

Are the dates stored in a date type?

The format should not really matter as it is only used for display not storage

you can install it on the same server, the advantage is that the data does not have far to travel when building the cubes. The disadvatange is that...

you can restore a 2000 backup to a 2008 box, however you will not be able to do the reverse

You are probably better asking this question in a c# forum.

Here we will tell you to use Bulk Import or SSIS

I would then look at your contract you have with the customer and if legally appliable look at getting a lawyer to issue a letter to the other development company.

However...

This situation seems strange, do you all work for the same company?

I would first look for a non-technical solution to this problem involving meeting with the customers and...