Hi all,

Thank you for your suggestions.

Finally I uninstalled sql 7 and reinstall sql7 .My problem solved.

Hi Sumit,

Startup Account Administrator and the administrator has full rights on the E:\mssql7 directory.

Thank You DKS,Sumit,

Even my System Administrator is unable to start the mssql service giving the same error. I checked the file db290305_data.mdf it is not read only.

Yesterday evening i...

Hi Colin

I tried Checkdb no use. Simply i moved the physical files to another system there i did attach and detach it's working fine. I found from microsoft website...

Hi,

Is there any procedure runs each minute to prevent unauthorised users from accessing the EM by identifing their system name/I.P.Address? Any ideas?

Hi Ashok,

Pl go through this it may help to you.

Set Transaction Isolation level ....in the help.

Hi,

Thank You all for your suggestions and advices.

Hai Lowell,

Very good script keep it up.

Hai,

Solved your problem?

May be this is your problem. You are trying attach an mdf file from version 7 to 2000.

Pl find out version and attach the db...

Hai,

Pls check the DB version what you are attaching and where you are attaching the database. Still you have problems, Just go through the microsoft website for complete...

Go to Enterprise Manager,select database, select the table name and select the column name right click select design table. You can change what ever you want. Ok....

You can try this also.....

select a.name table_name,xtype,b.name index_name from sysobjects a,sysindexes b where a.xtype = 'U' and a.id=b.id order by a.name

You try this

exec sp_attach_single_file_db @dbname = 'Envnew', @physname = 'D:\K-Plus\EngineeringDB\Database\EnvNew.mdf'

Hi Karl,

My server is up and running no down time. How the check point occurs?

Thank you for ur explanation.

Hi,

I am using Microsoft sql Server 2000 - 8.00.194.

I executed the above two statements still i am getting the same error.