系统在服务器打印口没有找到软件狗,T3普及版10.8，问题是突然不能登录了，SQL数据库是正常的，是否需要打上最新的补丁？还有没有其他方法解决？登录系统管理的时候，点注册，提示没有找到加密狗和注册信息...

原因分析:if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[a_vw_AllBarcode]') and OBJECTPROPERTY(id, N'IsView') = 1)

drop view [dbo].[a_vw_AllBarcode]

GO

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS ON

GO

CREATE View dbo.a_vw_AllBarcode

as

Select s_ID,barcode From Product where barcode is not null

Union

select Prod_Id,barcode From Productbarcode

GO

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS ON

GO

declare tb cursor for

--刷新视图处理的语句

select 'exec sp_refreshview ''['+replace(user_name(uid), N']',N']]')+'].['

+replace(object_name(id),N']',N']]')+']'''

from dbo.sysobjects

where xtype='v' and status>=0

union all--刷新存储过程,自定义函数,触发器的语句

select 'exec sp_recompile ''[' + replace(user_name(uid), N']', N']]')+'].['

+ replace(object_name(id), N']', N']]')+ ']'''

from dbo.sysobjects

where xtype in('tr','fn','if','tf','p') and status>=0

declare @s nvarchar(4000)

open tb

fetch tb into @s

while @@fetch_status=0

begin

exec(@s)

fetch tb into @s

end

close tb

deallocate tb