Using Visual Web Developer 2008 which comes with SQL Server 2008 by default. Is there a way to change a SQL2008 database to SQL2005 version from within Visual Web Developer?
Cheers
A:
SSMS
How to: View or Change the Compatibility Level of a Database (SQL Server Management Studio)
EDIT:
Since you don't have SSMS (why not?) you can also issue this command to set the compatibility of a database to SQL 2005.
ALTER DATABASE [DATABASE_NAME] SET COMPATIBILITY_LEVEL = 90
Cory
2010-02-03 03:19:20
the environment does not have SQL Server Management Studio installed. I know, right? Needs to be done within VWD.
burntsugar
2010-02-03 04:04:23
can this command be run inside of VWD?
burntsugar
2010-02-13 01:00:06