http://download.microsoft.com/download/0/d/f/0dfe488e-a335-4480-8a8a-b405e32f4368/SQL2005_Sys_Views.pdf

MJ

To determine the true reason for the failure, look in the server's error log where a corresponding entry will be written.

MJ

Have you checked this-->http://www.kodyaz.com/articles/change-data-capture.aspx

MJ

From books online-->

To view the Activity Monitor the user needs VIEW SERVER STATE permission on a SQL Server 2005 server.

To view the Activity Monitor the user needs SELECT permission to...

Query destination table using NOLOCK table hint.

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

MJ

Better create 4 data files of equal size. Creating 4 log files doesn't seem to solve any purpose(Experts comment!).

download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/WorkingWithTempDB.doc

MJ

Check the file version of any dll files under setup folder. It will help you in identifying the edition. For example:9.00.1399.06 is RTM Edition. A type of guess....

MJ

First command must be an update statement under this(spProcessTransaction) SP and it should be at line#503(Let experts comment about line#)

EXEC spProcessTransaction

UPDATE Line #: 503

Second command must be an delete...

Don't forget to change database compatibility level to 100 after restoration so that you can enjoy the new functionalities present in SQL Server 2008.

MJ

See "Using Upgrade Advisor to Prepare for Upgrades" at

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

MJ

You need to transfer logins prior to database restoration so tht restoration doesn't result in orphan users.

For more information on Transfer Logins Task:

· ...

Chk-->http://msdn.microsoft.com/en-us/library/ms143215(SQL.90).aspx

MJ

Is it listening on static port or dynamic one? Also, check whether aliases have been configured on second node or not.

MJ

Is browser service running on that node? If not, then enable it and start it.

MJ

Better choose windows authentication and after upgrade don't forget to enable sa login and specifying a strong password for it.

MJ