#1
  1. No Profile Picture
    Contributing User
    ASP Discoverer (100 - 499 posts)

    Join Date
    Dec 2005
    Posts
    150
    Rep Power
    0

    Microsoft SQL Server Management Studio Question


    I am new to writing stored procedures and this will be my first stored procedure written with Microsoft SQL Server Management Studio. I am familiar with working with VS 2010 and I have noticed that the IDE is very different. So, let's start with the basics. How do I go about adding a new stored procedure into the group of stores procedures that the project currently has. I already know that name and the T-SQL code I need. I just need to put it.
  2. #2
  3. No Profile Picture
    Contributing User
    ASP Discoverer (100 - 499 posts)

    Join Date
    Dec 2005
    Posts
    150
    Rep Power
    0
    How do I save it? In the Object Explorer, there is already a list of stored procedures and I want my stored procedure in that list.

    You see, I am accessing this stored procedure through a C# WPF user interface
  4. #3
  5. 0x800A0C93
    ASP Super Hero (2500 - 2999 posts)

    Join Date
    Jan 2009
    Location
    Ridin' through this world...
    Posts
    2,975
    Rep Power
    1314
    Originally Posted by Athono
    How do I save it? In the Object Explorer, there is already a list of stored procedures and I want my stored procedure in that list.
    I dunno. This is my guess. I don't think it is real intuitive on on how to do it.

    right click stored procedures
    select new stored procedure
    on the line
    CREATE PROCEDURE <Procedure_Name, sysname, ProcedureName>
    make it look like
    CREATE PROCEDURE [ownername].[procedurename]
    like
    CREATE PROCEDURE [dbo].[mything]
    delete the rest of the stuff in the file unless you want it and paste in your transact sql
    execute it
    refresh your stored procedure list
    it should be there and it might work
    Brinkster- free development account. Not affiliated, but I sure like free. Brinkster.com

Similar Threads

  1. Access 2000 ADP to SQL server 2005
    By maij in forum Microsoft Access Help
    Replies: 1
    Last Post: February 16th, 2007, 07:34 PM
  2. SQL Server Management Studio
    By klegrand in forum Microsoft SQL Server
    Replies: 1
    Last Post: May 9th, 2006, 02:49 AM
  3. MSDE 200 installation failed
    By mzungu in forum Microsoft SQL Server
    Replies: 1
    Last Post: October 6th, 2005, 01:14 AM
  4. Web serverístatistical analysis
    By cso in forum ASP Development
    Replies: 0
    Last Post: April 19th, 2003, 12:35 PM
  5. ASP, VB, SQL Server, Cold Fusion, COM
    By Steve Schofield in forum Programmers for Hire
    Replies: 0
    Last Post: June 29th, 2000, 03:07 AM

IMN logo majestic logo threadwatch logo seochat tools logo