Login Stored Procedure

Here's something I stumbled across when I was looking for something else in the NAV Developer and IT Pro Documentation (http://msdn.microsoft.com/en-us/library/bb219495.aspx).

It is possible to have a SQL stored procedure run automatically when a user logs in.

To enable this it is necessary to name the proc[sp_$ndo$loginproc] and it must have two parameters - the name of the application and the C/SIDE version number, neither of which need be used (http://msdn.microsoft.com/en-us/library/dd338930.aspx).

"Cool", I thought. "That could be useful for something."

So I setup an example as per the documentation, fired up the classic client and up popped the message.

Then I fired up the RTC, and guess what? No message.

So it only works with the classic client. Not so useful after all.....