How to specify object ownership...

[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. ?

 

[Marcus]

I think I've got it: you need to login with Windows integrated security?

 

[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.

 

[ling]

xdfsdfsdfgsdf