caspersql (11/18/2016)

---

Thanks for the reply Thom. How do you think people generally work with these servers then? If they can't connect through SSMS due to not having the...

planetmatt (11/18/2016)

---

Phil Parkin (11/18/2016)

---

I suspect that the ? is not a ? in the data ... it's some other non-printable character.

This code snippet shows that ?+ is no problem:

IF OBJECT_ID('tempdb..#test',...

I suspect that the ? is not a ? in the data ... it's some other non-printable character.

This code snippet shows that ?+ is no problem:

IF OBJECT_ID('tempdb..#test', 'U') IS NOT...

--Edit: removed silly question

planetmatt (11/18/2016)

---

I have a simple package that takes data from a SPROC and puts it in a .CSV file.

Until today, it ran without issue.

The error it's now throwing is

"The data...

tocy1980 (11/18/2016)

---

I have tried this:

and it doesn't work.

Get this error: he multi-part identifier "Linked Servers.DATA STORE LINKED.'ET NEW$'.Parts Used" could not...

tocy1980 (11/18/2016)

---

I mean update (fill with some values) one table column from another table column.

the trick is here I don't know how to connect Linked Server e.g.

update Server_FINAL

set Server_FINAL.Parts =...

I've read your post a couple of times, but don't understand the problem. What do you mean by 'column data'?

Please make a note to put it back again tomorrow evening :smooooth:

Jerid421 (11/17/2016)

---

Hi All,

This is more a question of theory than a technical one, but here it goes. I need to mirror (23) SQL tables in one database over to...

Eirikur Eiriksson (11/17/2016)

---

The execution plan for my version is significantly...

Before you call sp_ExecuteSQL, you need to populate @ParmDefinition with, somewhat unsurprisingly, given its name, the definitions of all the parameters.

You do not appear to have populated @ParmDefinition.

This appears to be a blog post. Please add some descriptive text, if you think that this will assist others.

I compared execution plans ... my version seems significantly less expensive, at least on this tiny amount of data.