I think I explained myself incorrectly. I want to do this in a SQL Query.

I have a 3rd party application that allows me to run SQL against the database that pulls back results for anlaytical purposes. I have created SPs within the database and simply use the EXEC command from the query windows within this application.

Unfortunately, the application does not allow me to change the Application Intent = Read Only. So the quetion remains, am I able to achieve this in T-SQL?

Thanks for you reply.