SQL Server 2005 (DBA)
Last edited January 9, 2009
More by Wrong Guy »
Service Packs, Cumulative Updates and Hotfixes

Download details: SQL Server 2005 SP3
www.microsoft.com/downloads/details.aspx?FamilyID=...
 
 mssql2k5 SP3!!!
Labels: mssql, mssql2k5, service packs
Download details: Update for Windows Server 2003 (KB940349)
www.microsoft.com/downloads/details.aspx?familyid=...
Install this update to improve the reliability, scalability, and memory optimization of the Volume Shadow Copy Service (VSS) in Windows Server 2003.
You may be unable to execute SQL Server 2005 Integration Services packages that contain script tasks
support.microsoft.com/default.aspx?scid=kb;en-us;9...
The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released
support.microsoft.com/kb/937137/
Labels: SQL Server 2005, SQL Server, service packs
Labels: SQL Server, service packs, hotfixes, sp2
A list of the bugs that have been fixed in SQL Server 2005 Service Pack 1
support.microsoft.com/?kbid=913090
Labels: SQL Server, service packs, hotfixes, sp1
Security

How to transfer the logins and the passwords between instances of SQL Server 2005
support.microsoft.com/kb/918992/
This article describes how to transfer the logins and the passwords between instances of Microsoft SQL Server 2005 on different servers.
Labels: logins, DBA, database administration, sql server 2005
Installation/Configuration

How to change the SQL Server or SQL Server Agent service account without using SQL Enterprise
support.microsoft.com/kb/283811
Labels: services, mssql2k5, mssql, DBA
How to: Install SQL Server 2005 from the Command Prompt
msdn.microsoft.com/en-us/library/ms144259(SQL.90)....
How to: Install SQL Server 2005 from the Command Prompt
Labels: command prompt, mssql2k5, SQL Server 2005, unattended install, install
The supported Windows account types that you can use to run the SQL Server Agent service in SQL
support.microsoft.com/kb/907557/en-us
 
Labels: mssql, services
Good to Know

Unable to set Default Schema for a group : SQL Server Security : SQL Server : MSDN Forums
social.msdn.microsoft.com/forums/en-US/sqlsecurity...

This is the thread that was mentioned regarding the tracking of the issue:
https://connect.microsoft.com/feedback/viewfeedback.aspx?FeedbackID=238246&wa=wsignin1.0&siteid=68
 Conversation regarding why you can't set default schema for a Windows group.
Labels: mssql, SQL Server, mssql2k5, schemas
The content on this page is provided by a Google Notebook user, and Google assumes no responsibility for this content.