I am not sure if this will work but you can try deleting the constraint manually and adding it after the syncronization is complete

I have had this issue in our company when we have multiple domains. I connect to my laptop using my office domain and Remote Desktop into Servers using datacenter domain.

I think you can do this on Enterprise Edition only.

If your SQL Version is 2005 and above you can use the following query to insert the distinct clients

;WITH Client1 AS

(

SELECTFirstName,LastName,ClientName,SSN,RANK() OVER (PARTITION BY SSN ORDER BY ClientName) AS Rnk

FROMAcctImports...

You can create a job and let it run. That way you dont have to run it from your SSMS on your laptop.

What is your SQL Server version and what is your SSMS version ?

I noticed this problem if SQL Server is SQL 2008 R2 and your SSMS is older version like...

If I understand this correctly you want distinct Clients in Clients table. Why do you want the ClientName field in this table. My point is Client with SSN 000-00-0000 has...

You can use @profile_name to determine which profile is the email being sent from. You can use @recipients parameter to send email to any number of email addresses sperated by...

Dave

This is what I would do to copy table from SQL 2005 box to SQL 2008 box

1) Script out the table in SQL 2005 and create the table on SQL...

Our developer team uses Redgate Source Control

I think you can do this thorugh Powershell

We used Redgate until recently but we are starting to use SQL Server backup Compression since SQL 2008 R2. In our experience this is 5 times faster than Redgate.

Redgate...

Bulk-logged/Full is Recovery Model of your database. You can set this by going to the Database Properties and clicking Options

Sean

Is there any advantage to order by columnname over ordial position ?

The default Remote Query TimeOut is 600 seconds. You can modify this setting by going to server properties and click connection.