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 |
|
jonathans
Starting Member
40 Posts |
 Posted - 2009-10-29 : 03:44:56
|
| Hey allI've got a view, with schemabinding enabled on it.Now, when i try create an index on the view it returns the following error.Msg 1938, Level 16, State 1, Line 1Index cannot be created on view 'tMain_Vector' because the underlying object 'Trade' has a different owner.The view sits in the 'dbo' schema, but the tables contained within the view are in two other schema's, namely 'data' and 'metadata'.Anyone know how I can resolve this? I've looked google broken, for the error message been returned, and found nothing.WARNING: Running on cold coffee! |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-10-29 : 04:11:16
|
| Hi jonathansam not sure just try...Can you create the same schema for view...or you change the table schema using sp_changeobjectowner-------------------------R... |
 |
|
|
jonathans
Starting Member
40 Posts |
Posted - 2009-10-29 : 04:20:33
|
| Unfortunately I can't change the schema.Essentially the system im writing has had its backend replaced from MS Access to MSSQL. And changing the owner/schema for the views are not an option.WARNING: Running on cold coffee! |
|
|
|
|
|
|
Can't create index on view