navigate to the below url:

Link: http://weblogs.sqlteam.com/peterl/archive/2008/07/16/How-to-get-IP-address.aspx

can you try the following way:

selectt2.Name

,t2.GroupName

,[Data1]= casewhen(t2.Data1 = 1)then t1.Data1

when(t2.Data1 = 0)then 0

end

,[Data2]= casewhen(t2.Data2 = 1)then t1.Data2

when(t2.Data2 = 0)then 0

end

,[Data3]= casewhen(t2.Data3 = 1)then t1.Data3

when(t2.Data3 = 0)then...

Just try like the following way:

Re-install / repair .NET Frame work 2.0 (with sp1)

Re-Install / repair SQL Management Studio.

Install SQL 2005 SP2 with latest patches.

Re-Start the SQL Server Services.

Problem is...

you can navigate to the below link:

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/CISQL2005ASCS.mspx

🙂

Check the Remote Host TCP/IP port configuration.

Check the configuration setting by typing the following command at Run prompt

SQLServerManager.msc

It's very simple, you can download the Microsoft Publishing Wizard from CodePlex site:

Link: http://www.codeplex.com/sqlhost

goto windows services and select SQL Server instance, choose properties and navigate to Log on tab...

go to the Start -> Program Files -> Microsoft SQL Server 2005 -> Configuration Tools -> Surface Area Configuration

and enable relevant properties.

use some third party tools (eg. Redgate tools, etc) to compress the backup data and then transfer data over WAN.

use some DBCC commands like DBCC UPDATEUSAGE, DBCC FREEPROCCACHE, DBCC DROPCLEANBUFFERS, DBCC CLEANTABLE, ...

for more information see SQL BOL.

If you are using SQL 2005, use TableDiff.exe, more information see the SQL BOL. It is a very good tool provided by Microsoft.

Just try it.

see readme file in SQL Server 2005 CD.

see SQL BOL for more information as well as example.

if you have any backup of database (which contains your sp), then restore it and find your sp.

use sp_msforeachtable to drop the identity column in all tables.