Hi,

Got this resolved.

Will post with complete details.

Regards,

Naveen. N

Hi Sunil,

I did in the same process.

My Devlopment(SQL2K8Dev) and Staging(SQL2K8Stg) servers are having different names.

In the staging server i modified the config file connection string, parameters accordingly.

Getting following Error: The...

Hi Sean,

Thanks for the quick reply.

I tried using different variables, even though it's same.

It would be great help if you can let me know to get rid of cursor.

Regards,

Naveen. N

Hi Pradeep,

The process is not still running, but i am unable to kill single process which is running in the server.

Thanks in Advance.

Hi All,

Can anyone help me on this issue.

Thanks in Advance.

Hi Pradeep,

Please cross check the screen shots. It has been running during the time.

Thanks in Advance.

Hi Pradeep,

It didn't give any errors.

Thanks in Advance.

Hi CirquedeSQLeil,

All the SQL 2000 servers using in my environment are with SP4.

ignore my mistake.

Thanks in Advance.

Hi ,

I took backup and restored the database to a different server.

Kill process is working fine in the server(SQL 2000 with SP2).

previous server and new server are in same...

Hi CirquedeSQLeil,

Cross checked checdb on all databases, didn't find any error.

Thanks in Advance.

Hi CirquedeSQLeil,

Thanks for your quick reply.

I am not using kill -61, please go through the screen shots attached.

Waiting for reply.

Thanks in advance.