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..
Printable View
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..
Welcome to the forms. :wave:
I'm also running XP and have been using SQL Server 2000 for a very long time. What support issues are you having?
Quote:
Originally Posted by Hack
Some of us are even running MS SQL 7.0 with XP . . .
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.
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...
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).