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