How to list all the objects of another server

• reggae_blur

  Old Hand

  Points: 395

  More actions

  November 9, 2010 at 7:19 am

  #1248275

  one last question, do you know how to use SP_HELPTEXT, say I want to get the content of a stored procedure in ServerB by running it in ServerA?

  i tried SP_HELPTEXT 'ServerB.Database1.dbo.SP_Test' but it gives me an error.

  thanks in advance!

• muthukkumaran Kaliyamoorthy

  SSCoach

  Points: 19026

  More actions

  November 9, 2010 at 11:26 pm

  #1248683

  reggae_blur (11/9/2010)

  ---

  one last question, do you know how to use SP_HELPTEXT, say I want to get the content of a stored procedure in ServerB by running it in ServerA?

  i tried SP_HELPTEXT 'ServerB.Database1.dbo.SP_Test' but it gives me an error.

  thanks in advance!

  Did you read my prrvious replay

  FQN-- select * from [LSname].[dbname].[schema].[object]

  Muthukkumaran SQLDBA

  MCTS

  This is the object 'SP_HELPTEXT'

  Muthukkumaran Kaliyamoorthy
  https://www.sqlserverblogforum.com/