Applying sp4 to ss2000

When trying to upgrade to ss2005 the install program said that I needed to
install sp3 before upgrade. I can't find sp3 anywhere but I have sp4 with
my msdn disks. When I try to apply sp4 it says that "another operation has
left pending files and I need to restart my computer. I restart my computer
and ....
I try to apply sp4 it says that "another operation has left pending files
and I need to restart my computer. I restart my computer and ....
I try to apply sp4 it says that "another operation has left pending files
and I need to restart my computer. I restart my computer and ....
I try to apply sp4 it says that "another operation has left pending files
and I need to restart my computer. I restart my computer and ....
then I got tired of trying and quit.
Does anyone know how to get around the little catch 22?
Thanks,
TCheck out:
http://support.microsoft.com/kb/817362/en-us
Hope this helps.
Dan Guzman
SQL Server MVP
"Tina" <tinamseaburn@.nospammeexcite.com> wrote in message
news:e8qnSf1hGHA.3588@.TK2MSFTNGP02.phx.gbl...
> When trying to upgrade to ss2005 the install program said that I needed to
> install sp3 before upgrade. I can't find sp3 anywhere but I have sp4 with
> my msdn disks. When I try to apply sp4 it says that "another operation
> has left pending files and I need to restart my computer. I restart my
> computer and ....
> I try to apply sp4 it says that "another operation has left pending files
> and I need to restart my computer. I restart my computer and ....
> I try to apply sp4 it says that "another operation has left pending files
> and I need to restart my computer. I restart my computer and ....
> I try to apply sp4 it says that "another operation has left pending files
> and I need to restart my computer. I restart my computer and ....
> then I got tired of trying and quit.
>
> Does anyone know how to get around the little catch 22?
> Thanks,
> T
>

Applying sp4 to ss2000

When trying to upgrade to ss2005 the install program said that I needed to
install sp3 before upgrade. I can't find sp3 anywhere but I have sp4 with
my msdn disks. When I try to apply sp4 it says that "another operation has
left pending files and I need to restart my computer. I restart my computer
and ....
I try to apply sp4 it says that "another operation has left pending files
and I need to restart my computer. I restart my computer and ....
I try to apply sp4 it says that "another operation has left pending files
and I need to restart my computer. I restart my computer and ....
I try to apply sp4 it says that "another operation has left pending files
and I need to restart my computer. I restart my computer and ....
then I got tired of trying and quit.
Does anyone know how to get around the little catch 22?
Thanks,
TCheck out:
http://support.microsoft.com/kb/817362/en-us
Hope this helps.
Dan Guzman
SQL Server MVP
"Tina" <tinamseaburn@.nospammeexcite.com> wrote in message
news:e8qnSf1hGHA.3588@.TK2MSFTNGP02.phx.gbl...
> When trying to upgrade to ss2005 the install program said that I needed to
> install sp3 before upgrade. I can't find sp3 anywhere but I have sp4 with
> my msdn disks. When I try to apply sp4 it says that "another operation
> has left pending files and I need to restart my computer. I restart my
> computer and ....
> I try to apply sp4 it says that "another operation has left pending files
> and I need to restart my computer. I restart my computer and ....
> I try to apply sp4 it says that "another operation has left pending files
> and I need to restart my computer. I restart my computer and ....
> I try to apply sp4 it says that "another operation has left pending files
> and I need to restart my computer. I restart my computer and ....
> then I got tired of trying and quit.
>
> Does anyone know how to get around the little catch 22?
> Thanks,
> T
>

application development and permissions

Using SS2000 SP4. We have an application that will use a single user to logi
n
from the application after development. We will use only stored procedures
and views to access the data.
I was thinking of creating a "developer" login for the developer and
assigning it to the db_owner role. As I understand it, this would make the
owner of the tables, stored procedures and views "dbo". After development,
assuming there is no dynamic sql used, would I then be able to give execute
permission on the stored procedures and select permissions on the views to
the application user and have everything work?
Thanks,
Dan D.Dan
Sure
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:A56A2358-08D0-4C65-9D2F-564BF9873B6D@.microsoft.com...
> Using SS2000 SP4. We have an application that will use a single user to
> login
> from the application after development. We will use only stored procedures
> and views to access the data.
> I was thinking of creating a "developer" login for the developer and
> assigning it to the db_owner role. As I understand it, this would make the
> owner of the tables, stored procedures and views "dbo". After development,
> assuming there is no dynamic sql used, would I then be able to give
> execute
> permission on the stored procedures and select permissions on the views to
> the application user and have everything work?
> Thanks,
> --
> Dan D.|||Thanks.
--
Dan D.
"Uri Dimant" wrote:

> Dan
> Sure
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:A56A2358-08D0-4C65-9D2F-564BF9873B6D@.microsoft.com...
>
>