During a user group meeting one of the user asked that If we were to migrate our databases over to the evaluation edition of SQL Server 2005, is there a way of upgrading to the purchased (licensed) version (before the 180 day expires) without uninstalling or stopping the converted migrated running or production 2005 databases. The easy option is ...

Recently I have been stumped by not cliaming unused space correctly even though after delete handful of rows on a table. You may be aware using SP_SPACEUSED will get you details such as : Column name Data type Description database_name nvarchar(128) Name of the current database. database_size varchar(18) Size of the current database in megabytes. ...

A new Developer within our testing environment asked me this question to see whether they can use DETACH/ATTACH method than using ALTER database method. For the user databases it is available such method of DETACH/ATTACH method when moving the databases, but for system database it is not possible as they are in exclusive use for sqlserve.exe file. ...

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications The auto update statistics option, the auto create statistics option, and the Parallelism setting ...

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification , Contents: New and Major Modifications FIX: Error message when you use the Copy Database Wizard to move a database from SQL Server 2000 to SQL Server 2005 ...

SELECT DB_NAME(database_id) AS 'DatabaseName' , mirroring_role_desc , mirroring_safety_level_desc , mirroring_state_desc , mirroring_safety_sequence , mirroring_role_sequence , mirroring_partner_instance , mirroring_witness_name , mirroring_witness_state_desc , mirroring_failover_lsn FROM sys.database_mirroring WHERE mirroring_guid IS NOT NULL; ...

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Error message when you run a stored procedure that references tables after you upgrade a database from SQL Server 2000 to SQL Server 2005: ...

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications How to transfer a database from one collation to another collation in SQL Server http://support.microsoft.com/kb/325335/en-US Modified...(read more)

A stream of database compatibility numbers has come up to my mind while we are performing few configuration changes to the database to support a legacy application that can work upto SQL Server 2000. So what number we used during the days of SQL Server 4.0 or even before! 40 for SQL Server 4.0 & 4.2 (to my knowledge, as I have started working ...

Since SQL Server version 2000 better enhancement of three types of recovery models: simple, full and bulk-logged are fetching long-run support for all kinds of database activies. As you know such recovery models offer varying levels of recovery for restoring your databases from your backups, overall if there is a bulk data update then ...