I forgot all about synonyms, but you're right. Not the best solution. For one, I can't create one that just points to the server.dbname. I just tried it, it doesn't...

I have never run into a situation where having read...

This or try to change the INT16 in expression to INT32. But yes, INT in a database comes across as INT32 in...

At a guess, I would think you need to contact Microsoft.

I don't know if this document tells you anything helpful (I haven't read through the whole thing yet). Microsoft...

What logic determines IN verses OUT?

Hard coding based on the dates given is not wise. Ideally, code should be written to logically decide what fits either circumstance depending on other...

Orlando Colamatteo (2/13/2016)

---

I would say it as "because integrating with Excel sucks that way." It is not technically Excel that...

Alan.B (2/23/2016)

---

I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com), simple-talk, twitter, linkedin... then...

djj (2/18/2016)

---

Hey, who shut down the water cooler? I do not post often here, but I read it every day. Usually there is a lot going on by...

Honestly, if knowing how SQL Server works is NOT part...

So what smtp stuff are you logging? IIS stuff? Or database mail?

Sean Lange (2/12/2016)

---

Brandie Tarvin (2/12/2016)

---

Thank you backup, Sean. I'm still shaking my head over the OPs initial "you're wrong, that can't be done after all" and then "Well, prove it"...

I know this thread is "dead," but ...

Update for those who stumble across this thread like I just did, if you have a 64-bit box, follow the instructions here or...

TheSQLGuru (2/11/2016)

---

Whenever I am building out dynamic SQL I always use SET QUOTED_IDENFITIER OFF first and then use double quotes in the outer sections of text. Then I never have...

Thank you backup, Sean. I'm still shaking my head over the OPs initial "you're wrong, that can't be done after all" and then "Well, prove it" responses.

EDIT: I found it...

webrunner (2/12/2016)

---

I eventually found out what was happening.

I was using @[User::Variable] = 0 instead of the operator to check for equality @[User::Variable] == 0. Once I fixed that the branching...