datetimeoffset breaks sys.extended_properties
On SQL Server 2008, adding an extended property w/ type DATETIMEOFFSET via spaddextendedproperty breaks sys.extendedproperties.
Extended properties are still visible through SSMS -> Table -> Properties -> Extended Properties.
Reproduced on the following systems:
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)
Upvotes: 1<=-=Dec 30 2009 2:53PM=-=>
Good catch. This bug is now assigned over to the Dev for further investigation and fix.
Jim Hogg<=-=Mar 23 2010 2:50AM=-=>
We investigated this particluar issue and the fix for this will be part of our future releases. There is a similar bug that we are tracking for this issue – http://connect.microsoft.com/SQLServer/feedback/details/379631/ssms-partition-functions-with-datetimeoffset-cause-error-crash . Given this, I am going to resolve your issue as duplicate of the other issue.
Thanks for catching this issue and reporting to us.
- Vikrant Arora