Re: Get my own Store procedure from Hosted SQL server.
Originally posted by edmun3
RE: I have design my web and host it at ISP SQL server, unfortunately I have lost my Store procedure scripts and want to get it back from that ISp server.
1. Is there anyway to extract the stored procedure without using SQL DTS [ I have try it but only can backup my tables content/data only]
2. I can change my asp scripts direct connect to my ISP SQL server without doubt just like what I have hosting in their's.[I know my own admin password,but not the procedure wrote.]
3. ASK? Which asp/VBScript command can extract from their server without using DTS? Thanks in advanced.
Q1 [Is there any way to extract a stored procedure without using SQL DTS [ I have try it but only can backup my tables content/data only]]?
A1 Yes. since you can backup and access your tables, access YourDB..Syscomments. I beleive the syscomments column in which you will find your stored procedure tsql is named text.