You will then have to convert the data type at the source (SQL Server)

😎

Luis Cazares (4/6/2015)

---

I'm not sure if this can be done. I'm not sure if it's the lack of coffee in my body or something else, but I'd like to know...

Ed Wagner (4/6/2015)

---

Eirikur Eiriksson (4/6/2015)

---

GoofyGuy (4/6/2015)

---

If you host my data, and your building burns down, including all backups, I don't have any data. Therefore I don't own anything, you do,...

Grab a copy of dbMonitor, connect it to the server and make certain that it is capturing...

pveilleux (4/6/2015)

---

Eirikur Eiriksson (4/6/2015)

---

pveilleux (4/6/2015)

---

It was not running. The 2005 server is a production server and the...

GoofyGuy (4/6/2015)

---

If you host my data, and your building burns down, including all backups, I don't have any data. Therefore I don't own anything, you do, even if you only...

pveilleux (4/6/2015)

---

It was not running. The 2005 server is a production server and the 2012 instances (sql101,...

Get what you are saying, thought that since "EMISATT" is...

pveilleux (4/6/2015)

---

Eirikur Eiriksson (4/6/2015)

---

pveilleux (4/6/2015)

---

I also went ahead and disabled Named Pipes on sql102, tried the queries, enabled Named Pipes, tried queries again. Everything on sql102 is behaving...

Solomon Rutzky (4/6/2015)

---

Thanks Eirikur. Just FYI, the link you posted was wrapped in...

Sagar-636902 (4/6/2015)

---

it was blocking for more then 12 hours.. and which crazy that create triple thread block and re-org blocked 2 other process in chain.. since having large table i...

pveilleux (4/6/2015)

---

I also went ahead and disabled Named Pipes on sql102, tried the queries, enabled Named Pipes, tried queries again. Everything on sql102 is behaving just fine. ...

DonlSimpson (4/6/2015)

---

Grant Fritchey (4/6/2015)

---

I'll go one further. I'd suggesting taking a look at Jeff Moden's article on Tally Tables[/url] and using that to take the comma delimited list and turn...

pveilleux (4/6/2015)

---

I did not disable Named Pipes on sql101 because it is not disabled on sql102. From sql102, I can get to SQL2005INST no problem. In fact, from...

Quick thought, I have workstations with full install of all versions of SQL Server from 2000 to current, all of the installs were done in the order of the versions,...