October 11, 2011 at 10:57 am
Hi Friends i need your help in making script to make Aduit report, My manager need to make a query to generate report from sys tables in below Formate; we need get all the Logins from sql server
SERVER NAME DB NAME Login Title Service Account Role
madison Appli hel436 SQL DBA N SA
Please Help me in this situation Friends.:-)
October 11, 2011 at 11:00 am
That might start you up : exec sp_helplogins
October 11, 2011 at 11:19 am
EXEC sp_helpdb;
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply