Few queries regarding use of sybase store procedures

[former_member213644]

Currently we are using below method to create database user:

Use dbName;

Exec sp_adduser ?, ? ,?

I have found below store procedure execution method :

Exec databaseName.sys.procedureName ? ? ?

I do have following questions

1.what is the difference between this two methods regarding to resource allocation and performance?

[former_member89972]

ASE engine looks for procedures in certain order.

All procedure names are searched in the current database first.

If procedure name begins with sp_ and the procedure does not exist in local database,

- it is searched in sybsystemprocs database and if not found there

- then it is searched in master database.

When you specify database.owner.procedure_name you giving the absolute path with no ambiguity.

If the procedure exists it is executed.

There is no implicit search done in sybsystemprocs and master databases.

HTH

Avinash

[bob_gallo58]

Well sorry to say you posted this under the Sybase Mainframe Tag.
I will try to get an ASE expert to take a look.
The correct tags would be:
Sybase Adaptive Server Enterprise
Sybase Adaptive Server Enterprise Cluster Edition

The ASE experts monitor those tags.