On a side note... the XML datatype will not allow itself to be passed as a parameter between linked servers.

Seriously.

You have to pass a VARCHAR(MAX) then shove it into a...

Scott D. Jacobson (1/8/2013)

---

hisakimatama's latest post is beyond frightening. This is like saying "I need you to be a DBA but also drive a tractor trailer". There has to be...

Jacob,

What you're doing is basically preparing the beginning of a catch-all query, of which there are two approaches. There's the easy to maintain version, which is what you're doing....

GSquared (1/8/2013)

---

Grant Fritchey (1/8/2013)

---

hisakimatama (1/8/2013)

---

No kidding. I saw the SQL-related bits and figured the salary was acceptable enough, then I caught the rest of it... Ack. Amusingly,...

I think we're finally drilling down to my confusion, Orlando, so thanks for the help. There's assumptions I was making about the connection object that are obviously inaccurate. ...

Star Wars: A universe where space is an atmosphere and your cells are psychic.

Star Trek: A universe where fuses are considered overkill and bathrooms are optional.

Babylon 5: Where every sentient...

opc.three (1/5/2013)

---

Not sure I am completely getting the concern, but I thought I would trace a stored proc call from .NET and show what SQL the SqlClient actually generates on...

SSIS menu, Package Configurations... something in...

opc.three (1/4/2013)

---

The way I am viewing it is that SSIS will try to use a file regardless of whether it can gain exclusive access to it or not. That is...

opc.three (1/4/2013)

---

Evil Kraig F (1/3/2013)

---

Agreed. I was not saying the code you showed doesn't have a place, only that it is more prone to having a problem than code that...

Anyone up to speed on their table value parameters in 2k8? I could use some clarity on the subject if you'd be willing to help. Here's the thread:...

Thanks for the recommendations. 🙂

opc.three (1/3/2013)

---

Be careful implementing code like this. You are not checking for exclusive access to the file before allowing the SSIS package to proceed in processing it. If someone were...

Any twitter folks here use a samsung galaxy? If so, what app do you recommend?

mpradeep23 (1/2/2013)

---

i have two database

one is main

other is dev

in the main i have a two tables called users and userinformation

i need only few columns from users and userinforamtion...