ASP VBscript get sql script of a stored procedure

Question

With microsoft sql server manager i know how to get this problem solved, but on the hosting where i am trying to update a old ASP Vbscript website i dont have access to this manager. and my question is: Is possible from ASP VBscript environement to access a stored procedure sql script ? and to see what sql queries were used for this stored procedure ? I know how to show their names but also i am interested in their content to know what tables do not touch with my modifications.

rlb.usa · Accepted Answer · 2011-03-03 18:27:08Z

2

Here's a nice little tutorial example

First, show all the stored procedures in the database:

SELECT * FROM sysobjects WHERE type = 'P' AND category = 0 ORDER BY name

Next, retrieve a stored procedure's contents :

SELECT text 
FROM syscomments 
WHERE id = (SELECT id FROM sysobjects WHERE name = '{0}') 
ORDER BY colid

answered Mar 3, 2011 at 18:27

rlb.usa

15.1k17 gold badges86 silver badges130 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Joe Stefanelli · Accepted Answer · 2011-03-03 18:31:48Z

0

You could run a query like this:

SELECT definition 
    FROM sys.sql_modules 
    WHERE object_id = OBJECT_ID('YourProcedureName')

answered Mar 3, 2011 at 18:31

Joe Stefanelli

136k21 gold badges243 silver badges241 bronze badges

3 Comments

Constantin Over a year ago

Joe thanks for your response but in my DB i dont have this table sys.sql_modules.

Joe Stefanelli Over a year ago

@Constantine: I should have asked what version of SQL Server. You must be using 2000 or earlier?

Constantin Over a year ago

i am not sure, it should be close to SQL Server 2000, because website was built before 2005

Collectives™ on Stack Overflow

ASP VBscript get sql script of a stored procedure

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related