Storedprocedure Urgent Help!.......

Dear Thomas,

Thank you for the response. yes you are right . i want to restrict the SYSTEM type STOREDPROCEDURES . There are some SYSTEM storedprocedures which starts with dt_addtosourcecontrol

and some with sp_add_server_sortinfo.

In my method getProcedures() i wrote like this.

ResultSet rs = databaseMetaData.getProcedures (null,null, "%");

while(rs.next()) {

String dbProcedureCatalog = rs.getString(1);

String dbProcedureSchema = rs.getString(2);

System.out.println("dbProcedureSchmeais :"+dbProcedureSchema);

}

when i tried to print this dbProcedureSchema i got dbo and not SYSTEM. so how can i restrict it ? can you just help me out.It is very urgent.

Thanks and Regards

gopal

gopal73a at 2007-7-7 15:24:16 >

Dear All,

Thanks for the responses. i am still in a dilema as how to restrict the System storedprocedures.

i have checked for System table and found none.i have come to a observation that this System storedprocedures starts with either dt_ or sp_. so can i make a comparsion like if the storedprocedure Name startsWIth dt_ or sp_ return without doing anything else proceed further. is this the correct way or is there any other way. i am trying to call this storedprocedures from my java application. any help will be appreciated.

Also please kindly suggest me any help on Storedprocedures.

bye

gopal

gopal73a at 2007-7-7 15:24:16 >

Dear All,

Thanks for the responses. i am still in a dilema as how to restrict the System storedprocedures.

i have checked for System table and found none.i have come to a observation that this System storedprocedures starts with either dt_ or sp_. so can i make a comparsion like if the storedprocedure Name startsWIth dt_ or sp_ return without doing anything else proceed further. is this the correct way or is there any other way. i am trying to call this storedprocedures from my java application. any help will be appreciated.

Also please kindly suggest me any help on Storedprocedures.

bye

gopal

gopal73a at 2007-7-7 15:24:16 >

Dear All,

Thanks for the responses. i am still in a dilema as how to restrict the System storedprocedures.

i have checked for System table and found none.i have come to a observation that this System storedprocedures starts with either dt_ or sp_. so can i make a comparsion like if the storedprocedure Name startsWIth dt_ or sp_ return without doing anything else proceed further. is this the correct way or is there any other way. i am trying to call this storedprocedures from my java application. any help will be appreciated.

Also please kindly suggest me any help on Storedprocedures.

bye

gopal

gopal73a at 2007-7-7 15:24:16 >

> Dear Thomas,

> Thank you for the response. yes you

> esponse. yes you are right . i want to restrict the

> SYSTEM type STOREDPROCEDURES . There are some SYSTEM

> storedprocedures which starts with

> dt_addtosourcecontrol

> and some with sp_add_server_sortinfo.

>

>In my method getProcedures() i wrote like this.

>

> ResultSet rs = databaseMetaData.getProcedures

> ocedures (null,null, "%");

> while(rs.next()) {

> String dbProcedureCatalog = rs.getString(1);

> String dbProcedureSchema = rs.getString(2);

> System.out.println("dbProcedureSchmea

> ais :"+dbProcedureSchema);

>}

> when i tried to print this

> print this dbProcedureSchema i got dbo and not SYSTEM.

> so how can i restrict it ? can you just help me out.It

> is very urgent.

The schema in MS SQL Server is the table owner. In your case it's dbo. I don't think there is such thing as a SYSTEM owner in MS SQL Server.

Do I understand it correctly that with "restrict" you mean you want to hide these procedures when printing the list of procedures?

The only thing I can think of: you have to create the procedures using an account which does not have the DBA privilege. Thus the procedure will not be owned by dbo.

Or you could try to create the procedure explicitely for the user you are using:

CREATE PROCEDURE my-user.myProcedure

AS

...

Thomas

thomas.kellerera at 2007-7-7 15:24:16 >