Tagged Questions

SQL Server Management Studio, a graphical front-end tool shipped with SQL Server for managing and querying databases. It also supports managing other bundled systems such as SSAS.

learn more… | top users | synonyms (2)

3
votes
1answer
82 views

How do you move a Database from one server to the other using MS-SQL-SMS

I need to move a database, but I want to make sure I do it safely and with all triggers, store proc and functions. I was think to simply detach the database from my server using MS-SQL-SMS and move ...
1
vote
1answer
1k views

Recovering from: A transport-level error has occurred when sending the request to the server in SSMS

Every now and than I loss the connection in SSMS and get the message Msg 121, Level 20, State 0, Line 0 A transport-level error has occurred when receiving results from the server. (provider: TCP ...
2
votes
1answer
169 views

Is there a way to load a sql script with a specified encoding into a running SQL Server Management Studio (SSMS)?

Just as the question says. I have scripts with 3 different encodings and feel offended by having to manually select of about 200 possibles I was never interested in. ( I didn't count them ).
6
votes
3answers
2k views

Specify Connection in Management Studio T-SQL Query

When adding users are roles to DB servers I often use the "Script this action" function from the GUI. I then just go to "Connection :: Change Connection" to do the same on my other servers. Is there ...
9
votes
4answers
3k views

SQL Server Management Studio for a remote database

With a SQL Sever database which is on a remote hosted dedicated server I can work using SQL Server Management Studio installed either on the same server or on my local computer. I the first case I ...
10
votes
6answers
730 views

Did anybody use sqlcmd mode in practice? [closed]

SQLServer 2005 introduced something called SQLCMD Mode msdn link. At first glance this mode adds variable subsitution from command line batch files, and some escaping to OS commands. Is this ...