Change schema owner

From: "jonte@xxxxxxx" <jonasberthelsson@xxxxxxxxxxx>
Date: Thu, 10 Apr 2008 09:07:13 +0200

I have a database with a user who owns schemas, so I can't drop the user and
I am not allowed to drop the associated login because it's used in another
database.
First I want to list all schemas for that user which he own but I havn't
found how because when you are to change schema owner you must name the
schema !?
I have changed DBO to another user.

I have read a little about it but I'm still confused.

Could you help me out ?

Sincerely

\\Jonas B

.

Follow-Ups:
- Re: Change schema owner
  - From: jonte@xxxxxxx

Prev by Date: Re: Cannot Generate SSPI context, Running Jobs in SQL Server 2005
Next by Date: Re: Change schema owner
Previous by thread: Cannot Generate SSPI context, Running Jobs in SQL Server 2005
Next by thread: Re: Change schema owner
Index(es):
- Date
- Thread

Relevant Pages

Re: UDM and Star Schema
... and more complicated schemas. ... you create a cube. ... SSAS 2005 is able to create the tables for you, ... proactive caching can detect changes in the source database and then update ...
(microsoft.public.sqlserver.datawarehouse)
Re: Mumps: the IT worlds best kept secret?
... No matter if that is enforced by the database software or by convention in ... Generally they do not use SQL as its not an appropriate or ... The reasons for Mumps databases to exist, are exactly what you pointed out ... Intuitively you would expect RDBMSs with strong and rich schemas would ...
(comp.lang.mumps)
Abnormally large merge replication tables
... free space is around 10 mb for each database. ... I am running SQL Server 2000 w/SP3a on my publisher/distribution server. ... The MSDE machines move in and out of replication (they are on ... windiff between the schemas created by Enterprise Manager. ...
(microsoft.public.sqlserver.replication)
Re: Join DataTables in same dataset
... still have to get the dataset to update back to the database. ... have different schemas. ... a separate OleDbconnection to each source, ... DataColumn parentColumn = ...
(microsoft.public.dotnet.languages.csharp)
Re: UDM and Star Schema
... SSAS 2005 like any other OLAP tool on the market can works with flat schemas and more complicated schemas. ... SSAS 2005 is able to create the tables for you, so instead of creating the tables in the database then creating the cube, you create your dimensions and cubes first and SSAS2005 will generates the tables for you. ...
(microsoft.public.sqlserver.datawarehouse)