Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the SQL Collation for the SecureScout SP Database?

April 26, 2017collation database securescout SP sql

0

Posted

What is the SQL Collation for the SecureScout SP Database?

1 Answer

0

Posted

The Database for SecureScout SP supports multiple collations and is based on the default collation of the instance of Microsoft SQL Server(tm). Collation of the SQL Server instance is either specified during the install of the instance or takes a default collation. Default collation depends upon whether the instance was an upgrade from a previous version and if so then SQL Server Setup carries forward the same collation used in the existing instance of SQL Server. If this is a new installation and collation was not chosen during the install then Setup chooses the Windows collation that supports the Windows locale of the computer on which the instance of SQL Server 2000 is being installed. To view the default collation of the SQL Server Instance you can run “Exec SP_HELPSORT” in SQL Query Analyzer.