sql server connect: Pulling stored Procs from a remote db -- sql server connect

Pulling stored Procs from a remote db

Jim McDonald
1/26/2005 10:07:39 AM

sql server connect:

Hi all -
I am trying to rebuild a website abandoned by the builder and an SQLServer
(I think 2k) db is used under it at the host. I can get at the db by using
Access/ODBC with a URL but the migration facility seems only to let me get
at the tables.
There are about half a dozen SPs referred to in the ASP code ( eg EXEC
sp_www) and I want to get hold of the code as I am not sure at all what they
are doing.
How do I get the code for each SP and store it in the local copy of the db?
Can I just replicate the db and move the replica to a local area?
Any advice on this gratefully (!) receive
Thanks
Jim McDonald

Re: Pulling stored Procs from a remote db

Tibor Karaszi
1/26/2005 11:15:08 AM

You can get the source code of a stored procedure using sp_helptext.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/

[quoted text, click to view]