George Parker-378530 (10/6/2009)

---

I ran into the same issue on a Windows clustered environment. When you apply SP3, it patches the database engine and the client tools for whatever node that...

Slick84 (9/22/2009)

---

I'm just thinking...

Could you possibly pick out a column you have suspicions on for being a potential PK candidate and then look for duplicates based on that column using...

Mark Pratt-396155 (9/23/2009)

---

In addition to the other suggestions. why not ask the business owner of the data for their thoughts? Some of them are intelligent enough to know what...

David. (9/22/2009)

---

Here is a completely different solution.

With as many rows as you describe, it seems certain that the source data acquisition application has performance problems.

If there are performance problems or...

UPDATE #test_destination

SET VALUE = ts.VALUE FROM #test_destination td

...

GSquared (9/16/2009)

---

If you're looking for natural PKs (which is what it seems you are doing), the definition will depend entirely on the nature of the data itself.

Are there columns that...

Michael Valentine Jones (9/16/2009)

---

You could start with taking a random sample from each table into a temp table to use for initial screening:

select top 10000 * into #t from MyTable...

Mike (8/25/2009)

---

Steve Jones - Editor (8/25/2009)

---

Log in with the current service account, and then try to access the share. If that works, you're one thing down.

Can you run...

do all of the following folders exist?

\data

\production

\ServerName

do all of them have the right permissions?

do the folder permissions on \data match the share permissions?

You can script out database by right clicking on the database -> tasks->generate scripts. you could also look into database publishing wizardhttp://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

I would check security log on the destination. your job might be trying to connect under the computer account, not the account that sql server (or the agent) is running...

you could set compatibility level to 90 (for 2005) or 80 (for 2000)

i'm still not sure what exactly you are trying to accomplish. if you are just downloading tables from source to destination, and need to replace type with documentno if type="credit",...

umas (8/21/2009)

---

I have to check for the value "Credit" in the DocumentType column (destination table) and if it is found, I should map it to the DocumentNo column in the...

I'm not sure I understand what exactly you are trying to accomplish, but it sounds like you should look into merge join. if you post ddl and some insert statements,...