房地产会计网

标题: 用友U872 帐套删除工具 [打印本页]

作者: 陈国辉 时间: 2009-5-22 16:15
标题: 用友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 时间: 2010-8-19 14:20
终于找到了，感谢分享。

作者: sagince 时间: 2013-1-1 14:31
谢谢楼主了

欢迎光临房地产会计网 (https://www.fdckj.com/)