ok. where I work not all people know how to write tsql code and if they mess up the tsql they do not know how to fix it is why using theymuse the proc GUI. I just though there might be away of getting the GUI to reopen after running it without having to right click on the proc
for end users, you create an application, or a web page, or some custom front end that runs the procedure on their behalf.
the GUI needs to provide them with the limited input that is appropriate for their needs...drop down menus for values, for example.
that application needs to validate data entered, and be ready to report results as well as report any errors that occurred to the end user.
there's always work involved when releasing a functionality to end users.
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!