Article Rating

  • 0 Rating(s)
  • 0
  • 0
  • 0
  • 0
  • 0

ERROR: Invalid object name 'SysObjects'

If you get this error during installation: Invalid object name 'SysObjects'
Then it is likely that your database collation is set to use case sensitivity.

You can check your current database collation setting by running the following SQL:

SELECT CONVERT(sysname,DatabasePropertyEx('ss', 'Collation'))   -- replace "ss" with your database name

You can change your collation on your database using this SQL:

ALTER DATABASE ss COLLATE SQL_Latin1_General_CP1_CI_AS -- replace "ss" with your database name

You can list all available collations using this SQL in SQL Server 2005:

SELECT * FROM ::fn_helpcollations()

For more information on SQL Server Collation Settings, please see:
http://msdn2.microsoft.com/en-us/library/ms184391.aspx


Article ID: 23, Created On: 2/7/2008, Modified: 2/7/2008