How to specify object ownership...

M

Marcus

How is it possible to specify the owner when a S.P. is created or when a
table is created within a S.P. ?
 
S

Sylvain Lafontaine

All you have to do is to add the name of the owner (schema) at the beginning
when creating the SP/View/Table/UDF; for example with dbo:

CRATE PROCEDURE dbo.MyProcedure AS ....

Of, this requires a sufficient level of permission.
 
Top