Click here to Skip to main content
13,295,987 members (54,796 online)
Rate this:
Please Sign up or sign in to vote.
See more:

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 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 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
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.171207.1 | Last Updated 28 Jan 2013
Copyright © CodeProject, 1999-2017
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