TipsOnLips.net

Your .net tips and tricks source

Author Name is someone.

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2010

When deleting all records from a SQL Server table, you may need to reset the primary key to start from

zero again when inserting new rows. Just execute the following script:

DBCC CHECKIDENT('TableName', RESEED, 0)

Categories: SQL Server

Posted by developer on Friday, December 14, 2007 3:20 AM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (0) | Post RSS RSS comment feed

Find an SQL Server database size and table space To get details about an SQL Server database using the following stored procedure: ...Add a database diagram support to a SQL Server 2000 databaseWhen attaching a SQL Server 2000 database to a 2005 SQL Server, the 2005 IDE would not support openi...Drop all triggers from any SQL Server database To drop all triggers from any database, execute this script: declare @trigger varchar(1000) decl...

Comments are closed