Any process needing a unique number queries the LNU table to get the number and performs a delete statement. A Trigger on LNU for delete adds 1 to the...

We use a table named LNUs (LastNumbersUsed) with an integer value for LNU. There is a trigger on the table to update the LNU = LNU + 1 from deleted...

You need to first drop the constraint as well as the statistics using ALTER TABLE DROP CONSTRAINT <tablename>.<ContraintName> and DROP STATISTICS <tablename>.<statisticsname>

If sp_configure 'max degree of parallelism', 1 is set, will a query with MAXDOP 4 override the server setting?

http://www.databasejournal.com/features/mssql/article.php/2119721

This might be a point at which to use MSMQ to forward the results to the other server in a structured guaranteed manner.

If this login still needs access to the server to run a sibgle stored procedure, what can I can to implement that after sp_denylogin?

Thanks for the suggestion. Not all tables have the LastUpdated column so I will add error code to skip them.

The @@ROWCOUNT suggestion did the trick!

The NEW statement is:

DECLARE @SEQ int

IF @@ROWCOUNT <> 0

BEGIN

SELECT @SEQ = (SELECT SeqNbr FROM DELETED)

INSERT INTO tblActions(action_type, seqnbr) VALUES('U', @seq)

END

Rebooting the server did the trick, as I knew it would. I hope MS can come up with a better answer for production environments.

Thank to eveyone for replies.

We were selectively moving sp's from TEST to PROD database. Unfortunately, after the DTS pkg ran, we noticed that some tables which are dependent objects in the sp's were dropped...

RIGHT(<VARIABLE> + 1000000000000,<NUMBER OF CHARS IN FIELD TO PAD>)

David Nilsson (recycled)

That's a possibility. How is connection pooling controlled at the server level for all connections using EM, QA ?

David Nilsson

New machine is SQL SRV 7 SP4 and linked server is SQL SRV 2K. The link was fine before the migration. Now, we receive the error message that...

Wes,

Thanks for the input.

David Nilsson