I am trying to run a Store Proc in the SQL Query options. It does not seem to be working.  Anything in particuarl that needs to happen?  Wondering what Security setting that are used to call this.   

This is what I am trying to run.

exec dbo.NCSL_SyncUserRolesBetweenPortals 1,1, $(userID)

 

 

Thanks Chris

It ended up being a SQL user Permission Error.  I just did not see the error.