Skip to main content

Resetting IDENTITY

I’ve been asked plenty of times, how do you reset an IDENTITY column? After inserting data into a table, and then deleting everything, how do I make the IDENTITY to start from 1 again? Personally I think is a bad idea to reset identity columns to any value lower than they currently are. To find […]

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 […]

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 […]

SQL Server 2005 Goes Gold!

Microsoft has quietly kicked out the final version of SQL Server 2005 and Visual Studio 2005 to MSDN subscribers ahead of the Launch Tour 2005. The .Net 2.0 Framework has also been released, which you will need to install/use either of these great things. If you’ve been keeping track of SQL Server 2005’s development, you’d […]

SQL Server 2005 September CTP Released

SQL Server 2005 September Community Technology Preview (CTP) has been released today by Microsoft and is available for download now. The September CTP will be the last CTP/Beta before Microsoft releases the RTM/Gold version in November. Its available in the same five flavours as before: Enterprise, Standard, Workgroup, Express, and Developer. Microsoft have said that […]

Determining Store Procedure Creation Options

If you’ve scripted out a stored procdure, you’ll have noticed the SET ANSI_NULLS ON or SET QUOTED_IDENTIFIER ON options are also scripted. If your a verteran SQL coder, no doubt you set these before you create any stored procedures. But once a stored procedure is created, how do you determine what options were set? Well […]

SQL Server 2005 Database Snapshots

This is a really neat addition to SQL Server 2005. Database Snapshots are essentially a read-only, static view of an existing database, without duplicating all the data on disk. I use this feature a lot when I upgrade database schemas, or make major changes to data, and need to be able to compare the changes […]