By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,391 Members | 2,189 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,391 IT Pros & Developers. It's quick & easy.

Can table ownership be changed during upsize to SQL

P: n/a
When I create tables in SQL I can specify dbo as the owner using the
syntax below. Can ownship be changed when using the upsize wizard in
Access 2000 so that everything being upsized will be owned by DBO?

CREATE TABLE dbo.mytable (c1 int not null)
Thank You,
Randy K
wa****@hotmail.com
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Randy" <wa****@hotmail.com> wrote in message
news:8a**************************@posting.google.c om...
When I create tables in SQL I can specify dbo as the owner using the
syntax below. Can ownship be changed when using the upsize wizard in
Access 2000 so that everything being upsized will be owned by DBO?

CREATE TABLE dbo.mytable (c1 int not null)


I've never used the upsizing wizard but i imagine it runs under the security
account of the login you supply to establish the connection - so just use
the sa login which is always mapped to dbo
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.