May 26, 2010 at 9:36 am
Hi,
I have a application that executes scripts (.SQL).
The user tells to the app the path where the script is and the app opens the script and saves the script to a variable, and then , this app as a stored procedure to where the variable value (the script text) is passed.
This works very well, but i have a problem....
When i have script that have inside stored procedures like :
EXEC sp_dbcmptlevel @dbname, 90
The app returns an error, because the sp_dbcmptlevel can only be executed in ad hoc context....
I do not what to send my SQL statments without being to a stored procedure, but not everything can be executed from inside a stored procedure....
Can you please help on what to do?
Thank you.
May 26, 2010 at 10:05 am
I think you'd have to execute some of these steps separately. These commands aren't usually meant to be run in a proc, or often, as they make a substantial change to the way the db works. You typically set this once and leave it alone.
And you should use ALTER DATABASE instead.
May 26, 2010 at 10:12 am
yes, but this is an app that as to execute any text that is inside .SQL script.
That's the problem....
May 26, 2010 at 10:15 am
it's like:
if you can run it (.sql script) from query window in MS, then, this app as to execute it too.
I don't know if the best thing to do is pass the script text into a stored procedure, because there will be some commands that can not be inside a stored procedure...
May 26, 2010 at 10:33 am
You can parse out things possibly that can't run. There aren't a lot of commands. I would question the need for this particular command.
May 26, 2010 at 10:37 am
there is no need for this particular command , but the client (to who i'm making this app) needs that the app runs every thing that can be run from inside query window...
Because programmers will use this app to run scripts agains databases...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply