SSMS - Automatically save SQL query result to a file

0 votes

0 answers

103 views

export

                          I use SSMS for SQL queries. I've find how to make JSON result with FOR JSON AUTO or FOR JSON PATH.

Now I want to schedule request result to a JSON file with MaintenancePlan.

How I can do that with SSMS, without bcp ?

Asked by David C. - ProServ (13 rep)

Nov 20, 2024, 12:02 AM
Last activity: Nov 20, 2024, 12:05 AM

SSMS - Automatically save SQL query result to a file

Related Questions