Maybe you should change this line, inserting apostrophes:
'EXEC [USP_Delta_Test] ''ADS'', ''ADS'''
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I tried this code but got error
https://stackoverflow.com/a/29040625/9359783
SELECT *
INTO #temp
FROM OPENROWSET('SQLNCLI',
'Server=192.17.11.18;Trusted_Connection=yes;',
'EXEC [USP_Delta_Test] ADS,ADS')
select * from #temp
drop table #temp
Normally when executing SP like this way then getting data EXEC [USP_Delta_Test] 'ADS','ADS'
this is my server IP 192.17.11.18
please tell me what i need to change in my above code ?
Maybe you should change this line, inserting apostrophes:
'EXEC [USP_Delta_Test] ''ADS'', ''ADS'''
Hi @T.Zacks ,
Please refer a thorough list of troubleshooting methods that can be used to connect to the SQL server from below:
You could also refer more detailed steps in this article.
Best regards
Melissa
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.