Enable "Enable OPENROWSET and OPENDATASOURCE support" option in Surface Area Configuration Manager and try again.., I believe it is disabled by default.

How to manually rebuild Performance Counter Library values

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q300956

Troubleshooting Performance Monitor Counter Problems

http://support.microsoft.com/?id=152513

http://www.sql-server-performance.com/ac_filegroup_performance.asp

Set a reasonable size for the transaction log.

The general rule of thumb for setting the transaction log size is to set it to 20-25 percent of the database size....

Is PK voilation error related to blocker table or application table?

If it is application table then what is the relaton between application table and blocker script?

If you are suspecious about parallalism you can control it using MAXDOP option in your query but you can't change the third party application code...So you can change configuration on...

I don't think any one compares the data after restore...because for smaller dbs fine but what about the dbs >300gb...

When you compare the data with restored copy with production data...

Did you send the test mail when you are setting db mail before you completed configuration?

Check your configuration once again...you have right SMTP server or not...

Read the following articles to get locking mechanism...

SQL Server: Details of Locking

http://www.awprofessional.com/articles/article.asp?p=26890&rl=1

http://msdn2.microsoft.com/en-us/library/ms190615.aspx

Triggers are not good but can't you create a trigger on the table for insert to send the info via db mail?

I don't think you can use multiple witnesses for single mirroring where single witness can be used for multiple mirrorings..... read the following article...

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

The witness server assists the principal...

I don't see any difference between the two versions but are you trying modify the C2 audit trace?

If your __V2_BETA_DEV_R2.DBO.BETA CL retruns less rows when "CL.CHG_NEW = 'n'" then following should be...

How to transfer logins and passwords between instances of SQL Server

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

I don't think both are same and I never used Veritas for sql server. Based my readings both software work differently and they has their own pros and cons..

You can...

When you create a job to execute the dts package you have to specify the ServerName with -S switch...

Make sure you used the correct server name in the job.