How to run a MSSQL Script against an unlinked server

I was trying to run a stored procedure against another server earlier, and therefore, I found that Microsoft provided a method called “OPENROWSET” to run a query from a server against another one. One important thing I learned is that this method will not support for query that returns an XML. I learned it the hard way, […]