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, 3 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...

as per the article if all indexes are on the same PS it will work.

But you need to consider is that some indexes that are non partitioned may have been...

in order to do the switch you need to drop the non partitioned indexes and recreate them afterwards

see https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql?view=sql-server-2017 and go to the switch partition description

does look like the same question with changed details that you posted before https://www.sqlservercentral.com/forums/topic/sql-server-2012-data-column-used-for-7-different-languages

have a look at https://www.sqlservercentral.com/articles/mail-fails-with-sqlcmd-error

IT removing Outlook from the server was the correct thing to do - Outlook is not a server component, is not supported from Microsoft while running on a server as...