Re: SSMS Bug with extended properties on xml indexes?
- From: justageezer <justageezer@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 3 Apr 2007 03:32:01 -0700
Thankks for the replies chaps, I'll submit the following to connect as well:
This is how I create problem on XP SP2 / SQL SP2a:
Open SSMS and connect to a server.
Expand Databases, expand AW or your favorite test db, right-click Tables,
select New table.
Add 1st col: id identity(1,1) int PK not null.
Add 2nd col xmlcol xml null.
Right-click xmlcol and select Xml Indexes.
Click Add in Xml Index dialog, type a description and then click close.
Click Save and enter a name for your table - not Table1.
Right-click xmlcol again and select Xml indexes.
Change your description / the name of the index (which is still ...Table1)
or possibly any property.
Try to save your table....
Get this message: "'xmltest' table
- Unable to create index 'XML_IX_Table1'.
Property cannot be added. Property 'MS_Description' already exists for
'dbo.xmltest.XML_IX_Table1'."
Yes, well, we knew that - we'd just created it:) And if you'd just created
or edited a table with lots of xml columns and descriptions then cancelling
out of the save until you drop them all is a bit of a pain...
Regards,
Paul Bryant
"Michael Rys [MSFT]" wrote:
Also, please file this at http://connect.microsoft.com/sqlserver against.
SSMS if you have not already done so.
Best regards
Michael
"Denis Ruckebusch [MSFT]" <denisruc@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:Om0KqmbZHHA.3824@xxxxxxxxxxxxxxxxxxxxxxx
I tried but couldn't repro your problem. I'm using SQL Server 2005 SP2 on
W2K3 SP2.
I'm not a big user of the SSMS interface (I usually use straight T-SQL) so
maybe there's something I didn't do exactly like you or I misunderstood.
If you want to repost some detailed steps indicating exactly how you get
to the error, I could try again.
Denis Ruckebusch
http://blogs.msdn.com/denisruc
--
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Paul Bryant" <paul@xxxxxxxxx> wrote in message
news:%23xMGOg%23YHHA.2316@xxxxxxxxxxxxxxxxxxxxxxx
Hi all,
Probably the wong forum, but I just wondered if anyone else here has
encountered this, and if so how they got around it:
If you add a description (MS_Description extended property) to an xml
index using the SSMS interface, any attempts to then alter that index or
description result in SSMS throwing an error (property MS_Description
already exists) and cancelling out of the save dialog. Even deleting the
index does not delete the extended property associated with it (duh?).
Seems pretty obvious what the problem is - and also pretty obvious that
not many people actually add descriptions to xml indexes or it would have
been fixed already. Sounds pretty minor I know, but it can be a total
£$%£"$% pain if you've just spent an hour editing xml index
descriptions...
Anyone found a way to edit the description of xml indexes using SSMS? Had
kinda hoped SP2 (or even 2a :) would have fixed this...
Cheers,
Paul
- References:
- Re: SSMS Bug with extended properties on xml indexes?
- From: Michael Rys [MSFT]
- Re: SSMS Bug with extended properties on xml indexes?
- Prev by Date: Re: XML Transform
- Next by Date: Re: MSSQL2k retrive data from xml
- Previous by thread: Re: SSMS Bug with extended properties on xml indexes?
- Next by thread: Re: Creating correct XML output?
- Index(es):
Relevant Pages
|
Loading
