该用户从未签到
|
U872帐套删除脚本
用查询分析器打开帐套删除脚本后将帐套号和帐套年度改掉就可以了
内容如下:
declare @accid varchar(200);
set @accid = '968';
declare @accyear varchar(200);
set @accyear = '2009';
use master;
declare @dataname varchar(200);
set @dataname = 'UFDATA_' + @accid + '_' + @accyear;
declare @metaname varchar(200);
set @metaname = 'UFMETA_' + @accid;
declare @sql varchar(2000);
EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = @dataname;
set @sql = 'ALTER DATABASE '+@dataname+' SET SINGLE_USER WITH ROLLBACK IMMEDIATE';
exec(@sql);
set @sql = 'ALTER DATABASE '+@dataname+' SET SINGLE_USER ';
exec(@sql);
set @sql = 'DROP DATABASE '+@dataname;
exec(@sql);
EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = @metaname;
set @sql = 'ALTER DATABASE '+@metaname+' SET SINGLE_USER WITH ROLLBACK IMMEDIATE';
exec(@sql);
set @sql = 'ALTER DATABASE '+@metaname+' SET SINGLE_USER ';
exec(@sql);
set @sql = 'DROP DATABASE '+@metaname;
exec(@sql); |
|