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, ...

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 ...

I suspect that a Jet call to modify a field to identity might exist, but I have no idea what it is if it does.<BR><BR>If you're going to eventually be using SQL server, I highly suggest downloading an ...

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 ...