June 7, 2011 at 5:31 am
Heya,
I learned recently that my hosting company has charged me for too much for my SQLServer. My colleague says he claimed that even though SELECT @@VERSION shows "Workgroup Edition (64-bit)....", in fact in the background Standard Edition is being used.
For me this is bull droppings!! Nevertheless, does anyone know if there can be a tiny bit of truth in such a claim?
I am talking to the guy myself this afternoon, so any ammunition would e appreciated!!!!
Thx,
Raymond
June 7, 2011 at 5:43 am
Never ever heard of @@version returning the wrong value.
How much did they charge vs the correct price?
June 7, 2011 at 5:59 am
Yeah, you can't argue with @@version.
Show him the results of this script, it's the same thing except using the serverproperty function.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Make sure you have the correct version too!
2008 = 10.0.1600
2008 R2 = 10.50.1600
good luck
June 7, 2011 at 6:18 am
Thx for y'r replies. They charged SQL Standard (330 euro excl VAT), while the version showed Workgroup (78 euro excl VAT).....!!!
June 7, 2011 at 6:20 am
Ya but how much WITH the vats, maybe this is where you're getting a better deal.
If not you just need to contact sales again and expose the problem.
June 7, 2011 at 6:36 am
If @@version is showing Workgroup, it will actually be up to the hosting company to prove otherwise.
Most likely, it's not an intentional deception. Someone installed Workgroup where they were supposed to install Standard, nobody checked the work, and the paperwork shows Standard.
I recently ran into sort of the opposite situation, with some added ignorance. A tech at the hosting company claimed he found we were running into timeouts on our website because "you have SQL Developer Edition installed, and that only allows 1 connection at a time". @@version showed Standard Edition. So, not only was he wrong about the edition, but also about the featureset of the edition (Dev is Enterprise, and it certainly allows more than 1 connection at a time). Not malicious, just confused.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply