SQL Admin : Dbcc shrinkfile sql troubleshooting compress tempdb
use
tempdb
go
dbcc
shrinkfile (2, 10)
go
dbcc
shrinkfile (1,10)
SCCM SQL Query : To List Machines With IIS , FTP Or Telnet Installed
Select SD.Name0 ‘Machine Name’, SD.Operating_System_Name_and0 NOS, SS.Name0 ‘Service Name’, SS.DisplayName0 ‘Display Name’, SS.StartMode0 ‘Start Type’, SS.Started0 Started, SS.State0 State, SS.Status0 Status From System_DISC SD Join Services_DATA SS on SS.MachineID = SD.ItemKey Where SS.Name0 In (‘W3SVC’, ‘MsFtpSvc’, ‘TlntSvr’) Order By ‘Machine Name’
Comments
Post a Comment