Category: SQL Server and TSQL

Publish-AXReport : The user or group name is not recognized. Dynamics ax 2012

Publish-AXReport : The user or group name is not recognized. Dynamics ax 2012

Today I faced this issue, after restoring database of other server, on report deployment on new ssrs I found this error and deployment aborted Solution is to delete all rows form SysServerSessions.

Avoid Over layering in Development of Workflows on Existing Form Extension version – Dynamics 365 for finance and operations

Hi all,  My fellow Sohail Shaikh wrote an excellent blog Post, I used it in my customization to avoid overlay methods in some of out of the box table. http://d365technext.blogspot.com/2018/07/avoid-over-layering-in-development-of.html     That article...

float value conversion in string SSRS expression and decimal points SSRS dynamics ax 2012 R3.

float value conversion in string SSRS expression and decimal points SSRS dynamics ax 2012 R3.

    Today I have to record very small tip. During development of on SSRS report for Dynamics Ax 2012 R3, End user wants a row at the report footer for  analysis. he wants...

Study resource for SQL Server 2008 R2 Integration services (SSIS)

Study resource for SQL Server 2008 R2 Integration services (SSIS)

  SQL Server 2008 R2 Integration services (SSIS) Creating a simple ETL Package http://msdn.microsoft.com/en-us/library/ms169917.aspx Typical Uses of SSIS Packages http://msdn.microsoft.com/en-us/library/ms137795.aspx Package Protection Level Setting: http://msdn.microsoft.com/en-us/library/ms141747.aspx Running Packages: http://msdn.microsoft.com/en-us/library/ms141708.aspx Logging Package Execution: http://msdn.microsoft.com/en-us/library/ms139845.aspx Architecture of...

describe table tsql

describe table tsql

Currently I was searching describe  like function, which used in Oracle PLSQL to get the detail of table.  I found equvilent function in TSQL “sp_help”. you can used it as sp_help <table_name>   i.e...