MS Dynamics AX | Dynamics 365 | Azure | Office 365 | Power BI | Power Platform

select i . [name] as index_name ,     substring ( column_names , 1 , len ( column_names )- 1 ) as [columns] ,     case when i . [type] = 1 then 'Clustered index'         when i . [type] = 2 then 'Nonclustered unique index'         when i . [type] = 3 then 'XML index'         when i . [type] = 4 then 'Spatial index'         when i . [type] = 5 then 'Clustered columnstore index'         when i . [type] = 6 then 'Nonclustered columnstore index'         when i . [type] = 7 then 'Nonclustered hash index'         end as index_type ,     case when i . is_unique = 1 then 'Unique'         else 'Not unique' end as ...

update the partition for admin user to be run when you get the below error after db sync Failed to create a session, confirm that the user has proper privileges to log on to Microsoft Dynamics DECLARE @NetworkDomain nvarchar(255); DECLARE @NetworkAlias nvarchar(80); DECLARE @SID nvarchar(124); DECLARE @InitialPartition BIGINT; SELECT @InitialPartition=Recid FROM PARTITIONS WHERE PARTITIONKEY=N'Initial' SELECT @NetworkAlias=NETWORKALIAS,@NetworkDomain=NETWORKDOMAIN,@SID=SID FROM USERINFO WHERE PARTITION=@InitialPartition AND ID = N'Admin' UPDATE USERINFO SET NETWORKDOMAIN=@NetworkDomain,NETWORKALIAS=@NetworkAlias,SID=@SID WHERE PARTITION != @InitialPartition AND ID = N'Admin' --check number of partitions SELECT * FROM dbo.PARTITIONS

SELECT [rs].[destination_database_name], [rs].[restore_date], [bs].[backup_start_date], [bs].[backup_finish_date], [bs].[database_name] as [source_database_name], [bmf].[physical_device_name] as [backup_file_used_for_restore] FROM msdb..restorehistory rs INNER JOIN msdb..backupset bs ON [rs].[backup_set_id] = [bs].[backup_set_id] INNER JOIN msdb..backupmediafamily bmf ON [bs].[media_set_id] = [bmf].[media_set_id] ORDER BY [rs].[restore_date] DESC