Houston Chronicle

How to Reset an Identity Seed in Microsoft SQL

Sometimes, as when testing a table in a Microsoft SQL Server database, you need to reset an identity column to its initial seed value, typically one. During testing, you populate the table with data, ...
Redmond Magazine

Dealing with Negative Session ID Denials in SQL Server

Microsoft SQL Server MVP Denny Cherry breaks down multiple ways on how to troubleshoot a type -2 blocking session ID error. When we look at sessions being blocked in ...
Ars Technica

SQL Server Identity Crisis

[projectNumber] [int] IDENTITY (2000, 1) NOT NULL , [projectYear] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [description] [varchar] (255) COLLATE SQL ...
Ars Technica

SQL Server: SELECT SCOPE_IDENTITY() failures

Have an application written in Cold Fusion querying a SQL Server 2000 database which, as far as standard record inserts are concerned, has never has an issue.<BR><BR ...