a service pack question...

background: sql2k
I have a quick question about sql sp3a.
when i apply the sp3a, is that just for the sql or for analysis service
as well?
if i have ananlysis services installed, do you need to apply the sp3
for analysis service seperately (in MSOLAP|install|setup on the sp3a
CD) or sql sp3a will take care of it? thank you.> I have a quick question about sql sp3a.
> when i apply the sp3a, is that just for the sql or for analysis service
> as well?
No.

> if i have ananlysis services installed, do you need to apply the sp3
> for analysis service seperately (in MSOLAP|install|setup on the sp3a
> CD)
Yes.

> or sql sp3a will take care of it? thank you.
No.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

a question for using bcp in stored procedure..

background: sql2k, nt5
is it possible to write a sp to do the following:
within the sp, create a #temp table
bcp a table from a mdb (Access) file to that #temp table directly (assuming
table structure would be the same).
or one has bring the Access table into sql server as a static table first?
would appreicate some sample (or psudo code). thank youYou could create a atored procedure that executes a DTS package via DTSRUN. The DTS package would be setup with the Access DB and specific Access table as the dats source and the SQL table as the destination