Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JCollum
Starting Member
6 Posts |
 Posted - 2008-01-09 : 20:07:40
|
| I'm told that the extended properties that get added to views are bad. Not sure why, any ideas? Anyway, I'm told they are evil and to be avoided. I'm wondering if there's any way to a) turn these things off or b) drop them easily. Here's a sample of what they look like when you script a view as CREATE to a new window. SELECT {My columns}FROM {My table}GOEXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]Begin DesignProperties = Begin PaneConfigurations = Begin PaneConfiguration = 0 NumPanes = 4 Configuration = "(H (1[40] 4[20] 2[20] 3) )"etc..... It looks like I can drop these things with sp_dropextendedproperty but doing that every time I make a view with "New view" is silly (tedious). Solutions? |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-01-09 : 20:47:45
|
Use CREATE VIEW syntax in the query analyzer instead of the New View wizard, that way you can control it better.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
JCollum
Starting Member
6 Posts |
Posted - 2008-01-09 : 21:10:06
|
| Doesn't that extended property stuff get added if you use the Query Analyzer to build a view, even after it's been created? |
|
|
|
JCollum
Starting Member
6 Posts |
Posted - 2008-01-09 : 21:12:46
|
| Yep, I just took a view that didn't have it, moved some stuff around in the "Design" dialog, saved, and sure enough there it is. Got to be some way to just turn that crap off. Is there any real performance issues with these extended properties? Are there any issues caused by them at all? I've never heard of anything, but I'm no DBA. |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-01-09 : 21:15:17
|
I don't recall any performance issues, just a pain in the butt when I script them out and see it (and then go to dropextendedproperty)...it has only occurred on views created before "my time"
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
|
|
|
|
|
extended properties