Hi,

Let me recommend you this free tool:

http://www.idera.com/productssolutions/freetools/sqlpermissionsextractor?utm_source=sqlcheck&utm_medium=inproduct&utm_campaign=sqlfreetools&utm_content=tab

Free Tool SQL Permissions Extractor. FREE extraction and migration of permissions from objects in SQL:

•Generate T-SQL scripts for copying of user...

How to Monitor for High CPU utilization in SQL Server >

http://www.sqlservercentral.com/articles/CPU/71388

Regards.

Hi,

have a look at this article:

http://www.databasejournal.com/features/mssql/article.php/3550601/Automatically-Running-a-Process-When-SQL-Server-or-SQL-Agent-Starts.htm

Regards.

BrainDonor,

Do you have a similar code for SQL 2000 ?

Thank you.

use model

select * from sys.server_principals

and not principles

OK ??