do all types of validations at front-end, this is one of the best validation, validation like length, datatype, etc.

If any error occurs, the identity column increment the value.

Otherwise, in you...

If you are using SQL 2008, you can pass table to stored procedure as a variable.

For more info see SQL 2008 BOL.

* Check the Execution Plan and optimize the query.

* Make transaction is very less.

* Do update statistics wherever required.

* Use hints in query.

* Create relevant indexes on table.

* Always use...

use OPENROWSET, for more info: http://www.mssqltips.com/tip.asp?tip=1202

use WAITFOR is one of the good option.

SQL Native Client not properly uninstalled, NET 2.0 frame work not properly installed for previous installation. I think while installing SP2 you are geeting this problem.

As of my knowledge,...

try like the following:

CREATE PROCEDURE dbo.cte_test( @CustomerNumber Int)

AS

BEGIN

if (@CustomerNumber = 100 or @CustomerNumber > 0)

...

Try like this:

* Ping the SiteA server thro' command prompt. (eg: ping ).

* Connect with SiteA IP Address.

* From SiteC: connect the Site A server using SQL Server Query...

Try like this:

* First you can create one folder in network drive and share it with full permission.

* Map the network drive (ex: created above folder)

* Open the SQL Server...

chek the link, and modify it: http://www.mssqltips.com/tip.asp?tip=1202.

SQL Server License information can be found in Control Panel.

Otherwise, do this way:

* Create one common login in Server A, B, C and give the permission as db_owner, db_readwrite.

*...

use Microsoft's Data Publishing wizard, you can copy table from one database to another database includes schema & data.

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

check the below link for more info:

http://www.microsoft.com/sqlserver/2005/en/us/pricing-licensing-faq.aspx

chek the TCP/IP setting and authorization of windows, etc. I think problem with per user / seat licence in SQL Server.

Dom,

First uninstall SQL Server 2005 completely (includes SP2). for more information see the link: http://support.microsoft.com/kb/909967

(in the above link, follow the Step 2 as it as).

After that install SQL Server...