Re: stored proc question
From: Uri Dimant (urid_at_iscar.co.il)
Date: 06/03/04
- Next message: Uri Dimant: "Re: log file size"
- Previous message: Brian Swisher: "Re: View has incorrect column names after fields were added to table"
- In reply to: Rob: "stored proc question"
- Next in thread: Rob: "Re: stored proc question"
- Reply: Rob: "Re: stored proc question"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 3 Jun 2004 16:09:18 +0200
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: Uri Dimant: "Re: log file size"
- Previous message: Brian Swisher: "Re: View has incorrect column names after fields were added to table"
- In reply to: Rob: "stored proc question"
- Next in thread: Rob: "Re: stored proc question"
- Reply: Rob: "Re: stored proc question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
