USE AdventureWorks; GO DBCC CHECKIDENT ("HumanResources.Employee&quo

how to rest identity columns in sql server

Question Posted / adhi

Answer Posted / adhi

USE AdventureWorks;
GO
DBCC CHECKIDENT ("HumanResources.Employee", RESEED, 300);
GO

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is factless fact table? : sql server analysis services, ssas

961

How do I open a .db file?

970

How to make remote connection in database?

953

What are the rendering extensions of ssrs?

142

What is single-user mode?

867

Find columns used in stored procedure?

933

What are cursors stored procedures and triggers?

932

What do you understand by sql server agent?

902

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

956

When a primary key constraint is included in a table, what other constraints does this imply?

937

How to start sql server browser service?

1065

What is scd (slowly changing dimension)? : sql server analysis services, ssas

951

What are the types of containers in ssis?

1090

How to list all columns in a table using odbc_columns()?

934

What are click through reports?

138