Offhand, I think I would approach it like this:

make sure all databases are in full recovery mode

create a script which will backup all the databases

something like 'select dump ' +...

Yes, you have to name all the columns or it won't work.  I usually generate the column name and the commas from querying the syscolumns table such as:

select name +...

Would the top function help?  as in select top (1).....

Here's the answer.

http://support.microsoft.com/kb/816701

I believe that there's a particular OS setting that must be set on the server so that you can do distributed transactions.  Sorry I can't help further.

No, replacing the files using OS commands won't work.

However, you could use sp_detach_db to free up the files and then copy them to a named directory (20070328 for example)

When you...

I just realized that my post was somewhat confusing so I'm including an example:

set identity_insert customers on

insert into customers (customerid, name, address) select customerid, name, address from customers_old

set identity_insert customers...

Try

set identity_insert <yourtable> on

insert into yourtable (columns) select columns from othertable

set identity_insert <yourtable> off

The columns have to be named.

Carlos.

Yes, either of the solutions I propose will accomplish what you want.

Carlos.

Assuming that the data is in different servers...

As I understand, you have data in one table in one database that is not present in the table that the users are...

I normally use either linked servers and execute a copy from the remote server to the local for any rows missing (using the primary key) or, I extract the rows...

Matt:

I'm not sure that it would work.  I just stopped taking log backups for the database (relying on the backups that the log shipping configuration is doing).  I also do...

Matt:

Are you doing standard transaction log backups in addition to the log shipping backups?  If so, it's possible that your transaction log backups are interfering with the log shipping backups...

I know that this doesn't help you at this moment, but several years ago, the DBA's where I work made an agreement that all stored procedure would follow a predetermined...

Don't forget that the login who runs the SQL Server service should be a user who has rights to the network resources that you intend to use