If I may add something.  What happens if you have more than one row afted by the transaction that fired the trigger? Is it acceptable that some files will not...

Now is the time to let them know what's important to you and

And what Steve??

This officially voids Microsoft warranty and support on that server.  In cases like this you can always COPY the object under a different name and make the modifications required to fit...

Hey guys I think he just needs a paging procedure.  Anyone got sample coding around?

Can you please tell me why my solution is not acceptable for you needs?  As far as I know you have a working solution and I can't offer any more...

You should ask that question to Ken .

BTW, the smiley face delete one character from my script.  Add a ) in place of the smiley to correct the error.

Also this question would have been better placed in...

You are better off letting the server do it for you.  This would be a good start for the table :

IF EXISTS (SELECT * FROM dbo.SysObjects WHERE Name =...

That's what I thaught but I don't have VS installed here so I didn't bother to try to fix the code.

Thanx in advance for the fix.

My guess is that it looks like Oracle but I ain't ever coded in Oracle so I'm not sure of that either.

Maybe if you could give us the requirements of...

It seems like a great tool but it never finishes running scripting.  It will output the data and objects of all the tables from any db or server (all different...

USE pubs

SET ROWCOUNT 10

SELECT * FROM authors

ORDER BY  au_lname, au_id

SET ROWCOUNT 0

SET ROWCOUNT 10 sets number of lines to return to 10.  It can be set using a variable.

The...

Or the Ninja remembers this line :

"I'm trying to understand where the conflict total count is coming from because the number of records in conflict_mydb_mytable doesn't match the total...

Then I second the other 2 dudes.

So that should make you enough votes to push another idea in the pot and roll over this one

Then I second myself.