Parse SQL script as 2005 in 2012?

Question

In SQL Server 2012 Management Studio, is there a way to to parse my SQL as SQL Server 2005 syntax? My development PC has SQL Server 2012 Express but the production server uses 2005. I have to hook into a 2005 development server to run my tests before pushing to production.

It would be really nice if I could test for SQL Server 2005 correctness from a 2012 server

Squirrel · Accepted Answer · 2016-07-12 01:43:02Z

1

use Compatibility Level.

For 2005, use COMPATIBILITY_LEVEL 90

ALTER DATABASE database_name   
SET COMPATIBILITY_LEVEL = 90

refer to here for more information https://msdn.microsoft.com/en-us/library/bb510680.aspx

answered Jul 12, 2016 at 1:43

Squirrel

24.8k5 gold badges41 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mitkins Over a year ago

Is there a way to do this temporarily inside the current script/transaction?

Squirrel Over a year ago

no. this is a one-off command. You can create a database and set it to 90 for your testing before deployment.

Mitkins Over a year ago

It's a pity there's no way to run an ad-hoc test for 2005 syntax

Collectives™ on Stack Overflow

Parse SQL script as 2005 in 2012?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related