Description |
Here is the log:
Error SQL72014: .Net SqlClient Data Provider: Msg 208, Level 16, State 1, Line 1 Invalid object name 'tblTFTransaction'.
Error SQL72045: Script execution error. The executed script:
PRINT 'Create a temp recur procedure';
IF EXISTS (SELECT *
FROM sys.objects
WHERE type = 'P'
AND name = 'uspTempRecur')
BEGIN
EXECUTE ('DROP PROCEDURE uspTempRecur');
END
EXECUTE ('
CREATE PROCEDURE uspTempRecur
@ObjectName NVARCHAR(MAX)
AS
BEGIN
set nocount on
DECLARE @ObjectList TABLE(
name nvarchar(max)
)
DECLARE @CurrentObject NVARCHAR(MAX)
insert into @ObjectList
select distinct o.name as ObjName
from sys.sql_dependencies d
join sys.objects o on o.object_id=d.object_id
join sys.objects r on r.object_id=d.referenced_major_id
where d.class=1
AND r.name = @ObjectName
while exists(select top 1 1 from @ObjectList)
begin
select top 1 @CurrentObject = name from @ObjectList
if exists(select distinct o.name as ObjName
from sys.sql_dependencies d
join sys.objects o on o.object_id=d.object_id
join sys.objects r on r.object_id=d.referenced_major_id
where d.class=1
AND r.name = @C
|