SSMS: open .sql file always towards a server ?

Question

SSMS: open .sql file always towards a server ?

SqlServerPass

SSCommitted

Points: 1709
More actions
June 12, 2012 at 11:52 pm

#257793

Is there a way to open a .sql file in SSMS always towards a particular sql server instance.
because, when i open a new .sql file, by default it assumes a connection which i was working with a previous .sql file.
this some times prone to mistakes in fetching wrong data (like SELECTed from DEV instead PROD).
Appreciating your help always.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

gsc_dba SSCertifiable Points: 5407 More actions · Answer 1

SQL Tab Magic from Red Gate remembers the connection and database name...:-D

http://www.red-gate.com/products/sql-development/sql-prompt/entrypage/sqltabmagic?utm_source=google&utm_medium=cpc&utm_content=unmet_need&utm_campaign=sqltabmagic&gclid=CNfFxpXqyrACFcUmtAodaC8OVg

gsc_dba

Cath Trimble SSCarpal Tunnel Points: 4201 More actions · Answer 2

Not quite what you're after, but right click over the toolbar in SSMS and select Customize. On the Commands tab select File. There is an option Open File with New Connection which you can drag on to the toolbar.

David Atkinson Ten Centuries Points: 1128 More actions · Answer 3

SQL Mad Rafi (6/12/2012)
Is there a way to open a .sql file in SSMS always towards a particular sql server instance.
because, when i open a new .sql file, by default it assumes a connection which i was working with a previous .sql file.
this some times prone to mistakes in fetching wrong data (like SELECTed from DEV instead PROD).
Appreciating your help always.

If you go to File/New/Project and add a SQL Server Scripts project, scripts held in this will be associated with a connection. Is this more or less what you're looking for?

SqlServerPass SSCommitted Points: 1709 More actions · Answer 4

David Atkinson (6/13/2012)
SQL Mad Rafi (6/12/2012)
Is there a way to open a .sql file in SSMS always towards a particular sql server instance.
because, when i open a new .sql file, by default it assumes a connection which i was working with a previous .sql file.
this some times prone to mistakes in fetching wrong data (like SELECTed from DEV instead PROD).
Appreciating your help always.
If you go to File/New/Project and add a SQL Server Scripts project, scripts held in this will be associated with a connection. Is this more or less what you're looking for?

Yes. Great.

Thanks a lot David.

This is what i looked for, that the .sql file that i added under 'Queries' folder remembers the connection which i set with it once. when i am opening the project again, each script file opens with its own connection which i set.