Results 1 to 6 of 6

Thread: MS SQL 2000 newbie

  1. Aug 2nd, 2007, 08:40 AM #1
    joshthenewbie
    joshthenewbie is offline

    Thread Starter
    Junior Member
    Join Date
    Aug 2007
    Posts
    20

    MS SQL 2000 newbie

    hi, my OS is windows XP, i want to use ms sql 2000 but it doesn't support my
    OS, is there anyway around this? i want to build tables, make queries like
    in ms access, any guide will be appreciated, thanks, ps i also do have ms sql 2005..
    Reply With Quote Reply With Quote
  2. Aug 2nd, 2007, 08:42 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: MS SQL 2000 newbie

    Welcome to the forms.

    I'm also running XP and have been using SQL Server 2000 for a very long time. What support issues are you having?
    Reply With Quote Reply With Quote
  3. Aug 2nd, 2007, 08:56 AM #3
    Mark Gambo
    Mark Gambo is offline
    Giants World Champs!!!! Mark Gambo's Avatar
    Join Date
    Sep 2003
    Location
    Colorado
    Posts
    2,965

    Re: MS SQL 2000 newbie

    Quote Originally Posted by Hack
    . . .I'm also running XP and have been using SQL Server 2000 for a very long time. What support issues are you having?

    Some of us are even running MS SQL 7.0 with XP . . .
    Regards,

    Mark

    Please remember to rate posts! Rate any post you find helpful. Use the link to the left - "Rate this Post". Please use [highlight='vb'] your code goes in here [/highlight] tags when posting code. When a question you asked has been resolved, please go to the top of the original post and click "Thread Tools" then select "Mark Thread Resolved."

    Reply With Quote Reply With Quote
  4. Aug 2nd, 2007, 09:00 AM #4
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: MS SQL 2000 newbie

    One thing to note is that the full editions of SQL Server cannot be installed on desktop OS's (you can only install the client tools on them). There are editions that are desktop OS compatible tho - such as 2005 Express, MSDE (2000), or the Developer editions.

    If you really want SQL Server 2000, ideally you should use the Developer edition.. if you don't have it/cant get it, your best bet is probably to download MSDE (if it is still available), but bear in mind it does have extra limitations.

    If you don't mind using SQL Server 2005, just use the Express edition and download Management Studio - that is the user interface, which gives similar functionality to what you get in Access.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  6. Aug 2nd, 2007, 07:51 PM #5
    joshthenewbie
    joshthenewbie is offline

    Thread Starter
    Junior Member
    Join Date
    Aug 2007
    Posts
    20

    Re: MS SQL 2000 newbie

    im kinda new to sql server, and ive installed ms sql 2000 on my pc to practice on it, but i cant figured out where i could make tables just like in ms access, what i have in my sql 2000 menu is "query analizer", i dont mind using ms sql 2005 but when i installed it it say my OS doesnt support it, so i was stuck with ms sql 2000, i will try to install ms sql 2005 today and install management studio, thanks for ur help...
    Reply With Quote Reply With Quote
  7. Aug 3rd, 2007, 10:48 AM #6
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: MS SQL 2000 newbie

    For SQL Server 2000, you will want to create tables etc in Enterprise Manager, as that is what has the user interface - Query Analyser basically runs SQL statements.

    You should be able to install SQL Server 2005 Express, but you may need to install other things first (such as .Net Framework 2). The installation and the download page should tell you what you need (the download page should also link to them).
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width