locked
SQL Server Management Studio and Visual SourceSafe RRS feed

  • Question

  • The develpment team where I work is using Visual Studio 2005, SQL Server 2005 and Team Fundation Server. We want to somehow track changes of the stored procedures. We could create a Solution/Project in the SQL Server Management Studio, add all stored procedures to it and add that Solution/Project to the SourceSafe but nothing will stop developers from directly altering stored procedures.

    Any ideas on how to prevent developers from making changes to the stored procedures directly?

    Thanks.

    Friday, January 12, 2007 8:30 PM

Answers

  • in SQL Server management studio,

    1.  right click on any specific stored procedures that you want to set restriction on.

    2. Select property

    3. Under "Select a page" pane, select "Permissions".

    And you can setup various permissions to this specific store procedure by granting permissions to a specific role / user.

     

    hope this helps. :-)

     

    Thanks.

    Thursday, January 25, 2007 3:03 AM