SQL

How To: Reset Identity Column Value in SQL Table

Recently, one of the members at forums.asp.net is asking if how to reset identity count in sql table. So I thought of sharing the possible solution that we have discussed in this thread as a reference to others. HTH! Technorati Tags: ASP.NET,SQL,C#...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Thursday, September 10, 2009 2:17 PM | Feedback (0)

Adding ASPNETDB.mdf file to SQL Server 2005

By default ASPNETDB will be automatically created under App_data directory in your application if personalization is use for the first time.If you wanted to locate ASPNETDB file in your Own Database (SQL Sevrer 2005) then just simply do the following -Copy the ASPNETDB that is located at the App_data Folder in your Apps and paste it anywhere in your drives.. the after copying -Remove the ASPNETDB in your App_Data folder -Open SqlServer 2005 or Studio Management Express -Right Click on Database Folder...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Monday, February 23, 2009 4:40 PM | Feedback (8)

 
Powered by:

Copyright © Vincent Maverick Durano