Re: Unable to retrive parameters for stored procedure

From: SriSamp (ssampath@sct.co.in)
Date: 03/20/03 

From: "SriSamp" <ssampath@sct.co.in>
Date: Thu, 20 Mar 2003 11:34:49 +0530

What happens if you say "sp_help <procedure name>". If this does not give
you the list of parameters that the procedure takes, then maybe your scripts
might be having a problem. You can also see what query the SQL Analyzer is
sending to retrieve the parameters by using the profiler application. In all
liklihood, it will be something like "exec database..sp_sproc_columns
N'CMB_AccountsGet', N'dbo', N'Database', NULL, @ODBCVer = 3". You can take
this command from this post and replace database with your db name and see
what happens.

SriSamp

"Adam Pawsey" <a_pawsey@hNoOtSmPaAiMl.com> wrote in message
news:q8Gda.1687$6f1.134888@stones.force9.net...
> Please help anyone!
>
> Got a database I've been using to develop a web application and it's got a
> bit messy as it's grown.
> Now I'm transplanting all the useful tables, stored procs, etc to a new
> database to be the finished version.
>
> I recreate the tables,etc. by generateing scripts and then runing them on
> the new db.
>
> If I go to SQL Query Analyzer and find a stored procedure in the new db
and
> then right-click and select open, it used to give me a dialog listing the
> parameters and then I could fill them out. Now none of the parameters are
> listed. It appears for some reason it cannot retrieve the list of
> parameters.
>
> I am logged into the query analyzer as my computer administrator so there
> should be now probs and fll access.
>
> Don't quite understand it!!
>
> Anyone got an idea?
>
> Thanks
>
>
> --
> To email me, remove the capital letters from my address (Guess what, it
> spells NOSPAM!)
>
>

Relevant Pages
Quantcast