Click here to Skip to main content
12,625,912 members (28,367 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL-Server
Hi,

I ma trying to create the view in sqlserver.
Create view v_test
as
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
Comments
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
 
good
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% correct.so verify the above 2 steps mention by me.
  Permalink  

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 | Mobile
Web01 | 2.8.161205.3 | Last Updated 28 Jan 2013
Copyright © CodeProject, 1999-2016
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