Script should be approved next week. If you want it I can forward it to you

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Or you could insert your data into a table variable, which has the identity column and return the data from that table, the example above will involve a nice table...

Just gone through eactly the same process.

The quad processor server I looked at also had faster memory and subsystem.

I went for the dual processor option, and spent some of...

Oh and set the recovery model to simple.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

The problem with such an update is the log that has to be produced to ensure consistency, and the locks put in place to do the update.

Sugestions, put a...

On the support issue, are you aware that if you have MSDN subscriptions you get 4 calls a year. may not sound much but in our dev team we have...

You need to look at arithabort and arithignore

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

No cos divide by zero is an error not a warning, warnings are like NULL eliminiated from aggregate

set ansi_warnings off

select sum(cast(null as int))

GO

set ansi_warnings on

select sum(cast(null as int))

Simon Sabin

Co-author of...

Are SQL Server and SQL Agent services running as domain users, its these domain accounts that you need to login in as. Minimum is SQL Agent running as domain account...

Hard to say with out seeing your code. You can copy millions of rows in seconds. Is your cpu, io, memory maxed out?

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

Have do done step 4 for the account SQL server is running with?

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Infering from what ADO does, just create another parameter for the return but ensure you create it first, the name should be irelevant but sould be declare as a return...

Is replication involved, if they are using identity ranges, could something of gone screwy.

I am sure you are aware as well of bigint which is an 8byte integer. allowing some...

Textcopy is fully explained in BOL

this is from a batch file I have that is used to insert our default document template

textcopy /S%1 /D%2 /U%3 /P%4 /TdocumentTemplate /Cdocument /W"WHERE master...

Have you stopped it from being a publisher. If not you will still have the triggers on the tables.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088