Was sql server restarted after the appserver command execution was done?

The local definition takes effect only after the server is shut down and restarted. Only one local server can be...

Please execute DBCC CHECKDB with ALL_ERRORMSGS,NO_INFOMSGS

MJ

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