Browse By Tags

  • SSRS MS SQL ODBC connection to SFAServ

    I am looking for instructions on how to query data from MS SQL Studio and SSRS. If needed, how to I install required ODBC drivers and where do I acquire them? We own the Sage Fixed Assets - Reporting Product, does this come with ODBC drivers? I do not…
  • Four T-SQL commands for your toolbox

    Four T-SQL commands for your toolbox

    I have used the following T-SQL commands quite often when working on the SQL Server side. There are other ways to find some of this information, but you should have these commands in your toolbox. Using the SQL Server Management Studio(SSMS) interface…

  • How to find the name of the SQL view related to a lookup

    If you are interested in finding the name of the SQL view associated to a given lookup view screen, here are a couple of ways From System Manager , Maintenance , Maintain Lookups and click on the lookup flashlight. In the Lookup column, locate Vendor…
  • Setting Sage 500 database to restricted user mode

    Setting Sage 500 database to restricted user mode

    If you need to have an archived Sage 500 database you probably want to limit the access to that database by general users. In this situation restricted access mode can be employed to limit connections to high-level users only. SQL Server's restricted…

  • HOW TO CONVERT RTF FIELDS INTO PLAIN TEXT USING T-SQL

    Situation : I had to convert a Sage X3 field (TEXCLOB.TEXTE_0) , because it was going to be exported to a .txt field (among other fields contained into the layout), but as this field was an RTF the result my query was showing was this: {\rtf1\ansi…

  • SSRS MS SQL ODBC connection to SFAServ

    SSRS MS SQL ODBC connection to SFAServ I am looking for instructions on how to query data from MS SQL Studio and SSRS. If needed, how to I install requried ODBC drivers and where do I acquire them? We own the Sage Fixed Assets - Reporting Product, does…

  • How to unconventionally register Sage 500 ERP... using a T-SQL script

    This topic will show you a way to register Sage 500 ERP without going into Maintain Site or use the Database Synchronization utility. I will provide you the T-SQLscript we use to register databases directly from SQL Server. This script should always be…

*Community Hub is the new name for Sage City