Visit Sage CRM Main Website
About Sage CRM
Browse By Tags
Sage ERP MAS 90
Who's been looking at my data? Recording access to Company and Person screens
I have discussed creating logs and audit trails of changes to data in previous articles. See Using a Table Level Script to Track Changes to Data Made by Users. Validation rules don't always mean "Stop!" But many customers have the much more straight forward business need...
13 Jul 2010
MSSQL Index analysis and creation from Sage CRM (Part 1 of 2)
This article has come from a very experienced colleague in Australia. Introduction Microsoft SQL Server 2005 added new system tables to assist in the system reporting. Three of these tables in particular are written to every time a query is run. Microsoft SQL Server 2005 processes each query, determines...
5 Mar 2009
Connecting to a Sage MAS ERP 90 Database as a Linked Server within MS SQL Server 2008
A Linked Server within MS SQL Server is type of 'alias' within the SQL server that points to an external data source rather than a SQL Server database. This external data source can be in another RDBMS like Oracle or almost any other data system that can be accessed by OLE or ODBC--including...
10 May 2010
© The Sage Group plc 2019
All Rights Reserved