You need to evaluate your server permissions to know who can create triggers at server level.

By Definition that is not possible.

sp_addlinkedsrvlogin [ @rmtsrvname = ] 'rmtsrvname'

[ , [ @useself = ] 'TRUE' | 'FALSE' | 'NULL']

...

Please try to use this script.

WITH perms_cte as

(

select USER_NAME(p.grantee_principal_id) AS principal_name,

...

Please review this article.

http://technet.microsoft.com/en-us/magazine/2008.04.overview.aspx?pr=blog

I agree with Elliott W, Triggers are the best options to do it.

You can get the list of Active Directory users for every Group create in SQL Server.

Regards

Your should consider evaluate the audit options in SQL Server 2008 instead of modify the original security settings.

Question 1: If I add another instance for sql2008 that takes 4 cores and 12gb mem and run it on the same node as SQL2000 that should be okay. If...

Please read this article.

Database Mirroring Best Practices and Performance Considerations

http://technet.microsoft.com/en-us/library/cc917681.aspx

You should copy the backup from Veritas Tool Tape to physical disk before to start the restore process.

Which one is the best possible configuration?

The configuration depends or your business rules and service level agreement.

How many IP address will be reuired for the 4 SQL Server Instances?

One IP...

I recommend you enable these options, in order to ensure the best way to memory assignment in 64 bit platform.

1. enable AWE.

2. set 'Lock Pages In Memory'.

This question got answer into of this forum.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=136107

Hi

What exactly is your question?

You can use this reference from Microsoft MSDN site.

http://msdn.microsoft.com/en-us/library/ms179530%28SQL.90%29.aspx

Also review this webcast

http://support.microsoft.com/kb/891798