Dynamic credentials ...

Hi managed to have a dynamic database with SQL server using something like
this as my query :
declare @.SQL varchar(255)
Select @.OwnerID = '[' + @.OwnerID + ']'
select @.SQL = @.DBName + '.dbo.sp_rptFinance ' + @.YearBegin + ',' + @.OwnerID
exec (@.SQL)
However each of my database uses a different set of credentials ... is there
a way to specify the credentials in such a query?
Thx
EricNo, there is not...
credentials are supplied with the connection and are part of the data
source...
--
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.
"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:572D7F3D-1CCD-4334-86F0-DCF86EE841C8@.microsoft.com...
> Hi managed to have a dynamic database with SQL server using something like
> this as my query :
>
> declare @.SQL varchar(255)
> Select @.OwnerID = '[' + @.OwnerID + ']'
> select @.SQL = @.DBName + '.dbo.sp_rptFinance ' + @.YearBegin + ',' +
> @.OwnerID
> exec (@.SQL)
> However each of my database uses a different set of credentials ... is
> there
> a way to specify the credentials in such a query?
> Thx
> Eric