? ? ? ? ? ? ? ? ? ? @ ? ? ?@ ? ?@ ? @ ?@ ? ? ? @ 0 < " ?%I=%I=
A `A A @ h 6 c 3 P 0 ? ? 3 d b _ a c c e s s a d m i n 0 ? ? 9 d b _ b a c k u p o p e r a t o r 0 ? ? 1 d b _ d a t a r e a d e r 0 ? ? 1 d b _ d a t a w r i t e r 0 ? ? - d b _ d d l a d m i n 0 ? ? 9 d b _ d e n y d a t a r e a d e r 0 ? ? 9 d b _ d e n y d a t a w r i t e r 0 ? ? ' d b _ o w n e r 0 ? ? 7 d b _ s e c u r i t y a d m i n 0 ? ? d b o 0 ? ? ? ; I N F O R M A T I O N _ S C H E M A 0 ? ? # p u b l i c 0 ? ? s y s
( ( > d b _ a c c e s s a d m i n d a t a r e a d e r w r i t e r e n y d a t a r e a d e r o w n e r g u e s t p u b l i c s y s @ @ % + + 0 5 ; 0 < " 0 < " 0 < " 0 < " 0 < " 0 < " 0 < " 0 < " 0 < " 0 < " 0 < " 0 < " 0 < $ Z ? ? @ ? $ @ ? 0 < " 0 < $ Z ? ? @ ? 8 @ $ ? ? ? ? 0 < " 5( ?%I=%I=
A `A A @ h 6 c 3 P 0 ? ? 3 d b _ a c c e s s a d m i n 0 ? ? 9 d b _ b a c k u p o p e r a t o r 0 ? ? 1 d b _ d a t a r e a d e r 0 ? ? 1 d b _ d a t a w r i t e r 0 ? ? - d b _ d d l a d m i n 0 ? ? 9 d b _ d e n y d a t a r e a d e r 0 ? ? 9 d b _ d e n y d a t a w r i t e r 0 ? ? ' d b _ o w n e r 0 ? ? 7 d b _ s e c u r i t y a d m i n 0 ? ? d b o 0 ? ? ? ; I N F O R M A T I O N _ S C H E M A 0 ? ? # p u b l i c 0 ? ? s y s
( ( > d b _ a c c e s s a d m i n d a t a r e a d e r w r i t e r e n y d a t a r e a d e r o w n e r g u e s t p u b l i c s y s @ @ % + + 0 5 ; ` p> N,
` a < q ^ u < F 8
CREATE PROCEDURE [dbo].[DeleteObject]
@Path nvarchar (425),
@Prefix nvarchar (850),
@EditSessionID varchar(32) = NULL,
@OwnerSid as varbinary(85) = NULL,
@OwnerName as nvarchar(260) = NULL,
@AuthType int
AS
SET NOCOUNT OFF
IF(@EditSessionID is null)
BEGIN
-- Remove reference for intermediate formats
UPDATE SnapshotData
SET PermanentRefcount = PermanentRefcount - 1,
-- to fix VSTS 384486 keep shared dataset compiled definition for 14 days
ExpirationDate = case when R.Type = 8 then DATEADD(d, 14, GETDATE()) ELSE ExpirationDate END,
TransientRefcount = TransientRefcount + case when R.Type = 8 then 1 ELSE 0 END
FROM
Catalog AS R WITH (XLOCK)
INNER JOIN [SnapshotData] AS SD ON R.Intermediate = SD.SnapshotDataID
WHERE
(R.Path = @Path OR R.Path LIKE @Prefix ESCAPE '*')
-- Remove reference for execution snapshots
UPDATE SnapshotData
SET PermanentRefcount = PermanentRefcount - 1
FROM
Catalog AS R WITH (XLOCK)
INNER JOIN [SnapshotData] AS SD ON R.SnapshotDataID = SD.SnapshotDataID
WHERE
(R.Path = @Path OR R.Path LIKE @Prefix ESCAPE '*')
-- Remove history for deleted reports and linked report
DELETE History
FROM
[Catalog] AS R
INNER JOIN [History] AS S ON R.ItemID = S.ReportID
WHERE
(R.Path = @Path OR R.Path LIKE @Prefix ESCAPE '*')
-- Remove model drill reports
DELETE ModelDrill
FROM
[Catalog] AS C
INNER JOIN [ModelDrill] AS M ON C.ItemID = M.ReportID
WHERE
(C.Path = @Path OR C.Path LIKE @Prefix ESCAPE '*')
-- Adjust data sources
UPDATE [DataSource]
SET
[Flags] = [Flags] & 0x7FFFFFFD, -- broken link
[Link] = NULL
FROM
