I would like to change the default schema details of all the logins createdCould yoy please specify how do i find out the schema detailsand also i would like to change all the objects default schema to DBO

I would like to change the default schema details of all the logins createdCould yoy please specify how do i find out the schema detailsand also i would like to change all the objects default schema to DBO

shine.mm (4/2/2008)Hi,What i would need is i would like to know each databases,Which are the Objects(Tables,Stored Procedures Etc.)not belong to the schema DBO.Fist i need to know which are the objects not belong to DBO

Then i would like to change the schema of this objects to DBO

Please help me Smm

This query will give you objects in a single database that do not belong to dbo. I've also constructed the command you'd need to run to transfer the object to a different schema.

We would like to create a report out of it and let a procedure run in every instance on a daily basis. The procedures should write the information into seperate tables in theOne of DB(Like ABC)databaseI need to have the Sp in one Database and it needs to check all the Database and fetch the details into separate tables as per the database name