are there any triggers on the table that may be doing a rollback ?

Hi,

there is a built in function to do this. look up abs in BOL.

HTH

Paul

we say "at at error"

hi, try something like :-

if not exists (select 1 from INFORMATION_SCHEMA.TABLES

           where TABLE_NAME = '{table_name})

begin

  create table {table_name} (columns ...)

end

Paul

hi, not sure what your exact problem is, but this might help :-

http://www.sqlservercentral.com/columnists/sjones/atemporarymove.asp

it explains how to move tempdb.

anyone think it could be horse racing ? lots of horses, course, jockeys , races and distances. and all around the world, all year !

all this is in the table designer in enterprise manager

hi,

hold the ctrl key down and select both (or more) rows. When highlighted, press the key button, and the key icon should appear next to both fields

HTH

Paul

Ian,

I don't think that there is an empty log file after 22:489:1, as it uses that for the first LSN for the next restore. I was wondering if loading an empty...

hi,

it is possible that the transaction logs that have errors are empty ? (as they are on smaller, quieter systems). it may just be complaining about an empty log.

HTH

Paul

hi,

change EXECUTE @tmpMessage to EXECUTE (@tmpMessage)

and your variable @tmpMessage should be nvarchar(4000)

HTH

Paul

hi, i still get 3 in both cases ...

Paul

hi, look at BOL for DBCC OPENTRAN, and see if you have any long running transactions , and kill it off if you have.  Or Look at Backup Log (IN BOL...

hi,

are you expecting it to return qwertyuiuoipthe ?

that's the result i get on my SQL Server 2000

Paul

hi,

how are you running the reports ?

Paul