Re: stored proc question
From: Rob (anonymous_at_discussions.microsoft.com)
Date: 06/03/04
- Next message: Rob: "RE: stored proc question"
- Previous message: Allison: "SQL Server databases to a new location with Detach/Attach"
- In reply to: Uri Dimant: "Re: stored proc question"
- Next in thread: Vinodk: "Re: stored proc question"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 3 Jun 2004 06:44:45 -0700
Thanks Uri... that was very helpful. Do you know how to
UNMARK the same object that had been marked as a system
object?
- Rob.
>-----Original Message-----
>Rob
>See if it helps you
>use master
>create table t(c1 varchar(50)) insert t values('master')
>go
>create proc sp_test as select * from t
>GO
>use northwind
>create table t(c1 varchar(50)) insert t values
('northwind')
>use pubs
>create table t(c1 varchar(50)) insert t values('pubs')
>use pubs
>exec sp_test --returns 'master'
>use master
>exec sp_MS_marksystemobject sp_test
>use pubs
>exec sp_test --returns 'pubs'
>use northwind
>exec sp_test --returns 'northwind'
>
>
>
>
>"Rob" <anonymous@discussions.microsoft.com> wrote in
message
>news:17a1d01c44969$be77c310$a401280a@phx.gbl...
>> Hello:
>>
>> As I was implementing a sproc to one of my database, I
>> found a need to run the same sproc against another
>> database on the same server. Is there a way to run, lets
>> say, a generic sproc against the database of your
choice,
>> without having to create that same sproc on all of your
>> databases?
>>
>> Thanks.
>
>
>.
>
- Next message: Rob: "RE: stored proc question"
- Previous message: Allison: "SQL Server databases to a new location with Detach/Attach"
- In reply to: Uri Dimant: "Re: stored proc question"
- Next in thread: Vinodk: "Re: stored proc question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
