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

Question

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

naga.rohitkumar

SSCertifiable

Points: 5738
More actions
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

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

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

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 1

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

naga.rohitkumar SSCertifiable Points: 5738 More actions · Answer 2

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

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 3

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