Re: Public role not in server role
- From: Pasquale <Pasquale@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 14 May 2009 14:28:03 -0700
For the SQL engine I have verified the presence of the public role by the
query
SELECT * FROM sys.server_principals.
The number version of the engine is 9.00.1399.06 (SP2), SQL Server 2005
Enterprise Edition 64-bit; the number version of the Management Studio
is 9.00.1399.00.
So, how can I solve this issue? Thanks
"John Bell" wrote:
Go into management studio and look at the version number in Help/About, for.
SP2 look for 9.00.3042 or higher.
John
"Pasquale" <Pasquale@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5A14A817-16E4-4D65-9D43-4E0F35264D93@xxxxxxxxxxxxxxxx
If for the engine is installed the SP2, how can I know which SP is
installed
for the Management Studio? Thanks
"Tibor Karaszi" wrote:
Help, About.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Pasquale" <Pasquale@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B033930A-0B5F-447B-BA27-8898524F9BDA@xxxxxxxxxxxxxxxx
How can I verify which SP is installed for the Management Studio?
Thanks
"Russell Fields" wrote:
Perhaps your customer has an SP2 server, but has never upgraded his
client
tools to SP2.
RLF
"Pasquale" <Pasquale@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4B6D96FD-5FCC-4EDB-ABDD-426AF7E4A43D@xxxxxxxxxxxxxxxx
My customer has SS2005 with SP2; but also I have SQL Server 2005
+ SP2 and
I
can see Public among server roles.
For now, I cannot execute your queries. Thanks
"Uri Dimant" wrote:
Pasquale
Do you use SS2005? I think it was a change to see the role in
SP2, so
what
service pack do you have? I run (SS2005 SP3) and see public role
What does exec sp_helpsrvrole 'public' or select * from
sys.server_principals return?
"Pasquale" <Pasquale@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9E6D9E78-B536-49B9-A685-D3119264FC36@xxxxxxxxxxxxxxxx
A my customer asked to me why him cannot see the Public role in
the
server
role list. Him sent to me a screen shot about this issue: I
can see the
server role properties page of a SQL Server account without
Public in
the
list.
Is it possible? Why? How can I solve this issue?
Thanks
- Follow-Ups:
- Re: Public role not in server role
- From: John Bell
- Re: Public role not in server role
- Prev by Date: SQLServer 2008 Express + SP1
- Next by Date: Re: Truncating Log Files
- Previous by thread: SQLServer 2008 Express + SP1
- Next by thread: Re: Public role not in server role
- Index(es):
Relevant Pages
|
