<div>
you need to use double ' inside sql not triple '
</div>


you need to use double ' inside sql not triple '

<div>
Excellent! Now working. Thank you so &nbsp;much.
</div>


Excellent! Now working. Thank you so  much.

<div>
<div class="content wysiwyg-content">
Hi Expert,<br />
<br />
I have getting the following query syntax error. Please help.<br />
<br />
insert  into dbo.inventory <br />
SELECT * FROM OPENQUERY ( [Server-B], '<br />
&nbsp;select &nbsp;@@SERVERNAME as InstancName, Convert( varchar(50),<br />
SERVERPROPERTY('''Computer<wbr />NamePhysic<wbr />alNetBIOS'<wbr />'')) as [Machine Name], Convert( varchar(50),<br />
CONNECTIONPROPERTY('''loca<wbr />l_net_addr<wbr />ess''')) as [IP Address Of SQL Server], Convert( varchar(50),<br />
SERVERPROPERTY('''PRODUCTL<wbr />EVEL''')) as Product, Convert( varchar(50),<br />
SERVERPROPERTY('''EDITION'<wbr />''))as Edition, Convert( varchar(50),<br />
SERVERPROPERTY('''PRODUCTV<wbr />ERSION''')<wbr />) as Version,<br />
name as DatabaseName, create_date as CreateDate,<br />
compatibility_level, state_desc, recovery_model_desc as RecoveryModel, SUSER_SNAME(owner_sid) as Database_Owner<br />
from[master].sys.databases<wbr /> where database_ID &gt;&nbsp;4' )
</div>
</div>


Hi Expert,

I have getting the following query syntax error. Please help.

insert  into dbo.inventory 
SELECT * FROM OPENQUERY ( [Server-B], '
 select  @@SERVERNAME as InstancName, Convert( varchar(50),
SERVERPROPERTY('''ComputerNamePhysicalNetBIOS''')) as [Machine Name], Convert( varchar(50),
CONNECTIONPROPERTY('''local_net_address''')) as [IP Address Of SQL Server], Convert( varchar(50),
SERVERPROPERTY('''PRODUCTLEVEL''')) as Product, Convert( varchar(50),
SERVERPROPERTY('''EDITION'''))as Edition, Convert( varchar(50),
SERVERPROPERTY('''PRODUCTVERSION''')) as Version,
name as DatabaseName, create_date as CreateDate,
compatibility_level, state_desc, recovery_model_desc as RecoveryModel, SUSER_SNAME(owner_sid) as Database_Owner
from[master].sys.databases where database_ID > 4' )

T-SQL syntax error

T-SQL

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.