Found 4 posts tagged with "sql-server"

• Setting your database Compatibility Level to match the SQL Server version

  7 March 2010 •

  sql-server

  This article explains how to set the Compatibility Level of a database to match the version of SQL Server. It provides a script that can be used on SQL Server 2005 and 2008 instances.

• Limiting CTE recursion depth in SQL Server

  14 December 2009 •

  sql-server

  This article provides a few different methods for limiting the recursion depth of Common Table Expressions (CTEs) in SQL Server, such as reaching the default maximum recursion depth, setting the MAXRECURSION query hint, or manually controlling the recursion level.

• SQL Server 2008 SP1

  13 April 2009 •

  sql-server

  Service Pack 1 for SQL Server 2008 is available for download, offering a rollup of cumulative updates and bug fixes. Despite lacking new features, the service pack is worthwhile due to the bug fixes it includes.

• Renaming a computer running SQL Server

  15 January 2009 •

  sql-server

  After renaming a computer running SQL Server, the value returned for @@SERVERNAME may not be updated. To fix this, run the sp_dropserver and sp_addserver stored procedures using the current @@SERVERNAME value for the old name and SERVERPROPERTY('ServerName') for the new. Restart the service for the change to take effect.