Resetting the identity field in SQL Server

Resetting identity field in SQL Server can be achieved by following command

DBCC CHECKIDENT('table name', RESEED, number_you_need_to_reset )

For eg:
If your customer table is empty and wanted to reset the identity field value to 1 then use the following comand

DBCC CHECKIDENT('customer', RESEED, 0 )

So next time when you add a record the identity field value will be 1.

SQL Server Reporting Services Video download

Today i found a very good video tutorial on SQL Server Reporting Services and its really helpful for beginners to start with.

You can download the video here

Right clock on the link and select Save Link Location.

Watch the video and use full advantage of SQL Server Reporting Services. Its a better option comparing to Crystal Reports.