<div>
You need to create a linked server first, then only you can use the 4 part names , you can enclose the names of the sever, db within [] <br />
[LinkedServerName].[Databa<wbr />sename].db<wbr />o.Database<wbr />table 
</div>


You need to create a linked server first, then only you can use the 4 part names , you can enclose the names of the sever, db within []
[LinkedServerName].[Databasename].dbo.Databasetable

<div>
create a mapping on the db<br />
<br />
as ip, linkname and use this table to construct your sql, @sqlStatement, and use:<br />
<br />
exec sp_executesql @sqlStatement
</div>


create a mapping on the db

as ip, linkname and use this table to construct your sql, @sqlStatement, and use:

exec sp_executesql @sqlStatement

<div>
<a href="http://doc.ddart.net/mssql/sql70/oa-oz_5.htm" rel="ugc">http://doc.ddart.net/mssql/sql70/oa-oz_5.htm</a>
</div>


http://doc.ddart.net/mssql/sql70/oa-oz_5.htm [http://doc.ddart.net/mssql/sql70/oa-oz_5.htm]

<div>
&gt;cant you use ip for linked name and use siomething like this<br />
<br />
But he nee dto create the linked server first 
</div>


>cant you use ip for linked name and use siomething like this

But he nee dto create the linked server first

<div>
See if OPENROWSET(), OPENDATASOURCE() and/or OPENQUERY() work for you?
</div>


See if OPENROWSET(), OPENDATASOURCE() and/or OPENQUERY() work for you?

<div>
does that work without creating the linked server 
</div>


does that work without creating the linked server

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am writing a stored procedure which inturn calls many store proc from different servers. <br />
<br />
I can use something like DatabaseServerName.Databas<wbr />ename.dbo.<wbr />Databaseta<wbr />ble and it works.<br />
<br />
Now i want to use IP instead of databaseservername, something like<br />
100.10.2.3.Databasename.db<wbr />o.Database<wbr />table it fails with an exception...<br />
<br />
Line 7: Incorrect syntax near '100.10'.<br />
<br />
I know i am not prefixing the IP in a proper way...can anybody suggest a proper way to use?<br />
<br />
Thanks,<br />
Rithesh
</div>
</div>


Hi,

I am writing a stored procedure which inturn calls many store proc from different servers. 

I can use something like DatabaseServerName.Databasename.dbo.Databasetable and it works.

Now i want to use IP instead of databaseservername, something like
100.10.2.3.Databasename.dbo.Databasetable it fails with an exception...

Line 7: Incorrect syntax near '100.10'.

I know i am not prefixing the IP in a proper way...can anybody suggest a proper way to use?

Thanks,
Rithesh

How to use IP address when calling a SQL Store Procedure

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.