Home > Archive > MS SQL Server > March 2006 > Re: SQL Server 2005: Collation Conflict Error when selecting Database Properties









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: SQL Server 2005: Collation Conflict Error when selecting Database Properties
Greg D. Moore \(Strider\)

2006-03-27, 8:23 pm


"Peter Nurse" <PtrNrs@yahoo.com.au> wrote in message
news:1143488444.248281.213610@v46g2000cwv.googlegroups.com...
>


Out of curiousity, did you sp_detach_db/sp_attach_db the ASPProBU/Web DBs
from 2000->2005?
[color=darkred]
>
> name collation_name
> compatibility_level
> --------------------------------------------------------------------------

--------------------------------
> master Latin1_General_CI_AS

> 80
> tempdb Latin1_General_CI_AS

> 90
> model Latin1_General_CI_AS

> 90
> msdb
> SQL_Latin1_General_C
P1_CI_AS 90
> pubs Latin1_General_CI_AS

> 80
> Northwind Latin1_General_CI_AS

> 90
> ASPProBU SQL_Latin1_General_C
P1_CI_AS
> 80
> ASPProWeb SQL_Latin1_General_C
P1_CI_AS
> 80
> ASPPro Latin1_General_CI_AS

> 80
>
> (9 row(s) affected)
>
>
> --------------------------------------------------------------------------

--------------------------------
> Latin1_General_CI_AS

>
> (1 row(s) affected)
>
>
>
>
> Doesn't seem to fix anything.
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com