This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 26%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Hi Team,
we are in need of using the Create or Alter statement for stored Procedures in TFS. while building the project we are getting below error:
we are using VS2022 for our TFS project.
Create Or Alter Procedure MyProc
Build Error:
SQL70001: This statement is not recognized in this context.
Can some one help me how can we place the Create or Alter statements for SQL objects in VS TFS.
A family of Microsoft suites of integrated development tools for building applications for Windows, the web, mobile devices and many other platforms. Miscellaneous topics that do not fit into specific categories.
Answer accepted by question author
we are in need of using the Create or Alter statement for stored Procedures in TFS
TFS is just the source control system, it has not really a knowledge about your code.
So you are using Visual Studio with a "Database project"?
As the message say: In a DB project only "CREATE" statements are allowed, but not "CREATE OR ALTER".
The build process decides whether to CREATE or ALTER an object.
Remove the "...OR ALTER" from your code.
Thank you So much for your response. I appreciate your answer, but I am looking for using CREATE OR ALTER for my requirement, is there a way ? or is it possible to check-in TFVC & Azure GIT Repo?
After doing all the research, I came to know we cannot do Create or Alter statements in TFS.