Click here to Skip to main content
Rate this: bad
good
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 7:05am
Comments
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
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
0 OriginalGriff 370
1 Sergey Alexandrovich Kryukov 195
2 Prakriti Goyal 177
3 jlopez788 134
4 _Amy 110
0 OriginalGriff 6,762
1 Sergey Alexandrovich Kryukov 5,539
2 Maciej Los 3,479
3 Peter Leow 3,323
4 DamithSL 2,505


Advertise | Privacy | Mobile
Web02 | 2.8.140721.1 | Last Updated 28 Jan 2013
Copyright © CodeProject, 1999-2014
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