Re: SQL Server 2005 Generate Scripts does not script role members any
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 10 Apr 2006 22:33:39 +0000 (UTC)
Titus (Titus@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
With SQL Server 2000 Enterprise Manager, it was possible to generate
scripts, which included the statements to create members of server roles
(sp_addsrvrolemember) and to create members of database roles
(sp_addrolemember). This was very useful for replacing a server or
rebuildung the master database.
In SQL Server 2005 SSMS, I cannot any more script the role members (or do
not find the right menu item). Any help is appriciated.
I think the best you can do is to go to
http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=94cfd0a6-9956-4ede-aca4-6f9e4990b0e6
and vote for this issue, and hope that MS addresses this for SP2. (Since
it's a new feature visavi SQL 2005, I would hold too high hopes on that.)
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: ?? Turning Off TCP/IP Client Has No Effect ??
- Next by Date: Re: SQL Server Profiler
- Previous by thread: Re: "Some trace events have not been reported to SQL Profiler" - Erro
- Next by thread: Re: SQL Server 2005 Generate Scripts does not script role members
- Index(es):
Relevant Pages
|
