Saturday, April 27, 2013

To Remove SQL error


select * from sqldictionary where TABLEID in (select TABLEID from sqldictionary where name = 'PurchTable')
and NAME like '%MFI%'



update  sqldictionary set fieldid=60006 where NAME='MFIEDIPROCESSED'
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to identify the user that was used to change an object from AOT in AX2012

Get the object name for which we need to track these (user and date&time) information's. Login to SQL Server Management Studio an...