Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    176

    Unanswered: Where do I save a stored procedure

    Hi,

    This might seem a basic question but please do respond. I created a stored procedure i.e wrote code in notepad using logic and T-SQL statements. I named this file as SP.sql. I put in in my C drive. I want it to be a part of database A. Now how do I transport this SP.sql to the Stored Procedures in Database A.

    Thanks

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    You can use - isql,osql,query analyzer, enterprise manager and even ASP, VB, etc.

Posting Permissions

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