microsoft / microsoft/vscode-mssql

[Bug]: Disconnection from databases due to inactivity

Open
#21,703 1 comment 0 reactions 1 assignee Claimed by @Benjin View on GitHub
Area - Connection Bug User-filed
Dominant language
TypeScript
Stars
1.9k
Forks
610
Avg merge
2d 3h
Merged PRs (30d)
97

Description

### Description

The databases disconnect after a few hours, but they don't show up as disconnected. The error occurs because it doesn't allow you to update stored procedures, tables, etc.; it just stays in the “loading” state.

### Steps to Reproduce

1. Connect to an SQL database server that contains more than one database
2. Execute stored procedures while switching between databases
3. Leave Visual Studio Code idle for several hours
4. Try to update tables or stored procedures
5. When attempting to disconnect, it won't let you disconnect either

### Affected Area

- [ ] Connection dialog (SQL Server | Azure browse/Fabric browse)
- [ ] Query editor
- [ ] Query results panel
- [ ] Object Explorer
- [ ] GitHub Copilot integration
- [ ] Preview/Edit data
- [ ] Table Designer
- [ ] Schema Designer
- [ ] Schema Compare
- [ ] Local SQL Server Container provisioning
- [ ] SQL database in Fabric provisioning
- [ ] DACPAC/BACPAC export/import
- [x] SQL Database projects
- [ ] Query Plan Visualizer
- [ ] Other (please describe below)

### If you selected "Other", please describe the affected area

_No response_

### Environment Information

SQL Server (mssql) vcersion 1.41.0

### Confirmation

- [x] I have searched existing issues and couldn't find a match
- [ ] I want to work on this issue

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.