Author |
Topic |
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2007-01-26 : 09:54:01
|
Hi i'd like to know if i installed SQL standard addition on my win xp pro woulld i get all the default database maste,model,tempdb etc.. |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-01-26 : 09:58:35
|
yes. This are system databases. KH |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2007-01-26 : 10:02:11
|
Well this is strange as i have the standard addition and i tried to install it i was getting a message i can't recall it but will post it on here later.. then the inslation completed i did not have any database like master model tempbd etc.. I just remember something i don't think i have service pack 2 on my xp pro O/s would this make a differences |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-01-26 : 10:58:36
|
you cannot install standard edition on winxp. you can only install developer edition on winxp. You can also look at installing MSDE or SQL Express on your desktop, but they don't ship with all features or management tools.workgroup, standard and enterprise edition can only be installed on server OS systems (win2k, win2k3).-ec |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2007-01-29 : 06:16:32
|
All i really want would be to create a simple database , and use a tool like the query Analyzer, its for home use. Would SQL Express be the best option ? |
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2007-01-29 : 09:25:31
|
I use a win2k3 virtual machine on top of winxp and run sql enterprise edition from there instead. |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2007-01-29 : 10:14:57
|
But i don't have a copy of win 2k,3 server o/s all i have is xp home and xp pro.. |
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2007-01-29 : 11:14:07
|
Hi thanks for the link, i will install it on my win xp pro and will let you know how i get on. P.S do you know the link to were i can get SP 2 as my xp pro has only get SP1 on it ? |
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2007-01-29 : 11:41:13
|
if you are running xp pro sp2, virtual pc 2004 sp1 will be fine. |
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2007-01-29 : 11:45:17
|
why dont you install xp pro sp2 then ? |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2007-01-29 : 11:49:10
|
I'd like to install SP2 for xp but i can't get the right link for the down load ... |
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-01-29 : 12:07:51
|
Why don't you just get the SQL Servr Developer Edition?It costs about $50 US, and gives you all the features of the Enterprise Edition.CODO ERGO SUM |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2007-01-30 : 06:59:02
|
In the Virtual Pc Console press file , new virtual machine wizard and setup a 2003 server from here.Other than that I think MVJ's advise is better. |
|
|
|