Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Problem with MDF File

Author  Topic 

rammohan
Posting Yak Master

212 Posts

Posted - 2008-03-01 : 00:59:02
hi, here i am using sqlserver2005 as back end for my asp.net application. at the end i had taken the .mdf file of project and placed in my app_code folder. but now when i am trying to inser or update or delete records in the tables of .mdf file. its not allowing.but it is allowing to select records. is there any option to do inser,update n delete also .pls show me a way

One can never consent to creep,when one feels an impulse to soar
RAMMOHAN

PeterNeo
Constraint Violating Yak Guru

357 Posts

Posted - 2008-03-01 : 01:49:03
Hi ram,

I want to know how u placed the .mdf file into u r app_code and how u t selecting records.
Go to Top of Page

rammohan
Posting Yak Master

212 Posts

Posted - 2008-03-01 : 05:22:24
hi peter,
i had taken the mdf file of project from C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data by turning my sqlserver2005 to offline. and i placed into my app_data folder by using addexisting item through visul studio.

One can never consent to creep,when one feels an impulse to soar
RAMMOHAN

Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-03-01 : 06:43:11
Is the db in Read-Only Mode?
Also, check the permissions , to see whether they have relevant permissions

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com
Go to Top of Page
   

- Advertisement -