Cara mengatasi the trace flag 4616 is not set on the server

Cara mengatasi  the trace flag 4616 is not set on the server

-add  -T 4616 (in start up parameter sql server )



Referensi :
-https://blogs.msdn.microsoft.com/nav_developer/2008/11/05/basic-sql-enable-trace-flag-4616-on-sql-server/

-


cara mengatasi the extended stored procedure xp_ndo_enumusersids in the library file xp_ndo.dll



kopi file xp_ndo.dll
download xp_ndo.dll Click here


USE master
EXEC sp_addextendedproc xp_ndo_enumusersids, 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\xp_ndo.dll'
GO

GRANT EXECUTE
ON [xp_ndo_enumusersids]
TO PUBLIC
GO

USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups, 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\xp_ndo.dll'
GO

GRANT EXECUTE
ON [xp_ndo_enumusergroups]
TO PUBLIC
GO



Referensi :  https://blogs.msdn.microsoft.com/nav/2009/05/25/installing-stored-procedures-for-dynamics-nav-2009-manually/