"Stupid things might be said by other people and possibly yourself. Try to have fun and keep your stick on the ice."

They should sign on that one

Makes no difference in a exists clause.

Forgot that one... can always use delete in simple mode so that the log doesn't grow of of proportion...

I'll need much more info. Make sure you read this ALL befor posting back.

Help us help you

Generate insert statements

MAKE SURE YOU BACKED UP FIRST :

EXEC sp_MSForEachTable 'TRUNCATE TABLE ?'

Just split this into 2 recordsets. The first one is th elist of messages to present. The other will be for statistical info.

Just create a numbers table >>

IF EXISTS (Select * from dbo.SysObjects where name = 'Numbers' and XType = 'U' and user_name(uid) = 'dbo')

DROP TABLE Numbers

GO

CREATE TABLE dbo.Numbers (PkNumber int identity(1,1)...

Still doesn't answer the question of why you need ot have all those records sent to somewhere. Also that doesn't see awfully slow to me. I tried running...

That's what you have to learn in that question ::

CREATE TABLE dbo.A (PK int not null primary key clustered)

GO

CREATE TRIGGER dbo.trDemoA_IUD ON dbo.A

FOR INSERT, UPDATE, DELETE

AS

SET NOCOUNT ON

ROLLBACK TRANSACTION

RAISERROR ('Cannot...

That's why they bought a new server... looks like it was an application problem.

I already answered that. It can't be done correctly.

Why would you insert 5 records instead of one record with 5 as quantity?

HTH.

SELECT Object_name(parent_obj) AS TableName from dbo.SysObjects WHERE id = @@procid

HTH.