Finding User Sessions from SPID in Dynamics AX 2012

  • October 20, 2017
  • 0 Comments

While check issues it could be usefull to make the link between the Ax user and the related SQL session. In the post below it is explained properly how you should do this. https://community.dynamics.com/ax/b/axfaqblog/archive/2016/08/27/disable-and-enable-users-in-ax-using-t-sql-scripts

Check SQL running processes

  • October 6, 2017
  • 0 Comments

If you want to check the processes running on your SQL server you can find all the info you need in sys.dm_exec_requests. SELECT command, s.text, start_time, percent_complete, CAST(((DATEDIFF(s,start_time,GetDate()))/3600) as varchar) + ‘ hour(s), ‘ + CAST((DATEDIFF(s,start_time,GetDate())%3600)/60 as varchar) + ‘min, ‘ + CAST((DATEDIFF(s,start_time,GetDate())%60) as varchar) + ‘ sec’ as running_time, CAST((estimated_completion_time/3600000) as varchar) + ‘ … Continue Reading

Check SQL last back-date

  • September 29, 2017
  • 0 Comments

If you want to check in SQL when your databases was last back-upped (+ the type of back-up), you can execute the script below. this will list you everything of the last 7 days. SELECT CONVERT(CHAR(100), SERVERPROPERTY(’Servername’)) AS Server, msdb.dbo.backupset.database_name, msdb.dbo.backupset.backup_start_date, msdb.dbo.backupset.backup_finish_date, msdb.dbo.backupset.expiration_date, CASE msdb..backupset.type WHEN ‘D’ THEN ‘Database’ WHEN ‘I’ THEN ‘Differential database’ WHEN … Continue Reading

Check SQL last restore-date

  • September 29, 2017
  • 0 Comments

If you want to check in SQL when your databases was last restored, you can execute the script below. 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 … Continue Reading

Ax2012 An SQL Server 2012

  • March 15, 2012
  • 0 Comments

Microsoft SQL Server 2012 RTM is released and hotfix 2680186 is availible for compatibiliteit with Microsoft Dynamics Ax2012. https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;2680186

Install Ax2012 on SQL Server 2012 RC0

  • February 13, 2012
  • 2 Comments

During the preparations for Microsoft TechDays 2012 my colleague and I installed a fresh Windows Server 2008 R2 with SQL Server 2012 and Ax 2012. At first all seems to work (the AOS started and we could login with the client), but when we started to prepare and opened the ‘Datasource Name’ lookup on the ‘Document Datasources’ we got … Continue Reading

Monitoring Table Size Growth in SQL Server

  • March 31, 2011
  • 0 Comments

During my vacation I came across a older, but interesting article that shows you how you can monitor table size growth in SQL-server. With a bit of creativity you can create interesting report based on this information or you can just use the examples on the second page.

Index vs Index hint

  • October 1, 2010
  • 4 Comments

This is a discussion I had with several colleagues. What is the difference between index and index hint and what do we use in our code?

Using ‘Not Like’ in Ax X++

  • October 13, 2009
  • 0 Comments

When you want to use wild-cards in Ax, you can write a SQL statement with a LIKE keyword 1 2 select firstonly purchTable where purchTable.purchId like ’09*’;select firstonly purchTable where purchTable.purchId like ’09*’; When you want to have all the other records (not like), in X++ SQL-statements you have 3 possibilities: 1.!LIKE : 1 2 … Continue Reading