SQL DBAs daily using Queries
1) xp_fixeddrives
2) select * from sys.sysdatabases
3) sp_helpdb
4) Sp_helpuser
5) select * from sys.sysaltfiles
6) sp_who , sp_who2
7)dbcc sqlperf(logspace)
8)select * from sys.sysproesses where blocked<>0
9)dbcc inputbuffer(sid)
10) sp_helpfile
11)sp_change_users_login 'report'
1) xp_fixeddrives
2) select * from sys.sysdatabases
3) sp_helpdb
4) Sp_helpuser
5) select * from sys.sysaltfiles
6) sp_who , sp_who2
7)dbcc sqlperf(logspace)
8)select * from sys.sysproesses where blocked<>0
9)dbcc inputbuffer(sid)
10) sp_helpfile
11)sp_change_users_login 'report'
