You have an implicit or explicit conversion taking place. Somewhere your code is trying to cast data to float, and there are values in the varchar field that cannot be...

Likely you don't have permission. The best way is just to ask someone. They might not give you permissions, but I'd hope they would send you the definition.

I've edited the question, to note data and directly returning, which should eliminate temp tables, etc. I think Print/Raiserror aren't really about returning data, but they do return info, so...

I tend to avoid dynamic SQL, and I'd usually just deploy the same report to all servers and call it without having to do any linked server or anything else....

Yep, everyone knows rule #1 of The Culture. 🙂

Steve, remember the importance of Me time. Sometimes tech types are a little OCD and focus too hard on the new...

Tends to vary over time. I like some sci-fi, spy thrillers,...

A minor issue with formatting. Backslashes should have been in the question and answers.

Apologies everyone. I got distracted with life and let this go. I got Ray's FB message, but nothing here. Can everyone send an email to sjones at this domain.

I don't think things overwrite, but if you give a URL to the post, we can remove the attachment.

I'll have the webmaster reach out. You shouldn't continue to get this.

What I heard back is that any sort of bounce, not OoO, will move you to unconfirmed for emails. We use a service, and they are a little conservative with...

Hey Steve.

This is my very first post and so good that you are back. Didn't realise how much I enjoy your daily editorial and the topics you choose to...

My wife wants us to go back. Still a couple days...

A trigger will work, but it is more overhead and not better than an index, as Mike noted. Is there some action you want to occur here other than raising...

I would lean towards XE myself, though I'm not sure why your company would not allow that.

I believe SQL Audit will capture this, but I'd have to dig in. There...