You can get a list of all the triggers in the database by following command in Query Analyzer.

select name from sysobjects where type = 'tr'

you can view the code of...

Let me rephrase the question. I need to create an interface using which a user who does not directly work with SQL Server can create roles, logins, give rights to...

You can create a batch file with the following code. Replace the path,tablename,userid, password,server with your path.

bcp db.dbo.tablename in c:\bcpdata\filename.txt -Uuser -Ppassword -server -c

pause