Re: exporting into a SQL Server schema

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

It's not a bug, that's the way SQL Server security works -- objects
created by sysadmin are owned by dbo. The fully-qualified name of all
objects goes like this: databaseName.schema.object. Access already
knows the database name from the connection string, so all you need to
specify is schema.object.

The best solution to the problem would be to have someone who is in
the dbo/sysadmin role create the table. Then all you need is
permission to insert data. If this is something that you do
repeatedly, then create an extra column in the SQL Server table that
indicates the datetime the data was inserted.

--Mary

On Fri, 15 May 2009 14:04:44 -0700 (PDT), myotheraccount
<levtoma@xxxxxxxxx> wrote:

I'm not sure if this belongs here or in MSSQL Server - probably both.
I'm trying to export a table from Access into SQL Server. The issue
is that I want to export it into the dbo schema. Since I log into SQL
Server using windows authentication through my AD group and I my group
does not have sysadmin privelages, the schema is defaulted to my
username (It is unclear if this is a bug in SQL Server, but it sure
seems that way to me.)
Is there any way I can specify the schema name when exporting? If I
enter dbo.Table1 as my table name to export to, I get an error
message: "The object name 'dbo.Table1' you entereed doesn't follow
Microsoft Office Access object-name rules."
Any ideas?
Thanks
.

Relevant Pages

  • Re: I have now probably done a very silly thing
    ... I already knew what I was searching for which is 99% of the problem. ... the document that you passed in the mail and now I have granted the the relevant user back to the sysadmin server role. ... The 'best practice' is that SQL Server runs under domain account and not as Local Admin, but I am seeing lot of business that do the oppoiste:-) ...
    (microsoft.public.sqlserver.programming)
  • Re: permissions required for executing CDOSys stored procedures
    ... he is by default member of the sysadmin server ... role on the SQL Server database unless steps are taken to prevent that. ... sysadmin and who has not been granted specific execute permissions on the ... it is possible to GRANT EXECUTE ON sp_OACreate TO ...
    (microsoft.public.sqlserver.security)
  • Re: Sharepoint index problems in SQL Server.
    ... The Administrator account is a sysadmin and have all the access to all the ... > database is master and language US_English? ... >> I've set back the account localsystem for both SQL Server and Microsoft ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Move or Setup of SQL Database toa Remote Server Fails
    ... as well as have SysAdmin privileges on the DB. ... Registered type 501ST MASTER for 501ST SCCM1DB\master ... Could not connect SQL Server 'master' db. ... The SCCM Primary Site Computer Account and the User account I am using ...
    (microsoft.public.sms.setup)
  • Re: cannot acees two databases as owner
    ... member of the built-in group Administrators, is not sysadmin. ... Administrator of SQL Server. ...
    (microsoft.public.sqlserver.setup)