Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Location
    Midlands
    Posts
    135

    Unanswered: Where to write "exec" Stored procedures in code

    Hello all,

    INTRO:
    New to this world of Stored Procedures so will probably need a lot of help. I'm learning Stroed procedures daily, but have a project that is running in tandem with me learning of this new concept.

    BACKGROUND:
    the project is a new intranet, in which the structure was set up by my manager, however he is no longer here, and I have the task to keep it moving forward, and try my best to complete it.

    QUESTION:
    staff in the company need to have access to areas that relate to them and their department, and this has been set up with the aid of Stored Procedures. however I'm not entirely sure where they, or any additonal information (if any) needs to be / should be placed.

    Any help, or information would be great.

    Kind regards
    mind_grapes

  2. #2
    Join Date
    Jun 2009
    Posts
    26
    Hi Mind_grapes,
    I'm not sure if I'm reading you correct but stored procedures are stored in the database itself. If you know your way around SQL Enterprise Manager / SQL Server Management Studion then the stored procedures in your database can be found under <server_name> --> <database> --> <programmability> --> <stored procedures>

Posting Permissions

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