How to change collation name?

How to change collation name of msdb and model database? If it can't how to
export all users in Security\login.>
> How to change collation name of msdb and model database? If it can't how
to
> export all users in Security\login.
--
Rebuilding the master database will change the collation of the msdb and
model databases. To export logins, you need to script the logins from your
source server and then run the script from your target server.
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.|||Could you please to give example scripts?
"Eric Cárdenas [MSFT]" wrote:
> >
> > How to change collation name of msdb and model database? If it can't how
> to
> > export all users in Security\login.
> --
> Rebuilding the master database will change the collation of the msdb and
> model databases. To export logins, you need to script the logins from your
> source server and then run the script from your target server.
> Hope this helps,
> --
> Eric Cárdenas
> Senior support professional
> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://support.microsoft.com/kb/246133
--
Bart Duncan
Microsoft SQL Server Support
Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: How to change collation name?
| thread-index: AcTXk+3iPuL+BKKcRdOyxeOn6i5IHA==| X-WBNR-Posting-Host: 203.151.8.41
| From: "=?Utf-8?B?TWVzYWs=?=" <Mesak@.discussions.microsoft.com>
| References: <3EAEF5CB-E55F-4720-BB81-A4F996613170@.microsoft.com>
<tU#dca31EHA.3820@.cpmsftngxa10.phx.gbl>
| Subject: RE: How to change collation name?
| Date: Wed, 1 Dec 2004 02:53:02 -0800
| Lines: 22
| Message-ID: <DE104C07-1804-49BA-A5CE-AFD8424D24CE@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA0
3.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:369391
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Could you please to give example scripts?
|
| "Eric Cárdenas [MSFT]" wrote:
|
| > >
| > > How to change collation name of msdb and model database? If it can't
how
| > to
| > > export all users in Security\login.
| > --
| > Rebuilding the master database will change the collation of the msdb
and
| > model databases. To export logins, you need to script the logins from
your
| > source server and then run the script from your target server.
| >
| > Hope this helps,
| >
| > --
| > Eric Cárdenas
| > Senior support professional
| >
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
|