Skip to content
logo Knowledgebase

Delete your Sage 200 data from Sage Network

Created on  | Last modified on 

Summary

Your Sage 200 data will automatically be deleted from Sage Network after 6 months when you disconnect, but you can ask us to delete your data immediately inside the 6 month period.

Description

When you disconnect Sage 200 from Sage Network, your data will be automatically deleted from Sage Network after 6 months. The data is not deleted immediately in case you want to reconnect to Sage Network in the meantime.

If you want us to delete your Sage Network data immediately inside the 6-month period, you can ask Sage to delete your data.


To do this, you will need to contact Sage support and give us some information.

Please tell us your Sage account details:

  • Business name.
  • Address.
  • Country (UK or Ireland).
  • Owner email address.
  • Account number.
  • Serial number.


It will help us if you can provide details of your Sage 200 data to be deleted. You can find this information by running a SQL query on your Sage 200 data.

  1. Open SQL Server Management Studio.
  2. Select your Sage 200 configuration database from the Databases list in Object Explorer.
  3. Select New Query.
  4. Enter the SQL query:

    select CompanyID, Email, FirstName, LastName, UserGuid, NetworkTenantGuid, NetworkGuid, NetworkProductLicenceGuid from tblConnectedBridge

  5. Select Execute to run the query.
  6. Copy the query information from the Results.
    Tip: Right-click the information and select Select All, then right-click and select Copy with Headers.
  7. Provide us with the copied information, which should include:
    • CompanyID
    • Email
    • FirstName
    • LastName
    • UserGuid
    • NetworkTenantGuid
    • NetworkGuid
    • NetworkProductLicenceGuid