Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IF NOT EXISTS (SELECT * FROM [dbo].[Backup.Model.Storages] WHERE [object_id] = @object_id AND [backup_id] = @backup_id)
- BEGIN
- SELECT KEYS.[id] INTO #ArchiveKeys
- FROM [dbo].[CryptoKeys] AS KEYS
- JOIN [dbo].[CryptoKeys.ArchiveRecs] AS archiveRecs ON archiveRecs.[archive_key_id] = KEYS.[id]
- WHERE KEYS.[backup_id] = @backup_id AND archiveRecs.[object_id] = @object_id
- DECLARE @archiveKeyId UNIQUEIDENTIFIER
- DECLARE archiveKeyCur CURSOR FOR SELECT id FROM #ArchiveKeys
- OPEN archiveKeyCur
- FETCH NEXT FROM archiveKeyCur INTO @archiveKeyId
- WHILE @@FETCH_STATUS = 0
- BEGIN
- EXEC [DeleteCryptoKey] @archiveKeyId, @usn;
- FETCH NEXT FROM archiveKeyCur INTO @archiveKeyId
- END
- CLOSE archiveKeyCur
- DEALLOCATE archiveKeyCur
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement