SQL Command - Can't find server 'XXXXX'

SQL Command - Can't find server 'XXXXX'

  

Hello,

I tried to write a sql command but face the error.

Error in advanced query SQL1: Could not find server' XXXXXX' in sys.servers.

Verify that the correct server name....

Could someone help it. Thanks a lot. 

Hi Howard,

Are you explicitly specifying a server, or is that database the default OutSystems database?

I use for default outsystems database. 

And everything else works fine? Like publishing, Aggregates etc.?

Yes, only when i do test command will face the error. 

Can you show the query you are trying to run? It seems that there is an error in the way you write your query.

The command as below


SELECT max({StockRequisitionHeader}.[SerialNumber]) from {StockRequisitionHeader}.[SerialNumber]
where {StockRequisitionHeader}.[SerialNumber] is not null