Hi
Is there any diff. between Named Pipe& TCP-IP protocol from performance
point of view there by I can force all the users connecting to server with
TCP-IP proctocol only .
Regards
Ajay RengunthwarFrom BOL:
Named Pipes vs. TCP/IP Sockets
In a fast local area network (LAN) environment, Transmission Control
Protocol/Internet Protocol (TCP/IP) Sockets and Named Pipes clients are
comparable in terms of performance. However, the performance difference
between the TCP/IP Sockets and Named Pipes clients becomes apparent with
slower networks, such as across wide area networks (WANs) or dial-up
networks. This is because of the different ways the interprocess
communication (IPC) mechanisms communicate between peers.
For named pipes, network communications are typically more interactive. A
peer does not send data until another peer asks for it using a read command.
A network read typically involves a series of peek named pipes messages
before it begins to read the data. These can be very costly in a slow
network and cause excessive network traffic, which in turn affects other
network clients.
It is also important to clarify if you are talking about local pipes or
network pipes. If the server application is running locally on the computer
running an instance of Microsoft® SQL ServerT 2000, the local Named Pipes
protocol is an option. Local named pipes runs in kernel mode and is
extremely fast.
For TCP/IP Sockets, data transmissions are more streamlined and have less
overhead. Data transmissions can also take advantage of TCP/IP Sockets
performance enhancement mechanisms such as windowing, delayed
acknowledgements, and so on, which can be very beneficial in a slow network.
Depending on the type of applications, such performance differences can be
significant.
TCP/IP Sockets also support a backlog queue, which can provide a limited
smoothing effect compared to named pipes that may lead to pipe busy errors
when you are attempting to connect to SQL Server.
In general, sockets are preferred in a slow LAN, WAN, or dial-up network,
whereas named pipes can be a better choice when network speed is not the
issue, as it offers more functionality, ease of use, and configuration
options.
"AJAY R" <dba_pune@.hotmail.com> wrote in message
news:er$fIigRDHA.3132@.tk2msftngp13.phx.gbl...
> Hi
> Is there any diff. between Named Pipe& TCP-IP protocol from performance
> point of view there by I can force all the users connecting to server with
> TCP-IP proctocol only .
> Regards
> Ajay Rengunthwar
>
>
Showing posts with label view. Show all posts
Showing posts with label view. Show all posts
Thursday, March 22, 2012
Wednesday, March 21, 2012
diferent way to a query
is theres a way to return the same result of this query without making the inner joins?
select eventid, sum(px) as sum_px
from isolatedLeptons
group by eventid
) l
on e.idevent=l.eventid
inner join (
select eventid, sum(py) as sum_py
from isolatedLeptons
group by eventid
) l2
on e.idevent=l2.eventid
select eventid, sum(px) as sum_px, sum(py) as sum_py
from isolatedLeptons
group by eventid
) l
on e.idevent=l.eventid
Code Snippet
create view missEeCuts
as
select distinct e.*
from events e
inner join (
select eventid, sum(px) as sum_px
from isolatedLeptons
group by eventid
) l
on e.idevent=l.eventid
inner join (
select eventid, sum(py) as sum_py
from isolatedLeptons
group by eventid
) l2
on e.idevent=l2.eventid
where
dbo.module(e.PxMiss,e.PyMiss)>=40 AND
dbo.effectiveMass(e.PxMiss,e.PyMiss,l.sum_px,l2.sum_py)<= 150.0
GO
Maybe this, Luis:
Code Snippet
selectdistinct e.*
from events e
where
dbo.module(e.PxMiss,e.PyMiss)>=40 AND
dbo.effectiveMass(e.PxMiss,e.PyMiss,l.sum_px,l2.sum_py)<= 150.0
ANDEXISTS(
select eventid,sum(px)as sum_px
from isolatedLeptons l
where e.idevent=l.eventid
groupby eventid
)
ANDEXISTS(
select eventid,sum(py)as sum_py
from isolatedLeptons l2
where e.idevent=l2.eventid
groupby eventid
)
Why do you not want the joins?
|||Luis:
Why do you take "sum_px" and "sum_py" from different joins in:
Code Snippet
inner join (select eventid, sum(px) as sum_px
from isolatedLeptons
group by eventid
) l
on e.idevent=l.eventid
inner join (
select eventid, sum(py) as sum_py
from isolatedLeptons
group by eventid
) l2
on e.idevent=l2.eventid
Can these two sums potentially be computed in a single join such as:
Code Snippet
inner join (select eventid, sum(px) as sum_px, sum(py) as sum_py
from isolatedLeptons
group by eventid
) l
on e.idevent=l.eventid
If so, you might be able to eliminate the last INNER JOIN
|||Dale:
Are "l.sum_px" "l2.sum_py" in scope in this line?
dbo.effectiveMass(e.PxMiss,e.PyMiss,l.sum_px,l2.sum_py)<= 150.0
I thought these would be out of scope
|||Ah man. I completely missed that.
Still early...where'd that coffee pot go?
Thanks Kent
Sunday, March 11, 2012
Diagrams not appearing in Enterprise Manager
Hi
I can create new diagrams and view them but cannot open exesting diagrams.
Anon
Originally posted by ANON
Hi
I can create new diagrams and view them but cannot open exesting diagrams.
Anon
Apparently my issue was related to Visual Studio SP6. I didn't make the connection, but I saw others discussing this on another site.
The issue is with a file called mdt2df.dll. Replace this file with another version. The one that is in the C:\Program Files\Common Files\Microsoft Shared\MSDesigners98 was the one that my system was using. I found an older version in C:\Program Files\Microsoft Office2K\ODETools\V9\Runtime\FULL\PFILES\COMMON\MS SHARED\MSDESIGN. The older version worked.
Good luck!
Jeff|||Thank you for sharing! It saved my day!
/Bard
I can create new diagrams and view them but cannot open exesting diagrams.
Anon
Quote:
Hi
I can create new diagrams and view them but cannot open exesting diagrams.
Anon
Apparently my issue was related to Visual Studio SP6. I didn't make the connection, but I saw others discussing this on another site.
The issue is with a file called mdt2df.dll. Replace this file with another version. The one that is in the C:\Program Files\Common Files\Microsoft Shared\MSDesigners98 was the one that my system was using. I found an older version in C:\Program Files\Microsoft Office2K\ODETools\V9\Runtime\FULL\PFILES\COMMON\MS SHARED\MSDESIGN. The older version worked.
Good luck!
Jeff|||Thank you for sharing! It saved my day!
/Bard
Diagrams NOT appearing in Enterprise Manager
Hi
I have XP Prof 2002 with SQL Client Tools installed,I can create and view
new diagrams but cannot open and view existing diagrams.
-ANON
Originally posted by ANON
Hi
I have XP Prof 2002 with SQL Client Tools installed,I can create and view
new diagrams but cannot open and view existing diagrams.
-ANON
Any help would be greatly appreciated.
Thanks,
Jeff
I have XP Prof 2002 with SQL Client Tools installed,I can create and view
new diagrams but cannot open and view existing diagrams.
-ANON
Quote:
Hi
I have XP Prof 2002 with SQL Client Tools installed,I can create and view
new diagrams but cannot open and view existing diagrams.
-ANON
Any help would be greatly appreciated.
Thanks,
Jeff
Diagramming Print bug
Can someone tell me where to turn in bugs for SQL server?
I'm using the MS SQL Server Management Studio and when I change my table to
custom view and print them, they are printing funny. I can send the
printout to someone if needed.
Thanks!
Velvet
http://connect.microsoft.com/SQLServer
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Velvet" wrote:
> Can someone tell me where to turn in bugs for SQL server?
> I'm using the MS SQL Server Management Studio and when I change my table
> to custom view and print them, they are printing funny. I can send the
> printout to someone if needed.
> Thanks!
> Velvet
>
|||Hello Velvet,
Yes. You could submit via the link
http://connect.microsoft.com/SQLServer
I'd like to know if the version of SQL you installed? Did you apply SP1 or
SP2 CTP on the machine. You may let me know the exact reproduce steps and
send the screen shot you see to me. Plesase remove "online" in my email
address.
I look forward to your reply. Thank you!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Velvet (MSDNNospam216@.nospam.nospam) writes:
> Can someone tell me where to turn in bugs for SQL server?
> I'm using the MS SQL Server Management Studio and when I change my table
> to custom view and print them, they are printing funny. I can send the
> printout to someone if needed.
I found a couple of bugs on diagram printing:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=183815
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124922
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124788
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124760
Looks like there is little hope for fixes in service packs.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
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
|||Hello Velvet,
I'm still interested in this issue. If you'd like to provide the related
information, please feel free to send me an email. We look forward to
hearing from you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Sorry, snow days up here where we are not used to getting snow... (Northwest
Washington)
I'm not quite sure I know how to tell you to repro the problem since it
happens on all of my diagrams. I have my tables in 'Table View' -- >
'Custom'. Columns showing are Column Name, Condensed Type, Allow Nulls, and
Identity.
The first one I printed only had two tables on it and was on one page. The
first few columns did not list the colum names where they were supposed to
be and I ended up having to write them in for my meeting. I still have this
one... It looks like the corner of somethign is covering it up and it's
shadded and has a double border. This only happened on one of the tables.,
the other table is fine except that where I would expect it to be blank, the
shading and border shows up at the bottom under the column.
On my bigger diagram, I didn't have to write anything in, but again where
there should be blank space along the right and bottom and there's some sort
of graphic trying to come through. It's very strange.
I saved it to a *.mdi file and I will forward it to you.
Here's my Management Studio info:
Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
Thanks,
Velvet
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:vLisdrfNHHA.2024@.TK2MSFTNGHUB02.phx.gbl...
> Hello Velvet,
> I'm still interested in this issue. If you'd like to provide the related
> information, please feel free to send me an email. We look forward to
> hearing from you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> ================================================== ====
>
I'm using the MS SQL Server Management Studio and when I change my table to
custom view and print them, they are printing funny. I can send the
printout to someone if needed.
Thanks!
Velvet
http://connect.microsoft.com/SQLServer
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Velvet" wrote:
> Can someone tell me where to turn in bugs for SQL server?
> I'm using the MS SQL Server Management Studio and when I change my table
> to custom view and print them, they are printing funny. I can send the
> printout to someone if needed.
> Thanks!
> Velvet
>
|||Hello Velvet,
Yes. You could submit via the link
http://connect.microsoft.com/SQLServer
I'd like to know if the version of SQL you installed? Did you apply SP1 or
SP2 CTP on the machine. You may let me know the exact reproduce steps and
send the screen shot you see to me. Plesase remove "online" in my email
address.
I look forward to your reply. Thank you!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Velvet (MSDNNospam216@.nospam.nospam) writes:
> Can someone tell me where to turn in bugs for SQL server?
> I'm using the MS SQL Server Management Studio and when I change my table
> to custom view and print them, they are printing funny. I can send the
> printout to someone if needed.
I found a couple of bugs on diagram printing:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=183815
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124922
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124788
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124760
Looks like there is little hope for fixes in service packs.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
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
|||Hello Velvet,
I'm still interested in this issue. If you'd like to provide the related
information, please feel free to send me an email. We look forward to
hearing from you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Sorry, snow days up here where we are not used to getting snow... (Northwest
Washington)
I'm not quite sure I know how to tell you to repro the problem since it
happens on all of my diagrams. I have my tables in 'Table View' -- >
'Custom'. Columns showing are Column Name, Condensed Type, Allow Nulls, and
Identity.
The first one I printed only had two tables on it and was on one page. The
first few columns did not list the colum names where they were supposed to
be and I ended up having to write them in for my meeting. I still have this
one... It looks like the corner of somethign is covering it up and it's
shadded and has a double border. This only happened on one of the tables.,
the other table is fine except that where I would expect it to be blank, the
shading and border shows up at the bottom under the column.
On my bigger diagram, I didn't have to write anything in, but again where
there should be blank space along the right and bottom and there's some sort
of graphic trying to come through. It's very strange.
I saved it to a *.mdi file and I will forward it to you.
Here's my Management Studio info:
Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
Thanks,
Velvet
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:vLisdrfNHHA.2024@.TK2MSFTNGHUB02.phx.gbl...
> Hello Velvet,
> I'm still interested in this issue. If you'd like to provide the related
> information, please feel free to send me an email. We look forward to
> hearing from you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> ================================================== ====
>
diagram object behavior in EM
Dear Collective Wisdom,
Noticed something odd back when we first upgraded to XP in that when one
goes to view an existing relational diagram object for a database in
Enterprise Manager, everything appears blank in the diagram. New
diagrams, OTOH, can be created and viewed without any problem. Any ideas?
Thanks in advance!
gms--
Maybe this link will help you:
http://www.yiapap.com/bldiagra.htm
Cristian Lefter, SQL Server MVP
"Greg M. Silverman" <gmsRE@.MOVEumn.MEeduAT.COM> wrote in message
news:d48i5q$1m8$1@.lenny.tc.umn.edu...
> Dear Collective Wisdom,
> Noticed something odd back when we first upgraded to XP in that when one
> goes to view an existing relational diagram object for a database in
> Enterprise Manager, everything appears blank in the diagram. New
> diagrams, OTOH, can be created and viewed without any problem. Any ideas?
>
> Thanks in advance!
>
> gms--
|||Cristian Lefter wrote:
> Maybe this link will help you:
> http://www.yiapap.com/bldiagra.htm
> Cristian Lefter, SQL Server MVP
Thanks for the link... I did find this also info in the depths of
Technet, have yet to try it.
gms--
> "Greg M. Silverman" <gmsRE@.MOVEumn.MEeduAT.COM> wrote in message
> news:d48i5q$1m8$1@.lenny.tc.umn.edu...
>
>
|||Greg M. Silverman wrote:
> Cristian Lefter wrote:
>
> Thanks for the link... I did find this also info in the depths of
> Technet, have yet to try it.
>
> gms--
>
Ok, just did it and it worked!
Thanks!
gms--
Noticed something odd back when we first upgraded to XP in that when one
goes to view an existing relational diagram object for a database in
Enterprise Manager, everything appears blank in the diagram. New
diagrams, OTOH, can be created and viewed without any problem. Any ideas?
Thanks in advance!
gms--
Maybe this link will help you:
http://www.yiapap.com/bldiagra.htm
Cristian Lefter, SQL Server MVP
"Greg M. Silverman" <gmsRE@.MOVEumn.MEeduAT.COM> wrote in message
news:d48i5q$1m8$1@.lenny.tc.umn.edu...
> Dear Collective Wisdom,
> Noticed something odd back when we first upgraded to XP in that when one
> goes to view an existing relational diagram object for a database in
> Enterprise Manager, everything appears blank in the diagram. New
> diagrams, OTOH, can be created and viewed without any problem. Any ideas?
>
> Thanks in advance!
>
> gms--
|||Cristian Lefter wrote:
> Maybe this link will help you:
> http://www.yiapap.com/bldiagra.htm
> Cristian Lefter, SQL Server MVP
Thanks for the link... I did find this also info in the depths of
Technet, have yet to try it.
gms--
> "Greg M. Silverman" <gmsRE@.MOVEumn.MEeduAT.COM> wrote in message
> news:d48i5q$1m8$1@.lenny.tc.umn.edu...
>
>
|||Greg M. Silverman wrote:
> Cristian Lefter wrote:
>
> Thanks for the link... I did find this also info in the depths of
> Technet, have yet to try it.
>
> gms--
>
Ok, just did it and it worked!
Thanks!
gms--
Sunday, February 19, 2012
Developer and DTS rights
To adhere to corporate security policies we have removed the guest
account from msdb. This has resulted in developers not having the
ability to view any dts packages on the server. We have multiple
development groups and a large amount of databases on the server.
Does anyone have a solution to this situation that we could use?
Thanks in advance, Markassign a security group a login to the sql server,
grant dbaccess to the msdb database for that user.
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Mark Anderson" <magnm01@.wellsfargo.com> wrote in message
news:ac3d559a.0401141350.68879fa9@.posting.google.com...
> To adhere to corporate security policies we have removed the guest
> account from msdb. This has resulted in developers not having the
> ability to view any dts packages on the server. We have multiple
> development groups and a large amount of databases on the server.
> Does anyone have a solution to this situation that we could use?
> Thanks in advance, Mark
account from msdb. This has resulted in developers not having the
ability to view any dts packages on the server. We have multiple
development groups and a large amount of databases on the server.
Does anyone have a solution to this situation that we could use?
Thanks in advance, Markassign a security group a login to the sql server,
grant dbaccess to the msdb database for that user.
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Mark Anderson" <magnm01@.wellsfargo.com> wrote in message
news:ac3d559a.0401141350.68879fa9@.posting.google.com...
> To adhere to corporate security policies we have removed the guest
> account from msdb. This has resulted in developers not having the
> ability to view any dts packages on the server. We have multiple
> development groups and a large amount of databases on the server.
> Does anyone have a solution to this situation that we could use?
> Thanks in advance, Mark
Developer and DTS rights
To adhere to corporate security policies we have removed the guest
account from msdb. This has resulted in developers not having the
ability to view any dts packages on the server. We have multiple
development groups and a large amount of databases on the server.
Does anyone have a solution to this situation that we could use?
Thanks in advance, Markassign a security group a login to the sql server,
grant dbaccess to the msdb database for that user.
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Mark Anderson" <magnm01@.wellsfargo.com> wrote in message
news:ac3d559a.0401141350.68879fa9@.posting.google.com...
account from msdb. This has resulted in developers not having the
ability to view any dts packages on the server. We have multiple
development groups and a large amount of databases on the server.
Does anyone have a solution to this situation that we could use?
Thanks in advance, Markassign a security group a login to the sql server,
grant dbaccess to the msdb database for that user.
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Mark Anderson" <magnm01@.wellsfargo.com> wrote in message
news:ac3d559a.0401141350.68879fa9@.posting.google.com...
quote:
> To adhere to corporate security policies we have removed the guest
> account from msdb. This has resulted in developers not having the
> ability to view any dts packages on the server. We have multiple
> development groups and a large amount of databases on the server.
> Does anyone have a solution to this situation that we could use?
> Thanks in advance, Mark
Friday, February 17, 2012
Developer Access
Can someone advise potential security concerns in giving VIEW SERVER STATE
access to developers on production server?guest5.
VIEW SERVER STATE exposes information about the server and its current
state. (As you might guess by the name.) This allows you to see all
processes that are running in 'sp_who' and, in general, makes the statistics
in the dynamic management views visible. It also allows a user to use DBCC
INPUTBUFFER
In the Books Online if you search for "VIEW SERVER STATE" you will get about
110 things reported there, if you want to review the details.
The question is: Who needs this level of information? I think it is
reasonable for those who actively support the databases and server to have
this access, but I would not make it generally available.
RLF
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:20CC60D6-8D82-4CBB-B6C8-9D2466B27624@.microsoft.com...
> Can someone advise potential security concerns in giving VIEW SERVER STATE
> access to developers on production server?
access to developers on production server?guest5.
VIEW SERVER STATE exposes information about the server and its current
state. (As you might guess by the name.) This allows you to see all
processes that are running in 'sp_who' and, in general, makes the statistics
in the dynamic management views visible. It also allows a user to use DBCC
INPUTBUFFER
In the Books Online if you search for "VIEW SERVER STATE" you will get about
110 things reported there, if you want to review the details.
The question is: Who needs this level of information? I think it is
reasonable for those who actively support the databases and server to have
this access, but I would not make it generally available.
RLF
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:20CC60D6-8D82-4CBB-B6C8-9D2466B27624@.microsoft.com...
> Can someone advise potential security concerns in giving VIEW SERVER STATE
> access to developers on production server?
Subscribe to:
Posts (Atom)