Skip to main content

All Questions

Filter by
Sorted by
Tagged with
2 votes
3 answers
2k views

SQL SERVER backup database into .sql file using script or cmd

I am trying to migrate from SQL SERVER 2012 to 2014 and found out I cannot use .bak files because of different versions. I know how to create a .sql back up file using the SSMS but I can't find a ...
Dekso's user avatar
  • 561
0 votes
2 answers
1k views

How to display the error message when using ":on error exit" in SQLCMD mode?

I have a query with T-SQL statements in SQL Server 2012 with SQLCMD Mode turned On running interactively in SSMS. There's a :on error exit statement. When I run the query, the query window shows "...
Tony_Henrich's user avatar