I come from an Oracle background and now work in a SQL Server environment. Unfortunately, we haven't used SQL Server to its potential here and I am charged with helping to get our group there.

There have been some growing pains. For example, one of my recent frustrations has been with learning that transact-SQL doesn't allow for cursor parameters. Uggh!

Well, this question is more SQL server related, rather than t-sql related.

Does anyone know how to create PUBLIC SYNONYMS in SQL Server? I doubt the concept of a SYNONYM even exists in SQL Server, but geez we used them all the time in Oracle. I have two stored procs in SQL Server that I want to make available to all our developers. Do I have to define both SPs in *every* database we have (we have several) or can I just place them in the master db?

My goal is to have every developer that is logged into a server, be able to call my stored proc by simply typing in the proc name (e.g. sp_myproc) rather than having to type database.owner.sp_myproc. I have noticed that many system SPs can be called as such.

Any help would be appreciated.

p.s. - with all due respect to SQL Server experts, I have found it more difficult to get SQL Server users to understand Oracle concepts so I'm starting by posting my question (with reference to synonyms) in this group first. thx