Chandhini (4/13/2010)

---

Hi,

I have a table called Customer. It has Cust_Id, Cust_Name, Cust_SSN, Cust_Address. There are some records in table. I would like to insert one more column Cust_DOB after...

Looks OK, though I'm not sure that you need the CHECKPOINT, or if you do need it, that it shouldn't be first instead of second (hopefully Paul or someone else...

Yes, this can be done fairly easily, though efficiency may be an issue.

If you provide the information the bteraberry indicated, we can provide a working example for you.

You cannot enforce this with static RI (referential integrity) without the use of an artificial "helper" table, which is a bit of a mess to setup and maintian and not...

Toby White (4/13/2010)

---

My sincere advice to you is abandon linked server. It poses a security threat and it's only use is to circumvent doing it the right way by doing...

TheSQLGuru (4/13/2010)

---

RBarryYoung (4/13/2010)

---

TheSQLGuru (4/13/2010)

---

Why bother converting the int to date at all? Every human can read and understand 20100411 is April 11 2010. 🙂 And if you need...

NJ-DBA (4/13/2010)

---

...

Executed as user: DOMAIN\USER. TCP Provider: An existing connection was forcibly closed by the remote host. [SQLSTATE 42000] (Error 10054) OLE DB provider "SQLNCLI" for linked server "remoteserver.domainname"...

Yikes!!! (Exit, stage left ... ) :w00t:

No, I believe she is saying that there is a lack-of-privilege problem on the target server.

Rocknrolla

(same rule, except this is Brit's English ... :-D)

Slevin

(using Chris Morris's rule of "Hollywod movie titles have to be English" :laugh:)

Chris Morris-439714 (4/13/2010)

---

It was a Hollywood movie! It has to be English....

TheSQLGuru (4/13/2010)

---

Why bother converting the int to date at all? Every human can read and understand 20100411 is April 11 2010. 🙂 And if you need a 'pretty'...

Oh you and your umlauts! Aren't we supposed to be using English words? 😛

RBarryYoung (4/13/2010)

---

Grant Fritchey (4/13/2010)

---

She's doing fine. We've exchanged email a bit. She's busy working on her masters thesis....