I don't think you will get the realtime high volume training any where but if you choose good training institute you be given extra knowledge of high volume manangement...

ex: Solid...

I didn't get what you asked but..

I think you want to recover restored db...

with the following...

RESTOER DATABASE <DB NAME> WITH RECOVERY

Mario,

Run the profiler to see what is happenning behind the scene when you create the object...

As Frank mentioned there is no other way than using undocumented proc to change the...

Puneet,

Who is the owner of the object...Check UID of object in sysobjects table and make sure uid of the object exists in sysusers table...

after run the dbcc commands for repair my database and nothing.

What do mean by "Repair my db and nothing"

Check the following article..

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

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

If you can efford to be table offline, I will prefer to use initialization of subscription...

If you don't want to initialize then try chaging the profile...

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx

I don't think there is any way to repair mdf file...

You can try the following...

1. Backup your mdf and ldf files...

2. Rename mdf to mdf_old and ldf to ldf_old

3. Create...

Check if any frequently executing procedure is recompiling or using incorrect query plan...

I have seen this behaviour when the procedure was not using incorrect plan...

First check the pssdiag.ini file which carries your configuration.

Search ini file for delete word.

Ganesh,

I believe identifier name should not start with a number...

I don't see any problem with solution but I don't prefer SQL server replication for DR.

I will prefer Log shipping over replication if the db size above 50 GB or...

Are you tested with 3GB or 3KB?

3KB is very small size

I don't think Window 2003 standard edition supports cluster and

SQL server 2000 stand. Edtn also will not support cluster where SQL 2005 stand. Edtn. will support cluster...

Here is the link for cumulative hotfix for sp4.

http://www.microsoft.com/downloads/details.aspx?FamilyID=9c9ab140-bdee-44df-b7a3-e6849297754a&DisplayLang=en

Best option will in this case create newdb and copy the data and rename the db...

Try applying latest service pack to see what happens after it...