Click here to Skip to main content
15,882,388 members
Home / Discussions / Database
   

Database

 
QuestionMS Access functions to Oracle Pin
Mangilipelli26-Jun-07 2:20
Mangilipelli26-Jun-07 2:20 
AnswerRe: MS Access functions to Oracle Pin
leckey26-Jun-07 9:30
leckey26-Jun-07 9:30 
GeneralRe: MS Access functions to Oracle Pin
Mangilipelli26-Jun-07 22:54
Mangilipelli26-Jun-07 22:54 
GeneralRe: MS Access functions to Oracle Pin
Vasudevan Deepak Kumar27-Jun-07 2:52
Vasudevan Deepak Kumar27-Jun-07 2:52 
QuestionHow can i return the names of a stored procedures input parameters? Pin
Red_Wizard_Shot_The_Food25-Jun-07 23:52
Red_Wizard_Shot_The_Food25-Jun-07 23:52 
AnswerRe: How can i return the names of a stored procedures input parameters? Pin
Manas Bhardwaj26-Jun-07 0:10
professionalManas Bhardwaj26-Jun-07 0:10 
GeneralRe: How can i return the names of a stored procedures input parameters? Pin
originSH26-Jun-07 0:13
originSH26-Jun-07 0:13 
AnswerRe: How can i return the names of a stored procedures input parameters? [modified] Pin
originSH26-Jun-07 0:11
originSH26-Jun-07 0:11 
I assume your talking about sql server?

If it's 2005 you want to use the System Views:

http://www.microsoft.com/downloads/details.aspx?FamilyID=2ec9e842-40be-4321-9b56-92fd3860fb32&displaylang=en[^]


If it's 2000 you want the system tables:
http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx[^]

Unfortunatly I dont have a link handy on how to use them, but they are pretty straight forward and will provide all you need Smile | :)


Edit: just spotted this article. It looks old but relivent:

http://www.devx.com/vb2themax/Tip/18282[^]


-- modified at 6:16 Tuesday 26th June, 2007

Edit: I also forgot to tell you about DMO and SMO Wink | ;)

SMO (Sql Management Objects) in 2005, is a set of objects you can use in .Net that retrive a lot of information about Sql Server and allows you to perform admin operations. They definatly allow you to list the stored procs and all the details about them. A little warning when used with a complex database the SMO's can require a fair bit of tweaking to perform well but it's well worth it if you need that much control.

DMO is similar and used in 2000. I've never personally used DMO so you'dh ave to look into what it can achive.
GeneralRe: How can i return the names of a stored procedures input parameters? Pin
Gamzun26-Jun-07 0:25
Gamzun26-Jun-07 0:25 
GeneralRe: How can i return the names of a stored procedures input parameters? Pin
originSH26-Jun-07 0:28
originSH26-Jun-07 0:28 
GeneralRe: How can i return the names of a stored procedures input parameters? Pin
Gamzun26-Jun-07 0:32
Gamzun26-Jun-07 0:32 
GeneralRe: How can i return the names of a stored procedures input parameters? [modified] Pin
originSH26-Jun-07 1:22
originSH26-Jun-07 1:22 
GeneralRe: How can i return the names of a stored procedures input parameters? Pin
Gamzun26-Jun-07 1:50
Gamzun26-Jun-07 1:50 
AnswerRe: How can i return the names of a stored procedures input parameters? Pin
llamadillo27-Jun-07 15:54
llamadillo27-Jun-07 15:54 
GeneralRe: How can i return the names of a stored procedures input parameters? Pin
Red_Wizard_Shot_The_Food27-Jun-07 22:48
Red_Wizard_Shot_The_Food27-Jun-07 22:48 
GeneralRe: How can i return the names of a stored procedures input parameters? Pin
adambl5-Jul-07 9:45
professionaladambl5-Jul-07 9:45 
QuestionInstall SQL Server 2005 with 2000 already installed Pin
Kiefie25-Jun-07 23:25
Kiefie25-Jun-07 23:25 
AnswerRe: Install SQL Server 2005 with 2000 already installed Pin
originSH25-Jun-07 23:30
originSH25-Jun-07 23:30 
GeneralRe: Install SQL Server 2005 with 2000 already installed Pin
Kiefie26-Jun-07 1:40
Kiefie26-Jun-07 1:40 
GeneralRe: Install SQL Server 2005 with 2000 already installed Pin
originSH26-Jun-07 2:02
originSH26-Jun-07 2:02 
GeneralRe: Install SQL Server 2005 with 2000 already installed Pin
Kiefie26-Jun-07 2:11
Kiefie26-Jun-07 2:11 
GeneralRe: Install SQL Server 2005 with 2000 already installed Pin
originSH26-Jun-07 2:19
originSH26-Jun-07 2:19 
GeneralRe: Install SQL Server 2005 with 2000 already installed Pin
Kiefie26-Jun-07 23:01
Kiefie26-Jun-07 23:01 
Generalescaping Pin
V.25-Jun-07 22:06
professionalV.25-Jun-07 22:06 
GeneralRe: escaping Pin
Giorgi Dalakishvili25-Jun-07 22:12
mentorGiorgi Dalakishvili25-Jun-07 22:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.