Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Enabling Version Control for Stored Procedure in VS.net

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-06-06 : 08:08:40
Tushar writes "Hi,
I am using Visual Studio.net 2000 for developing web application.
I am using SQL server 2000 as a back end tool.
I had some stored procedure in my database. I want to edit and debug stored procedure from VS.net IDE. Also I want to keep version control for the same. I checkd for the option in IDE.
I found it in Tools Menu >> Options Menu >>Database Tool Tab >> Server Explorer. But I am not able to use it as it is disabled.
I checked with other knowledge base articles ( From Microsoft ). It seems that it will work only with VS.net 2003 IDE. I am not sure.
Can any one guide me.??"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-06-06 : 08:34:47
An even better way is keep your procs as script files, create a Database Project in VS.NET and add a reference to your db. Then you can add all your scripts to source control.

All good.



Damian
Ita erat quando hic adveni.
Go to Top of Page
   

- Advertisement -