From: "David Browne" <davidbaxterbrowne no potted meat@xxxxxxxxxxx>
Date: Thu, 10 Nov 2005 15:57:37 -0600
"baffled" <baffled@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:51D40DCD-7987-495A-A0AE-7F087F2197A4@xxxxxxxxxxxxxxxx > Is there an existing ADO.Net or Framework class or library for Sql Server
> that would allow me to get a list of stored procedures AND the arguments,
> default values, data types, etc...?
>
> I realize there are stored proces like sp_help &
> sp_procedure_params_rowset
> that can provide that info at the db level, but I was hoping to not have
> to
> reinvent the wheel.
>
> Thanks in advance!
Nothing built-in to get the list of procedures, but a simple query like
select * from information_schema.routines
will return you a list of all the procedures. Then for each one you can use
SqlCommandBuilder.DeriveParameters to attach the correct parameter set for
each procedure.
Extreme performance issues (SQL Server 2000/ADO.NET/C#) ... This process runs very quickly if run through Query... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ... (microsoft.public.dotnet.framework.adonet)
Re: Querying on dates in dd/mm/yyyy hh/mm/ss format using Access2002 And SQL Server 7 ... For parsing a string to a date/time, the 103 format doesn't limits the user ... > which is used as the row source for the results form). ... > other solutions assuming I have to use SQL Server 7? ... > I don't understand how I can use parameterized stored procedures to solve ... (microsoft.public.access.adp.sqlserver)
Re: Help understanding Stored proc Level Secuirty? ... Jasper Smith (SQL Server MVP)... I set permissions to my Stored Procedures,... Access to stored procs fail... (microsoft.public.sqlserver.security)
Re: Limiting views on data in a table ... returns the Windows login the user uses to connect to SQL Server.... > The way I was implementing this was to use Windows Auth with a Windows ... > covered by which salespeople,... > with it via the stored procedures.... (microsoft.public.sqlserver.security)
Re: Scripting T-SQL CREATE Statements ... a backup of user-defined SQL Server objects.... I am having a hard time finding the T-SQL functions and system stored procedures used to return the scripted ... like when you right-click an object and select Script Object to New Window as>> Create. ... I am trying to get it much like the instnwnd.sql file that comes with the .NET Framework SDK v1.1. ... (microsoft.public.sqlserver.programming)
