| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-20 : 13:51:26
|
| SQL Server 2000 SP3 is available for download. In addition to rolling up all the bug fixes so far it includes some enhanced security features including allowing SQL Server Agent to run as a non-Administrator. Article Link. |
|
|
scullee
Posting Yak Master
103 Posts |
Posted - 2003-01-20 : 22:28:46
|
| ArrrggggghhhhhhI just spent the time downloading the 55mb and then extracted it. The extract finished fine and now when i go to run the install it says cannot find x86/setup/setupsql.exeThis happened on the previous service pack too and i cant remember how i fixed it. Any ideas? |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-01-21 : 02:46:09
|
| Just run setupsql.exe in the x86/setup sub folder.HTHJasper Smith |
|
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2003-01-21 : 10:25:27
|
| I've had this problem when trying to run the setup.bat from a network share or mapped drive. Try copying it to a local drive, then run setup.bat.-- monkey |
|
|
|
scullee
Posting Yak Master
103 Posts |
Posted - 2003-01-21 : 17:42:28
|
| The files arent there though.I compared the tree to the ones from the previous service packs and there seems to be a whole series missing.I really do hate computers!!!! ;) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-21 : 19:18:15
|
| Are you sure you downloaded the correct file? There are two files on the download screen. You want the one that is called sql2ksp3.exe. |
|
|
|
scullee
Posting Yak Master
103 Posts |
Posted - 2003-01-21 : 19:59:07
|
| Its strange, i downloaded it again through another browser (opera) and the file worked fine. If i compare the 2 files they are identical in size and date etc etc but one of them extracts everything and the other only extracts some but doesnt return an error message.Im confused.Its fixed now though :)Thanks anyway |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-21 : 20:23:54
|
| Hey as long as it is fixed, who cares? But that is strange. I wonder if MS had a bad file out there and then someone reported it, so they changed it. |
|
|
|
aiken
Aged Yak Warrior
525 Posts |
Posted - 2003-01-21 : 23:30:58
|
| So has anyone actually *installed* it yet, especially on any kind of high-volume server? -b |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-01-22 : 01:30:00
|
| I had installed it some time ago on our production server and the first time i downloaded the sp it did'nt work and i had to download it again to get the good copy.Expect the UnExpectedEdited by - harshal_in on 01/22/2003 01:30:38 |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-01-22 : 02:29:42
|
| I've installed it lots of times and have been running it at home for ages. Not had any issues. Never had a problem installing it either.HTHJasper Smith |
|
|
|
jcaudill
Starting Member
2 Posts |
Posted - 2003-01-24 : 14:59:23
|
| I installed SP3 on my local instance of SQL2k. Shortly after, I noticed that while trying to create a DTS task to pump data from a table to a text file, it would crash EM completely. Even though that doesn't really pertain to the server itself, it is definitely SP3 related and I'd exercise extreme caution in upgrading without thorough testing. I'm glad we did not place this on a perfectly good server now. |
|
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2003-01-24 : 18:26:06
|
quote:
I installed SP3 on my local instance of SQL2k. Shortly after, I noticed that while trying to create a DTS task to pump data from a table to a text file, it would crash EM completely. Even though that doesn't really pertain to the server itself, it is definitely SP3 related and I'd exercise extreme caution in upgrading without thorough testing. I'm glad we did not place this on a perfectly good server now.
Microsoft is aware of this issue, and it is indeed introduced by SP3. I don't think it affects existing DTS packages, but sure, do test your packages thoroughly in test environment before going live with SP3.--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
Onamuji
Aged Yak Warrior
504 Posts |
Posted - 2003-01-27 : 12:35:41
|
| did anyone notice that it won't install the SP unless you have a strong password for the SA account! :) Finally ... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-27 : 12:55:27
|
quote:
did anyone notice that it won't install the SP unless you have a strong password for the SA account! :) Finally ...
That is very cool! |
|
|
|
KHeon
Posting Yak Master
135 Posts |
Posted - 2003-01-28 : 07:11:53
|
| I believe MS started enforcing an sa password with SQL Server 2000 SP2. It is very cool, about time!Kyle HeonPixelMEDIA, Inc.Senior Application Programmer, MCPkheon@pixelmedia.com |
|
|
|
vishy
Starting Member
1 Post |
Posted - 2003-01-28 : 10:24:42
|
| hi, i installed service pack 3 a few days ago on a machine in which I was running 2 instances. The size of the engine grew to about a gig each and crashed the machine. Is this a known bug ? any suggestions?thanks-vishy |
|
|
|
barrys
Starting Member
4 Posts |
Posted - 2003-01-29 : 10:01:50
|
| Damn!I installed it on a production server and now queries are running on it turtle slow.This is a high volume server so I'm hurting bad. Anyone encounter something similar? Any advice? |
|
|
|
tgyuri
Starting Member
2 Posts |
Posted - 2003-02-18 : 08:02:55
|
quote:
Damn!I installed it on a production server and now queries are running on it turtle slow.This is a high volume server so I'm hurting bad. Anyone encounter something similar? Any advice?
This has happend after installing sp3 me too. In another forum thay said to me to update statistics. It did not resolve anything for me, maybe it will solve yoursGyuri |
|
|
|
tgyuri
Starting Member
2 Posts |
Posted - 2003-02-18 : 08:03:08
|
quote:
Damn!I installed it on a production server and now queries are running on it turtle slow.This is a high volume server so I'm hurting bad. Anyone encounter something similar? Any advice?
This has happend after installing sp3 me too. In another forum thay said to me to update statistics. It did not resolve anything for me, maybe it will solve yoursGyuri |
|
|
|
dhart43
Starting Member
1 Post |
Posted - 2003-04-03 : 15:49:13
|
| I've just installed SP3 on one of our development servers and full-text indexing doesn't seem to work any more. Is this a known bug -- any help is appreciated.Regards,Dave |
|
|
|
Next Page
|
Article: SQL Server 2000 SP3 Available