• edward_hall76 (11/13/2012)


    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

    That is extremely bad idea to give "people who doesn't know how to write t-sql code" access to SSMS. Are you going to install it on every user workstation?

    You should create some UI application which will execute stored proc. Users, don't even need to know how to do it via SSMS...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]