not sure what is going on in your case specifically;
i just wrote the attached stuff to explicitly check what my settings are in SSMS vs a TSQL  job, vs...

you did not show your entire query, so it's hard to diagnose.
review your code, because each and every EXECUTE(@SomeCommand) could be the potential problem. how many executes do you...

you are declaring a command and executing it. the internal command does not have the same settings for quoted identifier

Declare @command varchar (max)
SELECT...

a wordier version just like what Luis did;
i thought this way shows the advantage of actually storing the data correctly.
I added the three name examples from our other...

you can use this trick to join your table with a total against a Tally or Numbers table to generate each label you need.

it makes it a lot...

backup and restore replaces the entire database(meaning all existing data) with the new backup; since you are saying replace a range of data, from what you are describing, that's not...

yeah power point is only 20-30% of the show, like i mentioned. except for a pptx of sponsors logos, nothing executes in any specific order. Power point is very top...

hey guys my non profit's event is coming up again, and i'm still looking to replace something i cobbled together that is more professional.
i really need a organized deck...

Those three are not quite the same; they really are different technologies with different requirements.
TDE(Transparent Data Encryption) protects your data at rest: that means a backup, or a san...

I'm with Luis, one of the most recurring performance and bad data issues i see is not maintaining data types when comparing data to parameters.
datetimes are datetimes, varchars are...

For those of you subscribed to this thread, I've made some fixes today for a couple of things i found.
These changes are  noted in section V3.17.
When scripting foreign...

your data type sized obviously don't match...since it's a linked server, you can properly interrogate their sizes.

if both sides are SQL server, a simple EXCEPT operator should work:

i think the issue is you did not declare an outer variable to capture the results as an output , nor did you actually use the variable declared in the...

i think you want to use a different function right?

this page from Microsoft has a decent example:
https://docs.microsoft.com/en-us/sql/relational-databases/system-functions/getfilenamespacepath-transact-sql

what does this return for you?
SELECT...