Accessing stored procedures on another server

[AccessSQLUser]

Here's the story. I have a database on one server that I want to compare to a database on another server. What I want to do is compare the extended properties of the stored procedures and also check if there are any stored procedures in the first database that aren't in the second. I got this to work perfectly when comparing 2 databases on the same server, but how would I do it for a different server? I think that even if I make one a linked server, I'll still only have access to the data and not to the stored procedures.

 

[tlbroadbent]

You can execute stored procedures on a linked server. I'm not currently at work so I can't test this but you should be able to query the extended properties on the remote server.

Select * From Openquery(remoteserver, 'SELECT * FROM ::fn_listextendedproperty(NULL, NULL, NULL, NULL, NULL, NULL, NULL)') Terry Broadbent

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin