Re: SSMS Bug with extended properties on xml indexes?
- From: "Michael Rys [MSFT]" <mrys@xxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 2 Apr 2007 22:47:40 -0700
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
.
- Follow-Ups:
- Re: SSMS Bug with extended properties on xml indexes?
- From: justageezer
- Re: SSMS Bug with extended properties on xml indexes?
- Prev by Date: Re: Modify in a large xml file
- Next by Date: Re: Creating correct XML output?
- Previous by thread: Re: Modify in a large xml file
- Next by thread: Re: SSMS Bug with extended properties on xml indexes?
- Index(es):
Relevant Pages
|
