Thanks for the reference.

Oh, it's not my company, I've been brought in to consult on some other problems, and the use of the Version Store cropped up as part...

I would almost bet that someone "derived"...

well.... kind of no headers as such.. but for many such files you do have a "header" record with a particular fixed format, then "data" records with their own format(s),...

the old RTFM does come into place here - just looks like most don't like doing it nowadays.

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms345368(v=sql.105)?redirectedfrom=MSDN

and Always-On also uses version store.

On a different note - your company must...

• This reply was modified 5 years, 4 months ago by frederico_fonseca.
• This reply was modified 5 years, 4 months ago by frederico_fonseca.

this is a good read on this subject

https://docs.microsoft.com/en-us/sql/tools/configuration-manager/sql-server-browser-service?view=sql-server-ver15

and (although almost the same)  https://www.mssqltips.com/sqlservertip/1946/overview-of-the-sql-server-browser-service/

Depending on your exact setup you may disable it - I know we do for many of our...

yes it is the same thing...

that configuration manager reference there is to be executed on the SERVER where SQL Server is installed, not where you installed the client tools.

So unless you also intend in having...

or keeping the CTE change "and b.userID is null;" to "WHERE b.userID is null;"

I may be wrong - but installing POsh 5.1 should contain the automation namespace - and this will not be .net core

https://www.microsoft.com/en-us/download/details.aspx?id=54616

I think I have that working in one of my packages but through a start process e.g. new process kicked off which starts a new powershell instance.

if that works for...

order does not matter - and the way it works "logically" is that for each row on the out query (customer) check if a row exists on the inner query...

Have a look at Power BI Report Server - that is the one you need and it is a superset of normal RS server.

Assuming you have SQL Enterprise with...

first.... why in HELL will you have a production database dependent on details stored on a dev database?

second - what SQL Server license do you have on your Development database?...

have a look at https://dba.stackexchange.com/questions/246773/prevent-ssms-from-seeing-the-servers-file-system

but use at your own risk.

why do you need to hide this?

and check if on your 2012 server any permission was removed - either directly or...

what is the final purpose of this SQL - how is it going to be used and where is the final output? e.g. csv file, excel, web page?