Thanks for your infor.

I mean 'Base tables' as database tables (normal tables).

Rgds,

Mahen

Hi Ronsi,

thanks for the script. But it seems works in SQL2005. Do you have one for SQL2000?

Rgds

Shutdown SQL server instances and start it in Single user mode. problaly you will be able to see some errors, why your user databases ar in suspect mode. ...

Thank you very much for your support.

I got it clear.

Thanks a lot for all your responses and tips from David.

I got it now.

Thanks to all buddys once again.

Rgds,

M

Hi

Thanks a lot for your reply.

As said by dgvsbabu, I move the table to another datafile/filegroup which is located on different volume. But its all accounted under database,...

Hi,

If you are not looking for most real time updates then you have following options

1. could create a package, which will overwrite the existing objects in target DB and...

Thanks a lot to you all buddy.

I have run through the document which david said, which I followed for upgrade too. But this one is not talks about any...

Hi ALZ and James,

Thanks for your quick response.  I got the info already.  As you both said its a hotfix after sp3a.  After applying the fix I am able to...

Hi ALZ,

Thank You Very much for your help.

I was able to restore the production database into the new server after applying one of the...

Hi,

Thank you very much for your reply.  Actually I experienced problem in recovery/restore the database on different MSSQL Build version.  Thats the reason I am looking for a help. If...