From a recent email: I am trying to use SmartList Builder to build a query where a calculation is required showing the number of days an A/R transaction is past due. Obviously, I have the DOCDATE from RM20101 but I need a column that tells me the current...

Here a sample of code that will write to the application event log, using VB..NET: Public Function WriteToEventLog( ByVal Entry As String ) Dim appName As String = "Server Maintenance" Dim eventType As EventLogEntryType = EventLogEntryType. Error Dim...

After issuing this command: DROP index drive.ix_drives I get this message: An explicit DROP INDEX is not allowed on index 'drive.ix_drives'. It is being used for UNIQUE KEY constraint enforcement. Then answer was to issue this command: ALTER TABLE...