| Author |
Topic |
|
xcret25
Starting Member
2 Posts |
 Posted - 2011-08-23 : 00:00:13
|
| Hi...I have an issue. My computer using SQL 2005. and i want to create Link Server to Server that using SQL 2008. But the case is, in the server there are SQL 2005 and SQL 2008 installed. when i create the link server, the link server always connect to SQL 2005 by default. how to connect to the SQL 2008? thx |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-23 : 00:05:12
|
use full instance name
Youserver\sql2008instance
in linked server definition
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
|
xcret25
Starting Member
2 Posts |
Posted - 2011-08-23 : 01:30:59
|
Can you give an example?
I want to execute the store procedure like this
exec [(10.10.148.5)/SQL2008].itp.[dbo].[GetRouteEvent] 'B9543WP', 49, '8/16/2011 08:10:00','8/16/2011 08:15:00'
But [(10.10.148.5)/SQL2008] is error.
10.10.148.5 is my remote connection server.
Can you help me? |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2011-08-23 : 01:36:47
|
Use instance name in your linked server definition, not while executing proc. You need to execute the proc using linked server name. e.g.
exec LinkedServerName.itp.dbo.[GetRouteEvent] 'B9543WP', 49, '8/16/2011 08:10:00','8/16/2011 08:15:00'
Harsh Athalye
http://www.letsgeek.net/ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-23 : 02:06:07
|
and no need of () around ip
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
Bogdi
Starting Member
3 Posts |
Posted - 2011-10-25 : 16:42:30
|
Hi, ihave a question about linked servers.
Why if i run "select * from linked_server.master.dbo.syslogins"
i get ROLLBACK TRANSACTION in SQL Profiler? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-26 : 01:02:18
|
do you have any logon triggers enabled in your db?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
Bogdi
Starting Member
3 Posts |
Posted - 2011-10-26 : 12:01:42
|
| No, i don't have any logon trigger. |
|
|
|
Bogdi
Starting Member
3 Posts |
Posted - 2011-10-26 : 12:28:00
|
| I get the result of the select but I get the message ROLLBACK TRANSACTION. |
|
|
|
|
Link Server Issue