tangdh
PB and .net 乐园

导航

 

//财务从一套帐到另一套帐
use master
go
select * from syslogins
use cwbase14
go
select * from sysusers
//
use master
go
sp_configure "allow updates",1
go
reconfigure with override
go
use cwbase14
go
update sysusers set suid = 129,name = 'lc0149999'  where suid = 57
go
sp_configuer "allow updates",0
go
reconfigure with override
go


//设置数据库状态
sp_dboption  cwbase1 , "select into/bulkcopy", true
go

posted on 2008-06-24 16:37  tangdh  阅读(549)  评论(0)    收藏  举报