Anytime, got to keep those DMO guys in their place.

Steve Jones

steve@dkranch.net

You are strictly paying for the name, not the product. Often is the same product, but the vendor is standing by it. For corporate IT who buy single source, this...

I did it with a table, just a simple create table Newtest( Myid int)

and then checked information_schema.tables as well as EM. Both show the owner as dbo.

Steve Jones

steve@dkranch.net

Haven't seen any issues with SP2 yet. Only on a test machine.

Steve Jones

steve@dkranch.net

Thanks Brian. MS isn't listing anything.

Steve Jones

steve@dkranch.net

ntuser. didn't test sqluser.

Steve Jones

steve@dkranch.net

I don't see any way around either recreating or altering the application.

Steve Jones

steve@dkranch.net

I logged in as my user and it worked. Check the altuid column as well. I have a 1 here for my aliased user.

Steve Jones

steve@dkranch.net

I'd say DTS, script a Transform Data Task for each table.

BCP might work, but not sure how hard this is to setup the export from Oracle.

Steve Jones

steve@dkranch.net

what about isalias?

Which UID does the user have?

Does this user have a role? a sid?I added a domain user and ran sp_addalias and it seemed to work. Will log off...

It looks like you have two conflicting proceses. Can you explain what tasks are in the package and in what order they work?

Steve Jones

steve@dkranch.net

DMO Sucks!!!!!!!!!!!!1

Actually, I do agree with Andy somewhat. The best tool is the one to use. I do use EM in certain places that I can never remember the syntax....

select * from information_schema.columns

Steve Jones

steve@dkranch.net

Can you check sysusers and see what the entry is for this user?

Steve Jones

steve@dkranch.net

Thanks for the post and this is more clear.

It looks like you will want to build dyamic sql, where your stored procedure looks something like:

Set the variables:

@Key

@Variable

@Value

@DataType of Variable

@TargeTable

select @cmd...