Hi, I have a linked server in my set up I need to find the linked server dependencies.Could anyone please help me out with the query for it?.Also i need the query for getting the actual datasource of the alias server.Please let me know about it in detail
Thanks in advance
When you say dependencies, do you mean references to the linked server in stored procedures/functions etc.
You could search sys.sqlmodules
alternatively you could use 3rd party tools like Red Gate's SQL Search
answered Jun 15, 2010 at 07:57 PM
Kev Riley ♦♦