Is it possible to access the stored procedures from the query manager?

[jbrotto]

I was wondering as I don't have direct access to the MS SQL server as my new employer does not know the sa login and password if I could use the query manager to access the data.

[hdolenec]

You can use this query in query generator to get procedure definition

SELECT CAST(T1.DEFINITION AS NTEXT) FROM SYS.SQL_MODULES AS T1 LEFT OUTER JOIN SYS.PROCEDURES AS T0 ON T1.object_id=T0.object_id WHERE T0.NAME = 'SBO_SP_TransactionNotification'

[kothandaraman_nagarajan]

Hi,

You can not simply call stored procedure directly using Query manager and some of the procedure need permission. Also without knowing stored procedure and required parameter, its difficult to get required result.

For example, if we know the the stored procedure name, then we can use command in query generator,

EXECUTE [Name of the stored Proceudre] @Fromdate,@Todate

Regards,

Nagarajan

[jbrotto]

It is to gain access to SBO_SP_TransactionNotification

[mgregur]

Hi,

you can use

SELECT * FROM "SYS"."PROCEDURES" WHERE "SCHEMA_NAME" = 'YourSchemaName'

BR,

Matija

[jbrotto]

So something like this ?

SELECT * FROM SYS.SP_TransactionNotification

[mgregur]

Hi,

no, run exactly as I wrote it (this is HANA syntax). There you will find a list of all procedures, with their definitions etc.

BR,

Matija