Showing posts with label advise. Show all posts
Showing posts with label advise. Show all posts

Thursday, March 29, 2012

Difference between Standard and Enterprise Edition

Where can I find about differences between two edition. I need to advise thi
s
for a customer who would be quering over the WANHi
http://www.microsoft.com/sql/editio...rd/default.mspx
"Tariq" <Tariq@.discussions.microsoft.com> wrote in message
news:FF73CE26-9939-4621-83B9-67222E648CE9@.microsoft.com...
> Where can I find about differences between two edition. I need to advise
> this
> for a customer who would be quering over the WAN

Difference between Standard and Enterprise Edition

Where can I find about differences between two edition. I need to advise this
for a customer who would be quering over the WANHi
http://www.microsoft.com/sql/editions/standard/default.mspx
"Tariq" <Tariq@.discussions.microsoft.com> wrote in message
news:FF73CE26-9939-4621-83B9-67222E648CE9@.microsoft.com...
> Where can I find about differences between two edition. I need to advise
> this
> for a customer who would be quering over the WANsql

Difference between Standard and Enterprise Edition

Where can I find about differences between two edition. I need to advise this
for a customer who would be quering over the WAN
Hi
http://www.microsoft.com/sql/edition...d/default.mspx
"Tariq" <Tariq@.discussions.microsoft.com> wrote in message
news:FF73CE26-9939-4621-83B9-67222E648CE9@.microsoft.com...
> Where can I find about differences between two edition. I need to advise
> this
> for a customer who would be quering over the WAN

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?