shine.mm (4/1/2008)
HI All,I would like to change the default schema details of all the logins created
Could yoy please specify how do i find out the schema details
and also i would like to change all the objects default schema to DBO
Regards'
Smm
What schema details do you want to know exactly?
To change the default schema:
ALTER USER Mary51 WITH DEFAULT_SCHEMA = dbo
To change objects to the default schema use:
ALTER SCHEMA dbo TRANSFER fully_qualified_object_name
Hope that helps.