Is it possible to use a progress bar in C# to track a running SQL stored procedure?

USE [myDB]
GO
 
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 
CREATE PROCEDURE [dbo].[sbs_ClearAllData]
 
AS
BEGIN
 
	SET NOCOUNT ON;	
 
	-- Clear out tables
	EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
	EXEC sp_MSForEachTable  
	'IF OBJECTPROPERTY(object_id("?"), "TableHasForeignRef") = 1  
		DELETE FROM ?  
	else   
		TRUNCATE TABLE ?'
	EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
	EXEC sp_MSForEachTable  
	'IF OBJECTPROPERTY(object_id("?"), "TableHasIdentity") = 1   
	DBCC CHECKIDENT ("?", RESEED, 0)'
 
	-- Populate a couple of the tables.
	INSERT INTO myTable1
		(Id, Code, Description, IsCredit)
	VALUES
		(NEWID(), 'D', 'Debit', 0)
	INSERT INTO myTable2
		(Id, Code, Description, IsCredit)
	VALUES
		(NEWID(), 'C', 'Credit', 1)
 
END

Select allOpen in new window