Note You cannot implement log shipping between two instances of SQL Server 2000 if one part of the log shipping pair is not an Enterprise Edition installation. Log shipping can...

the trigger always fires before the update is complete. it is part of the transaction.

In the trigger, work with the inserted and deleted tables to determine the values you need....

Thanks for the update.

Steve Jones

steve@dkranch.net

Not that I know of. I've loaded a couple mil, but never 7. I'll generate some data and try it tomorrow.

Steve Jones

steve@dkranch.net

I'll tkae a look tomorrow, but my guess is that there is a bug inthe parser for this insertr operatrion. sorry, tired.

Steve Jones

steve@dkranch.net

SQL 2000 will use the lowest lock it thinks it needs. For a single row insert, this will be a row lock. For multi rows, it might be a page,...

You'd restore the Sun full, Wed diff and wed log up to the time when the transaction occurred. Everything from that point until Thur would have to be re-run.

BTW, the...

good comments, but I'd still say that a good dba will not depend on the gui. he might use it, but will not depend on it.

Steve Jones

steve@dkranch.net

You won't get much in error trapping from using xp_cmdshell. If you need the trap, use FSO.

Steve Jones

steve@dkranch.net

No XP server, there is .NET, however, in Beta 3 now. I'd use W2K. Can't even buy NT now.

Steve Jones

steve@dkranch.net

Anytime, got to keep those DMO guys in their place.

Steve Jones

steve@dkranch.net

You are strictly paying for the name, not the product. Often is the same product, but the vendor is standing by it. For corporate IT who buy single source, this...

I did it with a table, just a simple create table Newtest( Myid int)

and then checked information_schema.tables as well as EM. Both show the owner as dbo.

Steve Jones

steve@dkranch.net

Haven't seen any issues with SP2 yet. Only on a test machine.

Steve Jones

steve@dkranch.net

Thanks Brian. MS isn't listing anything.

Steve Jones

steve@dkranch.net