Change Data Souce

How to change shared data source in dinamic mode by parameters?
If you have a sample, please send me a link.
Thanks.
Helder Flores
Sinatecno TIYou can not change the data source in SQL 2k... however you can use linked
servers, etc and create the query on the fly, which gives you the ability to
dynamically change from one server to the next ie in the data set
if @.reportparamtype=1
select * from dbo.table1
else
select * from mylinkedserver.pubs.dbo.table1
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Helder Flores" <helderflores@.discussoes.microsoft.com> wrote in message
news:1F5F4C61-F3FE-4D6F-88CC-6D676EA9B8E6@.microsoft.com...
> How to change shared data source in dinamic mode by parameters?
> If you have a sample, please send me a link.
> Thanks.
> Helder Flores
> Sinatecno TI
>|||It's a good way to solve this problem. Thanks Wayne.
--
Helder Flores
CEO - Sinatecno TI
"Wayne Snyder" wrote:
> You can not change the data source in SQL 2k... however you can use linked
> servers, etc and create the query on the fly, which gives you the ability to
> dynamically change from one server to the next ie in the data set
> if @.reportparamtype=1
> select * from dbo.table1
> else
> select * from mylinkedserver.pubs.dbo.table1
>
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Helder Flores" <helderflores@.discussoes.microsoft.com> wrote in message
> news:1F5F4C61-F3FE-4D6F-88CC-6D676EA9B8E6@.microsoft.com...
> > How to change shared data source in dinamic mode by parameters?
> > If you have a sample, please send me a link.
> >
> > Thanks.
> >
> > Helder Flores
> > Sinatecno TI
> >
>
>