Using Sql 2005 databases in Sql 2000 mode

Un poco de Microsoft SQL Server 2005 … en este caso, frente a la necesidad de trabajar con una base de datos en Microsoft SQL 2005, pero como si fuera una base de datos de Microsoft SQL 2000.

Después de navegar un poco,  encontré un Stored Procedure de sistema que permite esta funcionalidad.

sp_dbcmptlevel (Transact-SQL) 

Updated: 14 April 2006

Sets certain database behaviors to be compatible with the specified earlier version of SQL Server.

Syntax

sp_dbcmptlevel [ [ @dbname = ] name ]     [ , [ @new_cmptlevel = ] version ]

Arguments

[ @dbname = ] name

Is the name of the database for which the compatibility level is to be changed. Database names must conform to the rules for identifiers. name is sysname, with a default of NULL.

[ @new_cmptlevel = ] version

Is the version of SQL Server with which the database is to be made compatible. version is tinyint, with a default of NULL. The value must be one of the following:

60 = SQL Server 6.0

65 = SQL Server 6.5

70 = SQL Server 7.0

80 = SQL Server 2000

90 = SQL Server 2005

Note:

The values 60 and 65 are deprecated and will be removed in a future release.

Caution:

SQL Server Management Studio and SQL Server Management Objects (SMO) do not support compatibility level 60. If you use SMO or Management Studio with a database set to compatibility level 60, some operations will produce errors.

 

 

 

De no ser por este SP, supongo que debería empezar a pensar en una maquina virtual con W2003, SQL 2000, etc. Además de los probables problemas de perfomance.

Mas info –>http://msdn2.microsoft.com/en-us/library/ms178653(SQL.90).aspx

Saludos.

El Bruno

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s