Post reply

QOD 8-4-2003 Disagree with answer...

  • August 4, 2003 at 11:24 pm

    #468569

    quote:

    Antares, I think you just tested the limit of the text column we have to store posts :).

    This certainly qualifies as the longest post

    However, one question hasn't satisfyingly been answered.

    Is there an 'ultimate' way to see which version of BOL I have?

    I mean apart from looking at the starting page and the title bar, is there somewhere some version information or stuff like that?

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • August 5, 2003 at 5:42 am

    #468607

    On the very bottom of the

    Getting Started -> MS SQL Server 2000 Copyright and Disclaimer mine says

    "Version 8.00.000"

    Does anyone else say someting different?

    Ross

  • August 5, 2003 at 5:47 am

    #468608

    quote:

    On the very bottom of the

    Getting Started -> MS SQL Server 2000 Copyright and Disclaimer mine says

    "Version 8.00.000"

    Does anyone else say someting different?

    Version: 8.00.002

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • August 5, 2003 at 6:05 am

    #468612

    quote:

    quote:

    Antares, I think you just tested the limit of the text column we have to store posts :).

    This certainly qualifies as the longest post

    However, one question hasn't satisfyingly been answered.

    Is there an 'ultimate' way to see which version of BOL I have?

    I mean apart from looking at the starting page and the title bar, is there somewhere some version information or stuff like that?

    Cheers,

    Frank

    Actually I didn't think it was going to be that long and tried to remove some empty space.

    But as the version no there isn't except if the title bar states Updated then you are not running the install copy. I actually have all from 7 and 2000 but cannot put my finger on the clean install copy or the SP2 copy. I do believe there is a total size difference. SP3 final is 39.7 MB for 2000.

  • August 5, 2003 at 6:27 am

    #468627

    Hi Antares,

    quote:

    Actually I didn't think it was going to be that long and tried to remove some empty space.

    good for us

    quote:

    But as the version no there isn't except if the title bar states Updated then you are not running the install copy. I actually have all from 7 and 2000 but cannot put my finger on the clean install copy or the SP2 copy. I do believe there is a total size difference. SP3 final is 39.7 MB for 2000.

    actually I think the above version number is a good indicator. Unfortunately I didn't find the most current version number on M$ website.

    They state its version 1 according to

    http://www.microsoft.com/downloads/details.aspx?FamilyID=683D71A6-BCF4-45A6-A2E2-F6AB5BE3EF12&displaylang=en

    Any better place to search?

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • August 5, 2003 at 7:23 am

    #468644

    Mine also says:

    Version: 8.00.002

    And I have SP3 for BOL loaded. The title bar says SQL Server Books Online (Updated - SP3).

    -SQLBill

  • August 5, 2003 at 8:00 am

    #468656

    I just upgraded my BOL to the new SP3 version.

    Prior to upgrading the title bar was "SQL Server Books Online" and the version indication on the Getting Started --> Microsoft SQL Server 2000 Copyright and Disclaimer page was "Version: 8.00.000"

    Now the title bar is "SQL Server Books Online (Updated - SP3)" and the version is "8.00.002"

    Hope this helps anyone else suffering the same confusion I was.

    It should also be noted that my BOL now correctly indicates that the TABLE data type cannot be used as a parameter for a stored procedure.

    Scott

  • August 5, 2003 at 8:01 am

    #468659

    Man don't I look stupid

    I could have sworn I updated my workstation with the BOL update but I guess I forgot to do that. I updated the server but not my machine. I just ran the update...

    Now my version says "8.00.002"

    And the reference earlier to the original question of the table usage for parameter says

    "any of the Microsoft® SQL Server™ 2000 data types, except the table data type "

    So that answers that question in my mind.

    Ross

  • August 5, 2003 at 8:04 am

    #468660

    So, now that's everything ok again, do you have some american aquivalent for :

    'Peace, Joy and eggcake' ?

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • August 5, 2003 at 8:16 am

    #468664

    quote:

    So, now that's everything ok again, do you have some american aquivalent for :

    'Peace, Joy and eggcake' ?

    If I could figure out how Peace and Joy fit with eggcake I could answer.

    Ross

  • August 5, 2003 at 8:23 am

    #468668

    quote:

    If I could figure out how Peace and Joy fit with eggcake I could answer.

    don't try to think about the meaning, it's just a word by word translation.

    Means something like 'Love, peace and understanding'

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • August 5, 2003 at 8:27 am

    #468671

    I understand. I can't think of anything off the top of my head.

    Being of scandanavian descent and being from Fargo, ND we would say something like

    "Yah, You Betcha"

    Ross

Viewing 12 posts - 16 through 26 (of 26 total)

You must be logged in to reply to this topic. Login to reply