February 4, 2013 at 4:16 am
Hi,
I am trying to change the collation of the databases ReportServer and ReportServerTempDB from Latin1_General_CI_AS_KS_WS to Latin1_General_CI_AS (which is the collation used by the server and all other databases).
When I run the following code:
USE [master]
GO
ALTER DATABASE [ReportServer] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE ReportServer
COLLATE Latin1_General_CI_AS ;
GO
ALTER DATABASE [ReportServer] SET MULTI_USER WITH ROLLBACK IMMEDIATE
GO
I then get the following results:
Msg 5075, Level 16, State 1, Line 1
The object 'Positive_StartByte' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.
Msg 5075, Level 16, State 1, Line 1
The object 'Positive_LogicalByteCount' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.
Msg 5075, Level 16, State 1, Line 1
The object 'Positive_ActualByteCount' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.
Msg 5072, Level 16, State 1, Line 1
ALTER DATABASE failed. The default collation of database 'ReportServer' cannot be set to Latin1_General_CI_AS.
I understand that normally the way to go to change a DB collation is to script the DB out, BCP data out, drop, rebuild, BCP in, have beer, but I would prefer to avoid doing it that way ...
So, I'm thinking that I could simply have a look at the objects listed above and drop/recreate them with appropriate collation, the issue is that I can't find those objects!
Does anybody know what these objects refer to? where I can find and script them in/out?
B
February 4, 2013 at 4:23 am
Don't change it, SSRS creates the DB's in that collation so leave it in that collation, otherwise you risk breaking the SSRS application.
February 4, 2013 at 4:29 am
Ok then - ticket closed 😛
Thanks for the reply, much appreciated,
B
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply