<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://forums.blackbaud.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Database Administrators/Technical</title><link>http://forums.blackbaud.com/forums/18.aspx</link><description /><dc:language>en</dc:language><generator>CommunityServer 2007 SP2 (Debug Build: 20611.960)</generator><item><title>SQL SRV 2005 setup</title><link>http://forums.blackbaud.com/forums/thread/23243.aspx</link><pubDate>Fri, 30 Mar 2007 18:46:52 GMT</pubDate><guid isPermaLink="false">f90a95a0-00e2-4810-8af8-0bbdde08f853:23243</guid><dc:creator>George Leventis</dc:creator><slash:comments>0</slash:comments><comments>http://forums.blackbaud.com/forums/thread/23243.aspx</comments><wfw:commentRss>http://forums.blackbaud.com/forums/commentrss.aspx?SectionID=18&amp;PostID=23243</wfw:commentRss><description>Hi Cody,

For what it's worth, I asked our DBA here and he sent me the following message:

use master
GO
grant view server state to myUser

and to remove it:
revoke view server state from myUser

Hope that helps!
- George</description></item><item><title>SQL SRV 2005 setup</title><link>http://forums.blackbaud.com/forums/thread/23234.aspx</link><pubDate>Fri, 30 Mar 2007 13:19:30 GMT</pubDate><guid isPermaLink="false">f90a95a0-00e2-4810-8af8-0bbdde08f853:23234</guid><dc:creator>Cody Ensanian</dc:creator><slash:comments>0</slash:comments><comments>http://forums.blackbaud.com/forums/thread/23234.aspx</comments><wfw:commentRss>http://forums.blackbaud.com/forums/commentrss.aspx?SectionID=18&amp;PostID=23234</wfw:commentRss><description>new to DB administering..... just installed sql server 2005 on a new server, install re7.81, i need to apply &amp;quot;view server state&amp;quot; permission to my windows users that access RE... how do i do this??</description></item></channel></rss>