change collation

Hello.
I need to change the COLLATE sequence on TEMPDB database, change it from de
Latin1_General to Modern_Spanish.
I don´t have here the SQLServer CD to make a Rebuildm because I´m on a trip
and the database I have is in Modern_Spanish and the server is
Latin1_General.
What can I do ?
I tried to make an ALTER DATABASE to the database in Modern_Spanish to
change it toLatin1_General but I couldn´t because there are too many
constraints with this collation.
Thanks in advance for any help.
I need to solve it in some way because I´ve a presentation tomorrow.
--
Ricardo Lopez Celani
Unisolutions SA
rlopezNO@.SPAMunisolutions.com.arTempdb is rebuilt at reboot so you could try changing the collation of the model database.
A word of caution - tempdb will then be a different collation from the other system databases and this could cause problems if they have SPs which create temp tables and expect them to be the same collation.
>--Original Message--
>Hello.
>I need to change the COLLATE sequence on TEMPDB database, change it from de
>Latin1_General to Modern_Spanish.
>I don=B4t have here the SQLServer CD to make a Rebuildm because I=B4m on a trip
>and the database I have is in Modern_Spanish and the server is
>Latin1_General.
>What can I do ?
>I tried to make an ALTER DATABASE to the database in Modern_Spanish to
>change it toLatin1_General but I couldn=B4t because there are too many
>constraints with this collation.
>Thanks in advance for any help.
>I need to solve it in some way because I=B4ve a presentation tomorrow.
>--
>Ricardo Lopez Celani
>Unisolutions SA
>rlopezNO@.SPAMunisolutions.com.ar
>
>.
>|||[posted and mailed]
Ricardo Lopez Celani (rlopez@.unisolutions.com.ar) writes:
> I need to change the COLLATE sequence on TEMPDB database, change it from
> de Latin1_General to Modern_Spanish. I don´t have here the SQLServer CD
> to make a Rebuildm because I´m on a trip and the database I have is in
> Modern_Spanish and the server is Latin1_General. What can I do ? I tried
> to make an ALTER DATABASE to the database in Modern_Spanish to change it
> toLatin1_General but I couldn´t because there are too many constraints
> with this collation. Thanks in advance for any help. I need to solve it
> in some way because I´ve a presentation tomorrow.
This question is answered in .tools. Please do not post the same question
to several groups in individual postings. If you feel compelled to
target several groups, please cross-post.
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp