| Author |
Topic |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2003-04-14 : 09:20:17
|
| hi,I have sql server 2k installed on win2k advanced server.I have installed sp3 on it.I want to know if the sp3 is required to be installed on all the other boxes which have sql client on them?thanks in advance,Regards,Harshal.Expect the UnExpected |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-14 : 12:28:07
|
| sp3 should be installed on the client machines as well if you use DTS. You will get weird problems if the server and clients are on different service pack levels.Tara |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-04-15 : 05:24:47
|
quote:
sp3 should be installed on the client machines as well if you use DTS. You will get weird problems if the server and clients are on different service pack levels.Tara
do u want to say that if I donot use dts it will be ok to continue with the existing thing? I have not installed any sp's on the client machines.we only install it on the server.I think this is not the correct practice.right?regards,Harshal.Expect the UnExpected |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-15 : 11:36:59
|
| Clients should be at the same service pack level as the server, but the only problem that I know about when they aren't at the same level is with DTS. So I believe that you are okay not installing the service pack on the clients. But I would still recommend that the clients be updated just in case.Tara |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-04-15 : 13:27:56
|
| Service packs contain fixes for client tools as well as servers. Whilst the most obvious issues can arise with DTS, there are other fixes (not least MDAC) that are well worth having on the client.HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-15 : 13:30:24
|
| Yes so very true, but the client can get away with not having the service pack installed is the point, however it's not recommended because of the bug fixes for the client.Tara |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-04-15 : 13:40:01
|
| convert(varchar(1000),0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27)wish I hadn't.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-04-15 : 13:49:17
|
The devil makes work for idle hands   HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-15 : 13:53:07
|
| "0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27"Too funny!Tara |
|
|
|
|
sp3 question