you have to install the witness to a separate machine not the same two involved on mirroring

yes it's possible to have mssql 2005 as subscriber and mssql 7 as publisher

in msdb you can use sp_send_dbmail

check status in sysdatabases must be suspect for corrupted mdf files

use not exist instead of in

it's the same setting like /3GB ,but it's for windows 2003 servers .

You can put almost all RAM that you have but put /USERVA and /PAE in boot.ini ,enable AWE and put 'max server memory' and 'min server memory' with...

check if you are using large objects,LOB and try to reduce the level of locking checking for indexes,denormalize the table.

check this http://support.microsoft.com/kb/323630

hello,

you have to upgrade to mssql 2000 and next to 2008

hi,

you can start a new trace and select filter afetr an objectID and in text data like delete,insert ,update.

INSERT INTO Table (ImageColumn)

SELECT * FROM OPENROWSET (BULK N'C:\YourPicture.bmp', SINGLE_BLOB)

I belive you could fliter the ObjectID and Text like insert,delete,update

http://msdn.microsoft.com/en-us/library/ms140277.aspx

there is FTP Tasks,also use XML Source Adapter in SSIS 2005. for xml files.