Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL-Server
I ma trying to create the view in sqlserver.
Create view v_test
select * from Test
When I run ,its throwing the error like Msg 15135, Level 16, State 8, Procedure sp_addextendedproperty, Line 37
Object is invalid. Extended properties are not permitted on 'dbo.v_test', or the object does not exist.
The statement has been terminated.

Can anyoone help me?
Posted 24-Jan-13 7:05am
Mike Meinz at 24-Jan-13 13:15pm
There is no Line 37 in the code that you provided in your question. You're not showing us everything we need to solve this problem. I tried the exact syntax above on my SQL Server and it works fine.
Tharaka MTR at 24-Jan-13 22:01pm
Yes, please share your complete sql

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

There are 2 possibilities for your problem
1. you may not have rights to create view
2. table may not be there in your table
Note: Your syntax is 100% verify the above 2 steps mention by me.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 428
1 Maciej Los 260
2 Sergey Alexandrovich Kryukov 220
3 DamithSL 208
4 Dave Kreskowiak 200

Advertise | Privacy | Mobile
Web04 | 2.8.140709.1 | Last Updated 28 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid