Non-Stored Procedure SQL Scripts in a Database Project (VSTS 2008)

March 26, 2009 15:58 by randy

When storing SQL scripts in a database project, that are not stored procedures, VS will give you some grief.

Build Error:

Error    6    TSD7025: Unable to identify the schema type contained in the .sql file.  A schema type of 'Procedure' was expected, based on the name of the .sql file.

 

To get around this, update the properties of the file in VS to “Not In Build”.

image

Thanks for listening.


Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Comments

Add comment


(Will show your Gravatar icon)  

  Country flag

biuquote
  • Comment
  • Preview
Loading