Wrong house, got 2 cats and a dog.

Maybe you can simply create a linked server. Then an instead of insert trigger would do this :

insert into LinkedServer.DbName.owner.Table (col1, col2, coln) Select col1, col2, coln from dbo.Inserted

First time I read that... I'll see what others have to say about this.

I'll have to see that video to be sure of that.

You don't even my adress... you could try to get your lies together before telling them .

AS I said, one of so many .

How's that coin tossing coming Sushila??

If it is recreated or changed, then yes. I've never heard that about DBCC REINDEX.

HTH..

Now don't go deleting the Model db... You actually need this one (just in case it's actually doable without a warning).

Thanx govinn...

Are you sure there's a match for 883??

Just on a final note, pubs and northwind are there only for demo and testing purposes. But if you don't need them, you're better off deleting them from the...

Top n from X rank (only one of so many ways)

/*

Ivica Masar

pso@vip.hr

*/

USE pubs

DECLARE @var1 VARCHAR(12)

DECLARE @var2 VARCHAR(30)

SET ROWCOUNT 17

SELECT @var1 = au_id, @var2 = au_lname FROM authors ORDER BY au_lname,...

It's not obvious but it's there :

in insert / insert (description)

sorry for the french version but I don't ahve the books in english :

INSERT [ INTO]

...

Any reason why the record is not directly inserted in its final destination?

What error message are you getting when trying to remove it?

If you are speaking about reasons not to do it, then there's none... actually it's a best practice to remove...

Select max(CrDate) as SecondMax from dbo.SysObjects where CrDate not in (Select max(CrDate) from dbo.SysObjects)