Reset Identity Seeds

This Script is used to reset the Identity coloumn to whatever the value we required. We need to compile this procedure in the database where we required to ressed the Identity coloumns of every table. After compiling we need to execute this procedure with a parameter of integer value. Then it will reseed the Identity […]

2006-08-29 (first published: )

196 reads

Blogs

Adding a Check Constraint to a Table–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Azure SQL Database Elasticity – Presentation Notes

By

This blog covers the content and points to the code used to create the...

How To: Create Schema Only Database Copies

By

Have you ever been asked to make a schema only copy of a database?...

Read the latest Blogs

Forums

query

By sankaripr

Hi i have 3 table that need to find out which id missing two...

Joining 2 select results into a single row

By mtz676

select( select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as...

deleted duplicate post

By mtz676

deleted duplicate post

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers