StackOverflowDocumentation
.dbo
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
usp_runUserQueries
Parameters
Name
Type
Mode
Definition
CREATE PROCEDURE [dbo].[usp_runUserQueries] WITH RECOMPILE AS SET NOCOUNT ON -- this procedure runs all queries which depend on a userid DECLARE @Id INTEGER = 212952; -- this is our colleague who creates all the posts in the workload EXEC dbo.usp_Q3160 @Id; EXEC dbo.usp_Q6772 @Id; EXEC dbo.usp_Q7521 @Id; EXEC dbo.usp_Q8116 @Id; EXEC dbo.usp_Q947 @Id; EXEC dbo.usp_Q949 @Id;