Post reply

How to list all the objects of another server

  • 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!

  • 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/

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply