Osolage's sqlserver clipmarks

Most Pops

see Most Pops

See all clipmarks by Osolage

See all public sqlserver clipmarks

top

scroll

end

1
POPS SQL Server 2005 List all IDENTITY columns

by Osolage 12-12-2007

When I upgraded one of my databases to MSSQL2K5 compatibility mode, I noticed that many of my insert statements on tables with identity columns started generating primary key violations. I realized that I needed to run DBCC CHECKIDENT on all of those tables to fix the problem. I found this script, which lists all of the tables, in a database, that have identity columns. Then a copy/paste and regex search/replace generated a script for me to run the DBCC CHECKIDENT for each table listed. After running the DBCC CHECKIDENT, the problem went away.

1
POPS Why you should carefully monitor DB server disk space

by Osolage 5-8-2007

No Remarks

— end of the list —