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: )

195 reads

Blogs

What goes around comes around : T-SQL Tuesday #129

By

I almost died. I’m sure a lot of you already know this but just...

My T-SQL Tuesday #129 Time Capsule

By

This month the T-SQL Tuesday invitation comes from Tamara Clark. I strong-armed Tamara last...

Azure Database Administrator

By

Recently I found out that I passed the BETA exam for Azure Database Administrator...

Read the latest Blogs

Forums

Send me an email if this job run longer than 30 minutes

By krypto69

Hi I have a job that I need to be notified/emailed if it runs...

Time out expired on the application side

By zouzou

Hi   I have an application that is timing out i run the query...

Sum function in CTE is not calculating the right balance

By Ysa

I have table with all charges and payment the charges are 'c'  and payments...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The D in ACID

See possible answers