public DataSet GetActiveProcesses(string serverName,string user, string password) 
{ 
/* 
This method is created by Anton Zamov. 
web site: http://zamov.online.fr 

Feel free to use and redistribute this method 
in condition that you keep this message intact. 
*/ 

                  DataSet ds = new DataSet(); 

                  try 
                  { 


                  SqlConnection cn = new SqlConnection("Server="+serverName+"; Database=master; UId="+user+"; Pwd="+password+""); 

                  SqlDataAdapter cmd = new SqlDataAdapter("select spid,loginame,hostname,cpu,memusage,cmd,status from sysprocesses where status='runnable' order by memusage desc",cn); 



                  cmd.Fill(ds,"nc"); 



                  } 
                  catch(Exception exc) 
                  { 
                        System.Windows.Forms.MessageBox.Show("SQL Server is not running or access is denied!"); 
                  } 

                  return ds; 
}