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 |
|
rudesyle
Posting Yak Master
110 Posts |
 Posted - 2007-06-21 : 13:19:57
|
| Just curious to know what you think. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-21 : 16:32:23
|
| Does sql have that data type? |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-06-21 : 16:37:15
|
| I believe it is only available with SQL Server 2005 Enterprise or Developer Edition, and it has to be enabled.CODO ERGO SUM |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-21 : 16:40:47
|
| Need sp2 at least. |
|
|
|
rudesyle
Posting Yak Master
110 Posts |
Posted - 2007-06-22 : 10:15:52
|
quote:
Originally posted by Michael Valentine Jones
I believe it is only available with SQL Server 2005 Enterprise or Developer Edition, and it has to be enabled.CODO ERGO SUM
Exactly. Was reading about it a little yesterday http://technet.microsoft.com/en-us/library/bb326755.aspx , and was wondering if anyone's tried it. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-22 : 10:35:36
|
| i didhttp://weblogs.sqlteam.com/mladenp/archive/2006/11/10/19546.aspxnote that this isn't a datatype. it's a storage format.It also present a problem because you can't restore a backup made on ss2k5 sp1 to ss2k5 without sp1_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-06-22 : 10:58:47
|
| Since it is only available in the Enterprise Edition, I am reluctant to develop something that can only be run on that edition in production.A few months ago, we had a post here from someone who had developed a DB this way on Developer Edition, and found they could not deploy to production because they were running Standard Edition. Oops.CODO ERGO SUM |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-22 : 11:21:34
|
| i haven't seen this thread but if they had that problem all they had to do is simply comment the code forenabling vardecimal.it's implementation is handled completly by sql server_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
Anyone out there using Vardecimal storage format?