Share via

Run SQL Query in SSMS in Background (long-running query)

Anonymous
2024-12-13T16:33:16+00:00

I have to run a SQL query running in SSMS that will take a VERY long time to complete, however the SQL server is in an enclave where RDP sessions have a short time out, meaning that the RDP session gets logged off before the SQL query completes. Is there a way to kick this query off so that it will complete whether or not the RDP session is still logged on/active? Maybe create an SP and start it via SP?

PS: I chose "Windows Server" for the product since SQL server isn't a listed product.

Windows Server Performance and maintenance

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question. To protect privacy, user profiles for migrated questions are anonymized.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-12-16T00:58:04+00:00

    Hello

    Thank you for posting in Microsoft Community forum.

    Based on the description, I understand your question is related to the SQL Server.

    Since there are no engineers dedicated to SQL Server in this forum. in order to be able to get a quick and effective handling of your issue, I recommend that you repost your question in the Q&A forum, where there will be a dedicated engineer to give you a professional and effective reply.

    Here is the link for Q&A forum.

    Questions - Microsoft Q&A

    Click the "Ask a Question" button in the upper right corner to post your question and select "SQL Server" tag.

    Thank you for your understanding and support. If you have any question or concern, please feel free to let us know.

    Have a nice day.

    Best Regards,

    Molly

    0 comments