# Is there a way to remove the connection to a specific server when using the history?

I sometimes run historical queries across different servers.  If I copy the query to a window instead of the clipboard, it will run it against the server I originally ran the query against.

##### Post Metadata
- Posted at: about 6 years ago
- Author title: Application Developer | Process Improvement | Data Analytics | Customer First Mentality



## Comments
### Comment 1

Could you please explain what you mean by "to remove the connection to a specific server"?

In the Execution History, you can filter the Server column so that only the required connections would be displayed.

At the moment, the execution history records cannot be removed; instead, filters should be used.

##### Comment Metadata
- Posted at: about 5 years ago
- Author title: PR Manager at Devart


#### Reply 1

I'm usually working in three SQL Server environments.  If I have SSMS open and run a query in Production, it's stored in History (no suprise).  If I open SSMS tomorrow and connect to my dev server, I may want to run that same query against my open connection (dev).  However if I go to history, and right-click the query and open in new window, it opens against my production server, and not the connection I'm actively on.  When I was new to SQL Complete, this almost got me because I was expecting the query to run against dev.

##### Reply Metadata
- Posted at: about 5 years ago
- Author title: Application Developer | Process Improvement | Data Analytics | Customer First Mentality

#### Reply 2

A similar feature that does the same thing is the open query feature, where when you launch SSMS it remembers the query windows you had open.  This feature is great, however I wish the connection could be made against the SQL Server instance I'm opening and not the instance the query was run against. So if I worked in Prod yesterday and had 5 windows open, I wish I could launch SSMS, connect to dev and have those 5 windows that open up for me pointed to dev.

##### Reply Metadata
- Posted at: about 5 years ago
- Author title: Application Developer | Process Improvement | Data Analytics | Customer First Mentality



## Related Product
[dbForge SQL Complete](https://www.g2.com/products/dbforge-sql-complete/reviews)

## Related Category
[Database Management Systems (DBMS)](https://www.g2.com/categories/database-management-systems-dbms)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4