Troubleshooting MS SQL Server

/* DO NOT JUST EXECUTE THIS SCRIPT. HIGHLIGHT THE COMMAND AND RUN IT */

select @@servername                                      
/* returns name of server. */

select @@version                                         
/* returns the version. */

select @@connections                                     
/* returns number of connections since restarted. */

select @@packet_errors                                   
/* returns number of packet errors since restarted. */

select dbid, DB_NAME(dbid) AS DB_NAME FROM sysdatabases  
/* Returns the database name. */

sp_tables
/* Returns a list of objects (table names) that can be queried in the current environment (any object that can appear in a FROM clause). */

sp_helplogins
/*Provides information about logins and the associated users in each database */