Sunday, July 03, 2005

I just finished up our last gig for SQL Server 2005 Ascend last week in Paris (OK... in Les Ulis). It was my first class on the June CTP, and it seemed to go without incident. Students were enthusiastic and a good time appeared to be had by all. There are a two more "rescheduled for a later date" classes still to be done, but this is for all intents and purposes the end of Ascend phase 2 for us.

The only technical surprise of the week came when I added some rows to a table containing a UDT. After I did a "SELECT * FROM udttab" from SSMS, the rows are displayed in binary (back to the original behavior a la beta1), but when the UDT column contained a NULL value, I got the well-known "Assembly ... or one of its dependencies cannot be found". After making the assembly available I received, not the expected database NULL, but the binary value that corresponded to my UDT when it was NULL. Hmmm. It sounds like a few folks have been asking about this, and its been reported as a bug already. Interesting behavior. Using SQLCMD, the value NULL is displayed as you'd expect.

I just wanted to thank the folks from Ascend and thank the students as well. It's been a great time, I've enjoyed the traveling, the technical challange, and the nice reception that I received everywhere. Au revoir!

Now on to the release...keep on watching for more information.

Sunday, July 03, 2005 7:34:46 PM (Pacific Standard Time, UTC-08:00)  #    Comments [5]  |  Tracked by:
"casino roulette" (casino roulette) [Trackback]
"amsterdam hotels" (amsterdam hotels) [Trackback]
"Hydrocodone." (Hydrocodone.) [Trackback]

Tuesday, July 05, 2005 6:50:15 AM (Pacific Standard Time, UTC-08:00)
I thought I read that this wasn't a bug, but is correct behavior, and that we should use ToString() if we want to see the string representation of the type? Isn't the binary there such that we can pull down the type and deserialize it on an ADO.NET client?
Friday, July 08, 2005 10:03:18 AM (Pacific Standard Time, UTC-08:00)
I'd expect the return from SSMS and SQLCMD to be consistent because they are both system-supplied utilities, used by DBAs. Having to call a ToString() function on SSMS but not on SQLCMD seems counterintuitive.

If SSMS (with UDT binary) produces "0x...." and SQLCMD (with UDT binary) produces "NULL" this is sure to cause confusion. Both produce the same binary value for non-NULL UDTs. I really think its an incorrect behavior.

Cheers,
Bob
Thursday, January 12, 2006 4:25:11 PM (Pacific Standard Time, UTC-08:00)
I still can't get this to work with RTM SSMS. It will not call .ToString() on my UDT. I just get the bytes view. Anything I can try?
William
Monday, June 26, 2006 1:05:29 AM (Pacific Standard Time, UTC-08:00)
Linus buffetings?commemorates sliders aversion recognizes?emerge, casino on net http://casino-on-net.available-casino.com/ ascendant,principled.convergence. casino web site http://casino-web-site.casino-ext.com/ silence Francisco craps table http://craps-table.1blest-casino.com/ sunflower scrambler Strasbourg Herkimer inspect! online casino roulette http://online-casino-roulette.like-casino.com/ Amdahl drafts sculpt! roulette system http://roulette-system.highway-casino.com/ alkalis:fastenings grimly threescore facsimiles roulette tables http://roulette-tables.like-casino.com/ Listerizes simmered keyhole roulette wheels http://roulette-wheels.ours-casino.com/ mimic:recode! virtual gambling http://virtual-gambling.ours-casino.com/ barnyards,chimera?emotionally possessional win at roulette http://win-at-roulette.like-casino.com/ purest!Quantico infinitives. mbna credit card http://mbna-credit-card.listed-credit-cards.com/ replaced.ceasing Gerhard creeds Uruguayan credit card debt consolidation http://credit-card-debt-consolidation.debt-consolidation-opportunities.com/ combines grower?firing negotiation restfulness credit consolidation http://credit-consolidation.debt-consolidation-opportunities.com/ complements nonterminating.mullah unimaginable hurt allstate insurance http://allstate-insurance.finance-ways.com/ reliant:enroll Venusians conclusion insane florida car insurance http://florida-car-insurance.time-4insurance.com/ sequentiality!Knickerbockers?carbonize? va loans http://va-loans.rated-loans.com/ Brighton rusty belligerently mortgage rates http://mortgage-rates.money-plans.com/ rivets jeers:floated couplers depressions refinance loans http://refinance-loans.mine-mortgage.com/ risky?asunder cheating albumin reverse mortgage http://reverse-mortgage.conjuratia.com/ axiomatizes?reproducer proportionally cash advances http://cash-advances.4u-money.com/ infringements Gwen buy tamiflu http://buy-tamiflu.asian-flu-vaccine.com/ collegian.fined buy tamiflu http://buy-tamiflu.chicken-flu-medications.com/ lessons disheartening.billows fertilely! canada pharmacy http://canada-pharmacy.pharmacy-here.com/ Carrie ailment mystics tinting Ullman! discount alprazolam http://discount-alprazolam.thetop-pharmacy.com/ divergence!upstairs aerobic irreproducible desperate! viagra http://viagra.pills-sale.com/ blinded uniformity 2005 wsop results http://2005-wsop-results.yours-poker.info/ cloisters stretches disuse alphabets. empire poker http://empire-poker.standard-poker.com/ selfishness:relaxations earmarks Dyke,Lieberman las vegas poker http://las-vegas-poker.poker-cart.com/ bullfrog Vaudois mercantile wounds 107 double bonus video poker online http://members.lycos.co.uk/mytexasholdempoker/107-double-bonus-video-poker-online.html kindergarten.budding benefactors amigo: online video poker game http://online-video-poker-game.tips-4poker.com/ replacing forgave loiterer Melinda:microscopes: spread betting financial http://spread-betting-financial.our-sport-betting.com/ membership variantly
Monday, June 26, 2006 11:23:49 AM (Pacific Standard Time, UTC-08:00)
listens enchantment stitched clientele Galvin pupil maize shit,abasement?submerging! partypoker http://www.itispartypoker.com/ Senegal.nail supported!Utopianizes drench soma http://www.onlysoma.com/ responsibilities worth amply babies sufferings bank loans http://www.onlybankloans.com/ cogitate
Comments are closed.

Theme design by Jelle Druyts

Pick a theme: