without the full sql you are doing on your package, and indeed the package itself I would guess you have a SQL Statement agains Oracle where you are concatenating various...

your issue is that you don't have a domain - as such you need to do a few extra steps to enable Windows authentication

https://dba.stackexchange.com/questions/39614/connect-to-sql-server-using-windows-authentication-from-another-pc-without-activ

main thing as per the post is...

https://visualstudio.microsoft.com/vs/compare/ - to compare the VS editions

for list of included software https://docs.microsoft.com/en-us/visualstudio/subscriptions/subscriber-downloads and more specifically the spreadsheet on the link above http://download.microsoft.com/download/1/5/4/15454442-CF17-47B9-A65D-DF84EF88511B/Visual_Studio_by_Subscription_Level.xlsx

As you are a freelancer you will most likely...

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

and how many files you got on tempdb?

and can you go to CU7 just in case it fixes the issue?

on the link that Sue gave there is a set of instructions to debug it.

Also a set of details of steps that need to be done to ensure that the...

where you may find some issues is on queries that do cross database queries or those that create temp tables.

Mainly the temp tables will have collation conflicts unless the queries...

I would say that won't work as the SP is already creating a temp table using a insert into

that can give

Msg 8164, Level 16, State 1, Procedure xxx, Line...

can you tell us which error messages you get...

As it is Dynamics AX some of the foreign keys would be created and maintained by the users through the application - in many cases this is not done for...

At OP's request I'm posting here some code of how this can be done using Exchange Web Services.

the powershell code attached is being used currently on my shop (with a...

foreachdb would be the easier - but the following will also give you what you need - although with big number of db's there may be a memory hit

Not much...

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

I may be wrong - can't test it without DDL to create the tables, but if you change the following it may work.

(select sum(case
   ...

IF you have SQL Enterprise AND software assurance you can leave the components at 2016 level and install an instance of 2017 PBIRS on the same licensed server and that...

you have been asking around this already see https://www.sqlservercentral.com/forums/topic/sql-server-2012-data-column-used-for-7-different-languages - you either do not know exactly what you need or you do not understand the answers given.

SQL Server does not...

and I'm not even sure the code is doing what they expect

just a small example.

the following inline query is summing the value of the outside table and has a group...