Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2001
    Posts
    46

    Unanswered: Get my own Store procedure from Hosted SQL server.

    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.

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •