how can I change the owner of an sp_

Hello,
I have a couple of sp_ that a user created now the have the domain\user
as the owner but no one else can run them. Can I set the owner of these sp_
to the dbo? How can I accomplish that on 20 sp's? Thanks in advance.
JakeLook up sp_changeobjectowner in BOL.
"Jake" <rondican@.hotmail.com> wrote in message
news:OYYaA1usEHA.1604@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have a couple of sp_ that a user created now the have the
domain\user
> as the owner but no one else can run them. Can I set the owner of these
sp_
> to the dbo? How can I accomplish that on 20 sp's? Thanks in advance.
> Jake
>|||Adam,
Thanks for the info.
Jake
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:OkIVw6usEHA.2960@.TK2MSFTNGP10.phx.gbl...
> Look up sp_changeobjectowner in BOL.
>
> "Jake" <rondican@.hotmail.com> wrote in message
> news:OYYaA1usEHA.1604@.TK2MSFTNGP15.phx.gbl...
> domain\user
> sp_
>sql

how can I change the owner of an sp_

Hello,
I have a couple of sp_ that a user created now the have the domain\user
as the owner but no one else can run them. Can I set the owner of these sp_
to the dbo? How can I accomplish that on 20 sp's? Thanks in advance.
Jake
Look up sp_changeobjectowner in BOL.
"Jake" <rondican@.hotmail.com> wrote in message
news:OYYaA1usEHA.1604@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have a couple of sp_ that a user created now the have the
domain\user
> as the owner but no one else can run them. Can I set the owner of these
sp_
> to the dbo? How can I accomplish that on 20 sp's? Thanks in advance.
> Jake
>
|||Adam,
Thanks for the info.
Jake
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:OkIVw6usEHA.2960@.TK2MSFTNGP10.phx.gbl...
> Look up sp_changeobjectowner in BOL.
>
> "Jake" <rondican@.hotmail.com> wrote in message
> news:OYYaA1usEHA.1604@.TK2MSFTNGP15.phx.gbl...
> domain\user
> sp_
>

how can I change the owner of an sp_

Hello,
I have a couple of sp_ that a user created now the have the domain\user
as the owner but no one else can run them. Can I set the owner of these sp_
to the dbo? How can I accomplish that on 20 sp's? Thanks in advance.
JakeLook up sp_changeobjectowner in BOL.
"Jake" <rondican@.hotmail.com> wrote in message
news:OYYaA1usEHA.1604@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have a couple of sp_ that a user created now the have the
domain\user
> as the owner but no one else can run them. Can I set the owner of these
sp_
> to the dbo? How can I accomplish that on 20 sp's? Thanks in advance.
> Jake
>|||Adam,
Thanks for the info.
Jake
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:OkIVw6usEHA.2960@.TK2MSFTNGP10.phx.gbl...
> Look up sp_changeobjectowner in BOL.
>
> "Jake" <rondican@.hotmail.com> wrote in message
> news:OYYaA1usEHA.1604@.TK2MSFTNGP15.phx.gbl...
>> Hello,
>> I have a couple of sp_ that a user created now the have the
> domain\user
>> as the owner but no one else can run them. Can I set the owner of these
> sp_
>> to the dbo? How can I accomplish that on 20 sp's? Thanks in advance.
>> Jake
>>
>

How can a spid block himself.

SQL2K sp3.
Ive got some DB blocking going on and a couple of times now I see that a
spid is blocked by himself. How can this happen?
TIA, ChrisR
See if this helps.
The blocked column in the sysprocesses table is populated for latch waits
after you install SQL Server 2000 SP4
http://support.microsoft.com/?id=906344
AMB
"ChrisR" wrote:

> SQL2K sp3.
> Ive got some DB blocking going on and a couple of times now I see that a
> spid is blocked by himself. How can this happen?
> TIA, ChrisR
|||Thanks, but as indicated, I have sp3.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See if this helps.
> The blocked column in the sysprocesses table is populated for latch waits
> after you install SQL Server 2000 SP4
> http://support.microsoft.com/?id=906344
>
> AMB
> "ChrisR" wrote:

How can a spid block himself.

SQL2K sp3.
Ive got some DB blocking going on and a couple of times now I see that a
spid is blocked by himself. How can this happen?
TIA, ChrisRSee if this helps.
The blocked column in the sysprocesses table is populated for latch waits
after you install SQL Server 2000 SP4
http://support.microsoft.com/?id=906344
AMB
"ChrisR" wrote:

> SQL2K sp3.
> Ive got some DB blocking going on and a couple of times now I see that a
> spid is blocked by himself. How can this happen?
> TIA, ChrisR|||Thanks, but as indicated, I have sp3.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See if this helps.
> The blocked column in the sysprocesses table is populated for latch waits
> after you install SQL Server 2000 SP4
> http://support.microsoft.com/?id=906344
>
> AMB
> "ChrisR" wrote:
>

How can a spid block himself.

SQL2K sp3.
Ive got some DB blocking going on and a couple of times now I see that a
spid is blocked by himself. How can this happen?
TIA, ChrisRSee if this helps.
The blocked column in the sysprocesses table is populated for latch waits
after you install SQL Server 2000 SP4
http://support.microsoft.com/?id=906344
AMB
"ChrisR" wrote:
> SQL2K sp3.
> Ive got some DB blocking going on and a couple of times now I see that a
> spid is blocked by himself. How can this happen?
> TIA, ChrisR|||Thanks, but as indicated, I have sp3.
"Alejandro Mesa" wrote:
> See if this helps.
> The blocked column in the sysprocesses table is populated for latch waits
> after you install SQL Server 2000 SP4
> http://support.microsoft.com/?id=906344
>
> AMB
> "ChrisR" wrote:
> > SQL2K sp3.
> >
> > Ive got some DB blocking going on and a couple of times now I see that a
> > spid is blocked by himself. How can this happen?
> >
> > TIA, ChrisR