用友U872 帐套删除工具

陈国辉

把accid改成要删除的帐套号，把accyear改成要删除帐套的年度

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 [email=]'+@dataname+'[/email] SET  SINGLE_USER WITH ROLLBACK IMMEDIATE';
exec(@sql);
set @sql = 'ALTER DATABASE [email=]'+@dataname+'[/email] SET  SINGLE_USER ';
exec(@sql);
set @sql = 'DROP DATABASE [email=]'+@dataname[/email];
exec(@sql);
EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = @metaname;
set @sql = 'ALTER DATABASE [email=]'+@metaname+'[/email] SET  SINGLE_USER WITH ROLLBACK IMMEDIATE';
exec(@sql);
set @sql = 'ALTER DATABASE [email=]'+@metaname+'[/email] SET  SINGLE_USER ';
exec(@sql);
set @sql = 'DROP DATABASE [email=]'+@metaname[/email];
exec(@sql);

mmf2008

终于找到了，感谢分享。

sagince

谢谢楼主了