Thanks Elisabeth.

Your help is really appreciated.

Thanks for Microsoft articale which is very helpful.

Regards,

V

Hi Elizabeth,

Thank you for your reply.

It is very strange why DATA folder disappeared.

Fortunately I have resolved it now and nothing much I have done !

I have shutdown cleanly all servers...

Did you try to capture following event classes under StoredProcedures ?

They will provide you more details on sql statements within stored procedures.

SP:Starting

SP:Completed

SP:StmtStarted

SP:StmtCompleted

You probably might have done but suggesting just...

Thanks Guys for your reply.

Apologies.I think I have pasted the table scripts with incorrect syntax, however my point is to concentrate more on this error.

Anyway the correct syntax is as...

Hi Sandy,

Thanks for reply.

There is no problem on database names.

One DB is on 2005 and another is on 2000.

The both DBs are identical in schema and data.

Anyway here is...