Funny, my kids call me "The Man" also, but I don't think it's a compliment when they say it.

Not sure what you mean. SQL-server never reformats my procedures and views.

Can you give a step-by-step example?

Like this:

INSERT RemoteTable (CompanyID, CategoryID)

SELECT CompanyID, CategoryID

FROM LocalTable AS LT

WHERE NOT EXISTS (SELECT * FROM RemoteTable RT

WHERE Rt.CompanyID = LT.CompanyID

And RT.CategoryID...

Well, I'm glad one of us helped. 🙂

Nice article, Gus.

I would think so, yes.

I cannot test SQL 2000, but I believe that this should work:

Declare @sql varchar(MAX)

Set @sql = ''

Select @sql = @sql + 'USE ' + name + '

select '''+name+''' as DBName,...

"Order BY Node" looks like it would work on your data.

If the compressed stream returned is really binary data (and it usually is) then it should be stored as VarBinary(..) or Binary(..).

Heh.

Yes, GSquared, we expect that the free work donated by the unpaid experts at this site reflect a higher standard than that. :rolleyes:

Do you want to list their Names, or do want the listings (scripts) of all of the Triggers?

Well I would do it like this on SQL Server:

insert

into t

select TOP (100000) Row_number() Over (order by c1.id, c1.name, c2.id, c2.name)

From master..syscolumns c1

...

yes it is.

Perhaps is you give us some more information we can help you. See this link: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Glad I could help.

Are these free e-books, copyright-compliant? I cannot find any statements to that effect on that site.