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 normalization? Explain different levels of normalization? : Sql server database administration

1304

Can group functions be used in the order by clause in ms sql server?

1009

Explain active/passive and active/active cluster configurations?

1056

How is table type constraint applied to a table?

972

Explain about sql server login?

1075

Explain SSRS Architecture?

195

Is it true, that there is no difference between a rule and a check constraint?

1033

How to defragment indexes with alter index ... Reorganize?

1075

Does a sql server 2005 select statement require a from?

1014

Can we delete data from a view?

918

What is the difference between a view and a stored procedure?

1030

Explain the use of containers in ssis?

954

What is user-defined multi-statement table-valued function?

1051

Can a table have 2 primary keys?

978

What is page-level compression?

954