Author Archives: Bhagavan Reddy K

AxBuild.exe compilation error

Yesterday when i try to compile my AX 2012 R3 with AxBuild.Exe, i was getting the following error “Object Server 01:  Can not create default Keyset. Error code -2146893809”. Here i was running the command prompt as an Adminitrator and … Continue reading

Posted in Microsoft Dynamics AX | Tagged , , , | Leave a comment

AX2012 R3 demo data transfer tool not detecting the database

Hello Friends, Today i have tried to import the demo data into my AX 2012 R3 instance. But the test data transfer tool is not detecting my database. It is always showing that no databases found, even though the database … Continue reading

Posted in Microsoft Dynamics AX | Leave a comment

Getting Vendor addresses based on Address type in AX 2012 R2/R3

The following query gets the vendor addresses  select ROW_NUMBER() over (partition by v.accountNum order by dpl.isprimary desc, lpa.recid) as AddressNumber,v.ACCOUNTNUM,lpa.ADDRESS,llr.NAME from VENDTABLE V  join DIRPARTYLOCATION Dpl on v.party=dpl.party  and dpl.ISPOSTALADDRESS=1  join LOGISTICSPOSTALADDRESS lpa on dpl.LOCATION=lpa.LOCATION    join DIRPARTYLOCATIONROLE dplr on … Continue reading

Posted in Microsoft Dynamics AX | Leave a comment

Resize the VHDX file

The following process changes the VHD file size using the power shell (run as administrator). mount-vhd –passthru | get-disk | get-partition | get-volume This will mount the virtual hard disk in the management operating system, and let you know the … Continue reading

Posted in Windows | Leave a comment

How to remove windows default apps in Windows 8, 8.1 and 10

Step 1 Open power shell as an Administrator Step 2 Type the command Get-AppxPackage. It  will show the list of windows apps. Step 3Now choose the application which you want to remove. Select the Package full name and type the … Continue reading

Posted in Windows | Leave a comment

SQL server Multiple rows to one comma separated value

This is the select statement in Sql server which will select the multiple rows of a column into a single column and single row as a comma separated values. SELECT  ID ,STUFF((SELECT ‘, ‘ + CAST(Name AS VARCHAR(10)) [text()] FROM … Continue reading

Posted in SQL Server | Leave a comment

Sql Sever Split String function with special character support

The following the is the SQL server table valued function which will return the result as table. The input to the function is string delimited with the comma (for that matter any character which is is not part of the … Continue reading

Posted in SQL Server | Leave a comment