Server’s free disk space:

xp_fixeddrives  

Determine logspace: 

dbcc sqlperf (logspace)  

TempDB size:

 sp_tempdbspace  

select 
   current_timestamp as Time,
   user as Benutzer,
   system_user as System_Benutzer,
   current_user as Current_Benutzer,
   session_user as Session_Benutzer   

sp_who2 


Useful stored procedures: 

sp_helpdb -- Displays information about all databases on the server
sp_helpdb databasename -- Displays information about a particular database
sp_help objectname -- Displays information about a table
sp_spaceused -- Displays information about the space used in the current database
sp_tables -- Lists the tables in a database
sp_helptext name -- Displays the code used in a particular stored procedure
sp_dboption -- Sets or returns information about database options