I have not yet worked in a DBA role (except for a development "DBA" role where I was really more of a developer who helped with some DBA duties) where I did not have at least Local Administrator rights. Very rare to have domain admin rights (and to be quite honest I don't want them and I don't want my systems folks to want me to be a Domain Admin just like I don't want to keep BUILTIN\ADMINISTRATORS in the server where all the systems folks can "play" with my production SQL Servers).
I can't speak for everyone out there but I think it is more common than not for a DBA to be a local admin of a SQL box.
Mike, I agree and I'm finally getting my CIO's support for local admin rights on sql boxes -- our chief network admin still seems cool to this idea but is being overruled. My reason for bringing this up here is that the windows utilities that started this thread are quite often not useful unless you have these kinds of rights.
I'd like to end my aspect of this thread as I have a similar one now over under the sql 2005 administration forum.
Due to make full set of TS commands posted above:
master..XP_CMDSHELL 'QUERY SESSION'master..XP_CMDSHELL 'logoff sessionid'
I post additional - That will Disconnect the session without
logoff:exec master..XP_CMDSHELL 'TSDISCON sessionid'
This is really great stuff....and Terminal service stuff though i used to do it from command prompt but this is very handy
great utilities.....i believe this article should be promoted every 6 months so that nobody miss it....
Good written! I made a print out and posted on the wall to share with other co-workers since last year. Thanks!