Ask a Question related to Coldfusion Database Access, Design and Development.
-
Buda123 #1
execute stored procedure
Does anybody know how I can execute one of the system stored procedures from
master database.
for example this is throwing error:
<cfquery datasource="users">
EXEC [master.dbo.sp_fulltext_catalog 'clients', 'rebuild']
</cfquery>
Thanks
Buda123 Guest
-
Execute permission denied on 'stored procedure' dbo
How to solve the problem from the above topic. I can execute the stored procedure through the web service. I am using Integrated Security connection... -
Problem with execute to make a stored procedure
I have to maintain a piece of code. One of the things that is done is a create procedure: CREATE PROCEDURE PROC_22_ RETURNS(IEXTENSION... -
UNIX-Box slow down while execute stored procedure
Hi, Sorry for my "special english". We are on a DGUX-Box with IDS 7.31 ( 4 P3/700 / 2 GB Mem ) We have a problem with a stored procedure... -
Cannot execute dynamic query in stored procedure
Hi, I'm using ADO.NET to execute a stored proc. The stored proc contains a dynamic sql which will build the INSERT or UPDATE statement for... -
How can I execute a stored procedure in .net?
Hello all, Is there anyone who can tell me how to execute a stored procedure in .net. More detailed, I want to pass some parameters to the... -
paross1 #2
Re: execute stored procedure
You could use CFSTOREDPROC instead of CFQUERY.....
Your problem in this case is probably due to the way that you are attempting
to pass your parameters. Enclose your parameters in parens.
<cfquery datasource="users">
EXEC master.dbo.sp_fulltext_catalog('clients', 'rebuild')
</cfquery>
Phil
paross1 Guest



Reply With Quote

