use sp_msforeachtable to drop the identity column in all tables.

Grant Fritchey suggestion is good, do the same way. I was developed my database similar to this notation.

🙂

use DBCC Updateusage, DBCC PROCCACHE, DBCC SHRINKDATABASE command along with DBCC Shrinkfile get better performance as well as good for backup also. Just try it.

which operating system you are using ?

Suggestion:

> Repair IIS, if not possible then reinstall.

> Repair SQL Server.

> Repair ASP.NET.

The above things not working, then completely uninstall and reinstall all components.

use "sp_rename" see BOL for more information.

At the time SQL Server 2005 installation option, you can select option like "Sample Databases", at that time, you can install sample databases. Other wise you can download the...

See also execution plan.

See the below link, it may help to you:

Microsoft SQL Server Database Publishing Wizard:

------------------------------------------------

http://www.microsoft.com/downloads/details.aspx?FamilyID=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

🙂

If you are using SQL 2005, one built in exe is exist for compare tables.

Exe Name: tablediff.exe

Location: C:\Program Files\Microsoft SQL Server\90\COM

For more information see SQL BOL.

🙂

If you want to delete particular month data, use where clause in delete statement.

Use 3rd party tools or see the below link, it may helps to you.

http://www.microsoft.com/downloads/details.aspx?FamilyID=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

🙂

use "sp_spaceused" command, for more information, see SQL BOL.

use using(...) {....}, for more information see MSDN.

try the following:

update

set col2 = right (col1, 1)

Stop and re-start the MS-SQL Server Service thro' windows service manager.