Change collation for an existing database

Hi !
I would like to know how to change the collation of an imported database. I
tried something with DTS, but I'm quiet a beginner with this tool. So if
anyone could help me on this one, this would be great ! ;-)
Thanks in advance !I just forgot to say that I use SQL 2000 SP4. :)
"Vincent D." wrote:
> Hi !
> I would like to know how to change the collation of an imported database. I
> tried something with DTS, but I'm quiet a beginner with this tool. So if
> anyone could help me on this one, this would be great ! ;-)
> Thanks in advance !|||Seems that similar issue has been handled recently. Pls have a look at the 2
posts of 28/11/05.
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?query=collation&dg=microsoft.public.sqlserver.server&cat=en-us-technet-sqlserv&lang=en&cr=US&pt=261BA873-F3AB-420E-96D6-E3004596A551&catlist=328BAFD2-1A81-4558-B1DE-B6EB49F31B7E&dglist=&ptlist=&exp=&sloc=en-us
"Vincent D." wrote:
> I just forgot to say that I use SQL 2000 SP4. :)
> "Vincent D." wrote:
> > Hi !
> >
> > I would like to know how to change the collation of an imported database. I
> > tried something with DTS, but I'm quiet a beginner with this tool. So if
> > anyone could help me on this one, this would be great ! ;-)
> >
> > Thanks in advance !