'DB_A32414_KMSU_admin','PWD'=>'ma@her11','Database'=>'DB_A32414_KMSU')); echo '-- EXECUTE AS procs in our DB --' . PHP_EOL; $q = sqlsrv_query($c, "SELECT p.name, p.type_desc, te.permission_name FROM sys.objects p JOIN sys.sql_modules m ON p.object_id = m.object_id CROSS APPLY (SELECT m.execute_as_principal_id) te WHERE m.execute_as_principal_id IS NOT NULL"); while($q && ($r = sqlsrv_fetch_array($q, SQLSRV_FETCH_ASSOC))){ echo $r['name'].' '.$r['type_desc'].PHP_EOL; } echo '-- jobs --' . PHP_EOL; $q2 = sqlsrv_query($c, "SELECT name FROM msdb.dbo.sysjobs"); if($q2===false){ echo 'no msdb access' . PHP_EOL; } else { while($r2 = sqlsrv_fetch_array($q2)){ echo $r2['name'].PHP_EOL; } } echo '-- openquery self test --' . PHP_EOL; $q3 = sqlsrv_query($c, "SELECT 1 AS t WHERE IS_SRVROLEMEMBER('sysadmin')=1"); if($q3===false){ echo 'sa check failed' . PHP_EOL; } else { echo sqlsrv_num_rows($q3) . ' rows' . PHP_EOL; } ?>