Post reply

execute a storedprocedure where ever he wants to execute in any database it it possible?

  • October 5, 2012 at 3:32 am

    #263642

    Hi all

    one of my application user asking to give access to execute a storedprocedure where ever he wants to execute in any database it it possible? if so how

    and he is sasying that a stored procedure called sp_start is it avalilable in sql server ?

    Thanks
    Naga.Rohitkumar

  • October 5, 2012 at 3:50 am

    #1545972

    naga.rohitkumar (10/5/2012)

    Hi all

    one of my application user asking to give access to execute a storedprocedure where ever he wants to execute in any database it it possible? if so how

    You should ask what the user really wants to do (what does the stored procedure do?) and decide from there how to implement.

    and he is sasying that a stored procedure called sp_start is it avalilable in sql server ?

    No - possibly Oracle? It could be a user stored procedure.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • October 5, 2012 at 4:09 am

    #1545975

    thanks for reply

    actually the applications user want to take the data directly from the database instead from application

    to which he want to create a stored procedure sp_start_job [and its name ]

    it will create and fetch the data as alert to mobile sms or a batch file

    for which he wants permissions if required to his login if not

    want to create a storedprocedure which can take the information required from all databases

    Thanks
    Naga.Rohitkumar

  • October 5, 2012 at 4:42 am

    #1545983

    naga.rohitkumar (10/5/2012)

    thanks for reply

    actually the applications user want to take the data directly from the database instead from application

    to which he want to create a stored procedure sp_start_job [and its name ]

    it will create and fetch the data as alert to mobile sms or a batch file

    for which he wants permissions if required to his login if not

    want to create a storedprocedure which can take the information required from all databases

    sp_start_job is part of the Agent Jobs suite of objects. SSC has an excellent article covering this: Stairway to SQL Server Agent[/url]

    This is a modest project for a SQL Server DBA or developer - why don't you pass it on to them?

    * Gather requirements for the report

    * Write a stored procedure containing the statements to retrieve the data and output to the appropriate destination

    * Set up a job to run the stored procedure

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Viewing 4 posts - 1 through 3 (of 3 total)

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