Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Windows Utilities for the SQL Server DBA Expand / Collapse
Author
Message
Posted Sunday, September 10, 2006 6:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 21, 2008 11:14 AM
Points: 3, Visits: 25

Randy -

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.

Post #307473
Posted Sunday, September 10, 2006 1:17 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 25, 2014 7:59 PM
Points: 596, Visits: 1,678

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.

thanks,

Randy




Post #307500
Posted Wednesday, September 13, 2006 5:11 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, July 26, 2014 9:38 PM
Points: 66, Visits: 524

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'

 

 

Post #308140
Posted Wednesday, April 25, 2007 6:35 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 21, 2014 11:32 AM
Points: 372, Visits: 414

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....

Cheers...Prakash



Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
Post #361015
Posted Tuesday, June 19, 2007 8:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 3, 2013 12:05 PM
Points: 1, Visits: 132
That was really useful
Post #374979
Posted Friday, September 7, 2007 9:47 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 12:31 PM
Points: 55, Visits: 565

Chad,

Good written! I made a print out and posted on the wall to share with other co-workers since last year. Thanks!




Post #397333
Posted Monday, June 23, 2008 5:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 5, 2009 11:58 AM
Points: 1, Visits: 2
anybody have a copy of the
logicaldisk.xsl.
listed in the article? Mainly need the %free column, and I belive that is being calculated via the xsl?
Thanks,
Nigel
Post #522267
Posted Monday, June 23, 2008 7:30 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
What happened to the article that this topic was linked to? It appears to be dead.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #522286
Posted Tuesday, June 24, 2008 4:52 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Saturday, July 12, 2014 6:44 AM
Points: 441, Visits: 1,799
The link is dead, but you can still find the article here. http://www.sqlservercentral.com/articles/Miscellaneous/2586/

Dave J



http://glossopian.co.uk/
"I don't know what I don't know."
Post #522420
Posted Tuesday, June 24, 2008 5:00 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
Thnx!

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #522423
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse