Unable to retrive parameters for stored procedure

From: Adam Pawsey (a_pawsey@hNoOtSmPaAiMl.com)
Date: 03/18/03 

From: "Adam Pawsey" <a_pawsey@hNoOtSmPaAiMl.com>
Date: Tue, 18 Mar 2003 14:35:59 -0000

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

  • Dynamic SQL in Stored Proc
    ... I have a database setup so that NO users have READ, ... Dynamic SQL and they have stopped working. ... error message when executing one of the stored procs. ...
    (microsoft.public.sqlserver.security)
  • Re: Confused about proc vs. dynamic SQL vs LINQ
    ... where people create stored procs which *just* call normal CRUD ... for no reasons other than dogma. ... theoretical "change the database and the procs implementation, ... It depends on the database server, but I believe that using a cached ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Stupid Question - I think!
    ... I know that the table was not updated because I go to the Query Analyzer on ... update statement shown below does run in the Query Analyzer on the PDA ... (against the CE database) ... "Earl" wrote: ...
    (microsoft.public.sqlserver.ce)
  • Strange SQL Server CE 2.0 Problem
    ... Server CE database that is stored on a flash card inside the device. ... I can't use the SQL CE Query Analyzer -- the device ... selectCommand = new SqlCeCommand(sql, _connection, transaction); ...
    (microsoft.public.dotnet.framework.compactframework)
  • Question: How to pass ADS username from C# to trigger
    ... lot more auditing and the database seems like the place to do it. ... not want to modify all our stored procs to add username to it. ... We do have a centralized data access ...
    (microsoft.public.sqlserver.security)