Remember that the "Connect." button in Management Studio connects the object explorer, that would take your connection without letting you open another one to run the query. If you want to work with SQL Server Management Studio, use this: sqlservr -m"Microsoft SQL Server Management Studio - Query" For instance, to allow sqlcmd to take the connection: sqlservr -m"sqlcmd" Start SQL Server with the -m parameter, specifying the application name allowed to take the only available connection.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |