Skip to main content

SQL Server 2005 Template Directories

If you want to be able to have your own template appear in Visual Studio when you add a new item to a project, this is where you will need to save it. Visual Studio 2005 Database Projects: C:\Program Files\Microsoft Visual Studio 8\Common7\Tools\Templates\Database Project Items Reporting Services 2005: C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ ProjectItems\ReportProject Reporting […]

What I’m Reading 23 Jan 2006

My Issues With SSIS Event Handlers (And Why I’ll Use Them Anyway) Jamie Thomson’s response to the above article Design Issue With SSIS BIDS Package Configuration Wizard SSIS: Be wary of using SourceSafe Enabling SSIS packages in Reporting Services Reports

SQL Server Agent (Agent XPs disabled)

SQL Server Agent (Agent XPs disabled)

When SQL Server 2005 Management Studio’s Object Browser shows the SQL Server Agent service with a red down arrow and the text Agent XP’s disabled, the service is not started or disabled. Start the SQL Server Agent service by: using the SQL Server Configuration Manger located in Start -> Microsoft SQL Server 2005 -> Configuration […]

What I’m Reading – 10 Jan 2006

A quick list of things I am / have been reading in the last week. Metadata tool and whitepaper for BI components SQL 2005 Metadata Samples Toolkit and whitepaper now available SQL Server 2005 Business Intelligence Metadata Whitepaper SQL Server 2005 Business Intelligence Metadata Samples Toolkit Indexes: An Overview and Maintenance for Performance Recovery Planning […]

How to Use ORDER BY in Derived Tables

I was asked today how to select distinct columns while ordering by another column that does not appear in the column output list. For example: select distinct [name] from master..syscolumns order by xtype If you try to run this code, you will get the error message: Server: Msg 145, Level 15, State 1, Line 1 […]

Rebuilding and Restoring Master Database

Over the holiday break one of our servers suffered a disk failure in the main raid set. The disk was replaced and the raid set repaired. All seemed to be going well, until SQL Server wouldn’t start. Checking the latest ERRORLOG for SQL Server showed: 2005-12-28 10:44:26.17 spid3 Starting up database ‘master’. 2005-12-28 10:44:26.18 spid3 […]

Rebuilding the Master Database

Rebuilding the master database is done using the Rebuild Master utility “rebuildm.exe” which is located in the 80\Tools\Binn directory of the SQL Server installation. Select the server and instance that you want to rebuild. Now you are going to need access to the files from the install CD for SQL Server. Browse to the Data […]

Restoring the Master Database

Stop the SQL Server instance. And start it in single user mode. Open a command prompt window. Change into you SQL Server Binn directory for the instance you are repairing (the default is c:\Program Files\Microsoft SQL Server\MSSQL\Binn) and run: sqlservr.exe -c -m The -c option tells SQL Server to run independantly, and not as a […]