by kp,
exec('SELECT *
-oj
> I am trying to link servers in my stored procedures to transfer data for a
> project. There is one central database and multiple clients that are
cynking
> data at the end of each business day. I have succesfully cynked the data
> when I have hard coded the server name and login information:
> project. There is one central database and multiple clients that are
cynking
> data at the end of each business day. I have succesfully cynked the data
> when I have hard coded the server name and login information:
> SELECT *
> FROM KPATLDEV4.cea_msde.dbo.tblAccount
> I need the server name to be a parameter that is passed in (because of the
> multiple client servers), but there I havn't been able to figure out a way
> to do this yet. Any ideas?
> Thanks,
> Kevin