Hi ,

you can connect sql server using ip address.

use this >> ipaddress\instancename --> if it is named instance of sql server

use this >> ipaddress --> if it...

Hi dear,

Please check...

1. what is your service pack of sql server?? if u r using standard edition without without any service pack than u need to enable the trace flag...

ok.. Some time this is problem occur with window7 and

sql server 2008r2 dont worry try this

Run sqlserver management studio with run as administrator option and click on the...

This will work definitely Try this

update VectorReplica.dbo.PARCELS

set PARCEL_ID = A.new_pid

from Ranieranneaxparcels A

where VectorReplica.dbo.PARCELS.PARCEL_ID = A.NEW_PID

or if output is 0 row affected than you need to...