Thursday, March 29, 2012

drag and drop .sql scripts problem

In SQL 2000 we used to be able to drop and drag one or more scripts into a
query window with being prompted for a separate connection for each script
file.
Is there any way do stop MSSQL 2005 from prompting for separate login
credentials for each and every script?
Thanks.D. Haber (DHaber@.discussions.microsoft.com) writes:
> In SQL 2000 we used to be able to drop and drag one or more scripts into a
> query window with being prompted for a separate connection for each script
> file.
> Is there any way do stop MSSQL 2005 from prompting for separate login
> credentials for each and every script?
This is certainly a request often heard about Mgmt Studio.
The best workaround is to use Ctrl-Shift-P or Edit->Insert->File from
with the tool.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

No comments:

Post a Comment