Select DISTINCT o.Name, O.XType from dbo.SysObjects O inner join dbo.SysComments C on O.id = C.id where text not like '%' + O.name + '%'

This isn't 100% effective though.

Sorry, misread the question.

Why can't you just delete the tables in the right order?

Would be simpler and easy to reuse if needed.

Forgot to answer that one... It's a worst practice to call outside process from within a transaction (still in transaction in the trigger).

If you don't want to link the servers it's impossible. You'll at least need a job on the outside server that can connect to the protected server, but you...

TX... gonna have to download that beta someday .

How about a shipdate column???

So there's just a new datatype (varchar(max)) for using in functions/sps?

Glad we didn't show 'em how to use the sledge hammer.

HTH.

Alright... can't help you much there.

You can use EM to script all the objects you want.

If we got 100 bucks everytime we said that .

When you rename an object, its script create name is not modified (except for tables). You have to do it manually.

hmm.

Make the app write the record to a text file on a shared drive on the server that only the 2 server logins an nothing else can access. Then...

How are you gonna use that??

I would keep the original select, then use output parameters for the 2 others... or use the reporting tools to get those values.