sp_who2

CREATE TABLE #sp_who2 (SPID INT,Status VARCHAR(255),
      Login VARCHAR(255),HostName VARCHAR(255),
      BlkBy VARCHAR(255),DBName VARCHAR(255),
      Command VARCHAR(255),CPUTime INT,
      DiskIO INT,LastBatch VARCHAR(255),
      ProgramName VARCHAR(255),SPID2 INT,
      REQUESTID INT)
INSERT INTO #sp_who2 EXEC sp_who2
SELECT      *
FROM        #sp_who2
-- Add any filtering of the results here :
WHERE       DBName <> 'master'
-- Add any sorting of the results here :
ORDER BY    DBName ASC

DROP TABLE #sp_who2

SP File Exists

https://stackoverflow.com/questions/11740000/check-for-file-exists-or-not-in-sql-server
CREATE FUNCTION dbo.fn_FileExists(@path varchar(512))
RETURNS BIT
AS
BEGIN
     DECLARE @result INT
     EXEC master.dbo.xp_fileexist @path, @result OUTPUT
     RETURN cast(@result as bit)
END;
GO

Export out to a file

--Export data out to file
EXEC XP_CMDSHELL 'net use y: \\SERVERNAME\SHARENAME$'
EXEC master..xp_cmdshell 'SQLCMD -S SQLSERVER -E -q "SELECT TOP (5) [sDBname],[sOwner],[sDesc],[dDateTime]FROM [DB].[dbo].[Table]  " -s, -W -o "Y:\ThisIsAnOutputFile.CSV" '
EXEC XP_CMDSHELL 'net use y: /delete'