Try executing the stored procedure after re-creating it with WITH RECOMPILE option.

Manu

Check this link then:

How to remove a node from an existing failover cluster (Setup)

http://msdn.microsoft.com/en-us/library/aa216063(SQL.80).aspx

Manu

Try to make use of sp_adduser stored procedure.

Manu Jaidka

Check this out:

http://msdn.microsoft.com/en-us/library/aa216166(SQL.80).aspx

Manu

Whats the output of restore verifyonly fom disk='Backupfilenamewithpath'?

Manu

I think it can be resolved without restarting sql server service by identifying the process sql server is trying to execute external to sql server. In my case it was...

I see there is table scan operator in execution plan. Investigate for which table its doing table scan and why. Is that table missing the required index or is it...

Please check Partitioned View in books online.

Hope this is what you asked for...

Manu

I think script option is available only in SQL 2005.

Manu

Just to add:

SQL Server 2008 includes backup file compression and that too to a good extent.

Manu

Would be helpful if you specify the code over here. Usually it happens for processes that are either running from long time or are executing out of sql server...

I will have to check that. Also, I found that cursor by itself doesn't know that in case resultset is empty then it shldn't proceed. To resolve this either we...

Please verify whether the destination drives specified for mdf and ldf files reside on test server or not.

Manu

Under task manager.

Manu

Regarding logins you can use sp_help_revlogin script located at

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

Yes, regarding jobs, dts packages, alerts and operators you can rely on msdb database restoration.

Manu