DBCC CHECKIDENT

By -

Question

Which command is used reseed the identity value?

Answer

DBCC CHECKIDENT can be used to manually set a new current identity value for the identity column.
DBCC CHECKIDENT ("Sales.ProductType", RESEED, 10);

Comments

Post a Comment

Popular posts from this blog

bulk insert into sqlserver using textfile

By -
Image
bulk insert into sqlserver using textfile Bulk insert sql server 2008 example I find so many issues while inserting bulk record in database.. Need to create temp table than I has to map all fields which is in file and in table than Insert it in to actual table but here is one Master command to insert record in bulk through simple statement.. Step 1 ) Create Table. create table AddressBook (id int,name varchar(50),address varchar(50)) Step 2) Create Text file with “,” delimiter. 1,John,India 2,Raj,India 3,Sonal,India 4,Roshan,India Step 3) Bulk insert record in to AddressBook table bulk insert AddressBook from 'c:\Addressbook.txt' with ( fieldterminator = ',' , rowterminator = '\n' )
Read more

What is ACID properties and How SQL Server Comply to the same

By -
What is ACID properties and How SQL Server Comply to the same Answer ACID  Propertied is Acronym for A- Atomicity-  Either all the operations/transactions are performed or None.Each transaction is said to be atomic if when one part of the transaction fails, the entire transaction fails and database state is left unchanged. C- Consistency-  This states that at a given moment of time the database is always in consistent. This guarantees that a transaction never leaves your database in a half-finished state. I- Isolation-  Isolation ensures that the transactions are separated(Isolated) from each other until they are finished. This means the transactions does not interfere with one another. D- Durability-  This ensures that once a transaction is commited it is available forever at any given moment of time. This guarantee that once the user has been notified of a transaction's success the transaction will not be lost, the transaction's data changes will survive ...
Read more

Sql Assistant

By -
Removing Most Recently Used (MRU) Server Names from the Connection Dialog The Server name drop-down list box in the Connection dialog stores the 10 most recently used (MRU) server names (see Figure 4-25 ). The Connection dialog stores the server name after it has successfully connected to the server. Although this is a convenient feature, there are situations in which you may want to remove the dormant servers from this list or remove all the entries for security reasons. You may also want to copy the list to another workstation or share it with another user. Figure 4-25 Making a DAC connection from Management Studio. The server name MRU list is distinct for each user on a computer. The list is stored in a file named mru.dat under the Application Data directory for each user: C:\Documents and Settings\ \Application DataMicrosoft\Microsoft SQL Server\90\Tools\Shell\mru.dat Importing Registered Servers from Enterprise Manager SQL Server 2005 provides the functionality to keep your SQL ...
Read more