Selecting Procedure Text through T SQL
Posted by
Venkat Varkala
Labels:
SQL Server
Imagine a situation where you cannot use Enterprise Manager with SQL Server like in my situation, the remote SQL server can be accessed only from our production server and I have no access to production server. Below T SQL can lets you see the stored procedure on the sql server. select text from sysobjects o, syscomments s where o.id = s.id and xtype = 'P' and name = 'ProcedureName'
Subscribe to:
Post Comments (Atom)
Post a Comment