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 8: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 300
1 Peter Leow 170
2 ProgramFOX 145
3 Zoltán Zörgő 130
4 Afzaal Ahmad Zeeshan 105
0 OriginalGriff 260
1 ProgramFOX 145
2 Peter Leow 130
3 Sergey Alexandrovich Kryukov 85
4 Fredrik Bornander 75

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

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100