无法插入，更新数据库 [英] can't insert,update db

问题描述

我从所有任务中恢复了数据库-> recover(Microsoft Sql Server Enterprise).现在我可以从db中读取(选择查询)，但是我不能写入.我知道这与权利有关，但无法弄清楚.当我尝试运行插入，更新命令时，它给出无效的对象表名"错误.

I recovered a db from all tasks->recover (Microsoft Sql Server Enterprise). Now I can read (select queries) from db but i can''t write. I know that this has to do something with rights but can''t figure out. When I try to run an insert,update command it gives ''invalid object tablename'' error.

推荐答案

尝试创建新的数据库并尝试使用导入和导出数据获取数据的工具

Try creating a new db and try using import & export data tool to get data

我已经尝试过使其正常工作

I have tried this its working properly

create table sec_user_log (userid int,username varchar(50))
insert into sec_user_log (userid,username) values (1,'john')
select * from sec_user_log

可以运行 DBCC CHECKDB [

Maybe run DBCC CHECKDB[^] against your database, make sure it''s all OK. You might need a repair \ rebuild

Use database_name
GO

ALTER DATABASE database_name SET SINGLE_USER
GO

DBCC CHECKDB('database_name', REPAIR_REBUILD)
GO

ALTER <database-name> SET MULTI_USER

这篇关于无法插入，更新数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！