sql server2005，如何新建键接服务器？
sql server2005链接至sybase.
查了一下联机帮助，没找到详细的新建键接服务器的资料，求助大家，谢谢．

------解决方案--------------------

--Sybase
EXEC sp_addlinkedserver 
@server = '<LinkedServerName>',
@srvproduct = '', 
@provider = 'MSDASQL', 
@provstr = 'Driver={Sybase System 11};Database=<DatabaseName>;Srvr=<ServerName>;UID=<UserName>;PWD=<Password>;'

------解决方案--------------------
--Sybase
OPENROWSET('MSDASQL','Driver={Sybase System 11};Srvr=<ServerName>;Database=<DatabaseName>;UID=<UserName>;PWD=<Password>',{[catalog.][schema.]object|'query'})
OPENDATASOURCE('MSDASQL','Driver={Sybase System 11};Srvr=<ServerName>;Database=<DatabaseName>;UID=<UserName>;PWD=<Password>')