Visual Studio 2010 SQL Server Database Project - Ignore Stored Procedures and Functions

Posted by Carter on Stack Overflow See other posts from Stack Overflow or by Carter
Published on 2010-05-25T20:31:11Z Indexed on 2010/05/25 22:51 UTC
Read the original article Hit count: 289

I really like the new SQL Server Database projects in Visual Studio 2010. I also like using the "Generate DROP statements for objects that are in the target database but that are not in the database project" option in the deployment properties.

However, I do not want to manage Stored Procedures and Functions using this interface; I have another tool for that. Every time I do a build and deploy, VS will drop my stored procedures that I have created with my external program. I would like to essentially "ignore" stored procedures and functions.

Is there a way to ignore stored procedures and functions when building SQL Server Database projects?

I won't be able to use the "Generate DROP statements..." option if I want to use my external tool for stored procedures and functions.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about visual-studio