SSMS access and code formatting

  • Thank you Mark.

    My 2 last quick questions:

    1-if I build a SQL process and I needed a user to run the code (process) on demand not Thru a SQL job. Is there a good/easy way to do that without building an invasive web interface and purchase another VS license?

    2- I don't see a good way to organize the SQL code in SSMS in Separate folders (like HR Code, Finance Code, Etc..). I can certainly prefix the solution/project names with Hr_ or Fin_ to differentiate but organizing the code in folders/sub folders seems missing.

    Thanks a lot everyone..

  • 1 SSMS is free. They can download that. Set up the appropriate privileges so that they have db_datareader with execute of stored procedure as an addition.

    2 This should go hand in hand with your search for a version control system

  • oneteabag wrote:

    2- I don't see a good way to organize the SQL code in SSMS in Separate folders (like HR Code, Finance Code, Etc..). I can certainly prefix the solution/project names with Hr_ or Fin_ to differentiate but organizing the code in folders/sub folders seems missing.

    Thanks a lot everyone..

    (Many, but not all, people work as follows...)

    Your database code should be developed within one or more 'database projects', using SSDT (which is a cut-down version of Visual Studio). The code in these projects should be checked in to a VCS.

    A tool like Octopus Deploy or TeamCity can be used to automate the deployment of checked-in code from your VCS to one or more target databases.

    This is a big topic and if it's all new, you have some reading and investigations ahead of you.

    Database projects allow you to organise your database objects in folders.


  • In the past, we've found a lot of problems with automated deployments that can be described by one, single, four letter word...

    "Oops". 😀

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Make Sense Jeff.

    Now I have to go and play with SSDT..Thanks Phil for the info.

Viewing 5 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply