Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2008-12-12 : 08:36:06
|
| Hi,When im creating views and tables for my reports instead of the usual 'dbo.tablename' i get 'adminusers\username.tablename'Does this mean my access to sql server is limited? because when i use these tables and views for reports and deploy them onto production system I seem to be getting errors, but when I deploy reports not using the tables i created I dont seem to be getting errors.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-12 : 09:19:42
|
| this means your default schema is adminusers\username. you dont have db owner right. only if you're db owner, your default schema will be dbo. |
 |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-12 : 09:38:08
|
| As Visakh says your default schema is not dbo. Either you or dba need to alter your default schema.ALTER USER user21 WITH NAME = user144, DEFAULT_SCHEMA = dbo;To check if you have rights to dbo schema, try creating a table using script. E.g.CREATE TABLE [dbo].[TableA]( [ID] [nchar](10) NULL, [ModDate] [datetime] NULL, [textString] [nvarchar](max) NULL) ON [PRIMARY] |
|
|
|
|
|
|
creating views, tables on sql server