the script is for sql 2000, and the issue is the script will only run on the selected database and doesnt update the table owner from test2 to dbo. i...

Thanks you

Thanks for the clarification

i solved the problem. Had to run the following command to view the command associated with xact_seqno

Use distribution;

Declare @PublisherDB sysname,

@PublisherDBID int,

...

Hi Gail, Great article. However i have 1 question; Are you saying that when one issue the command backup log db_name with truncate_only it backs up the active portion and...