Questions tagged [Microsoft SQL Server Management Studio] (20)

2
answers

MS SQL Server 2017, what to install?

Decided to install MS SQL Server and start exploring the database, but I'm already on the third day and I can not install this SQL Server. Somewhere says you need Visual Studio, in VIDOS on YouTube just showing the SQL Server installation, but do not show what additional components are needed to actually run this Wednesday ...
candice.F asked March 24th 20 at 10:50
1
answer

How to display the MS SSMS 18?

Write a simple representation of the typecreate view as select view_1_sql kod_filii, nazva_filii, adresa_filii, cout_of_agents from Artemenko_291_main.dbo.Filia and it does not appear in the thread View.... But when it re-writes that such a representation already exists. When you create a view using the designer all right)
German.Ullrich asked March 21st 20 at 12:21
1
answer

How to debug in SSMS 18?

In SSMS, version 18.0, 5 pre-release version, no debug. The launch of hot keys is also missing. Someone faced with such problem? This version was cut/put off debugging?
rebeca5 asked March 19th 20 at 18:56
1
answer

How to display intermediate prints when you run a large script in MSSQL MS?

There is a great script that shovel a lot of data. I wanted to see the steps in this script, which added in the right places prints with the date, but when you run this script in the Studio all the results are displayed after execution of the query. I.e. if the script runs for 5 minutes, then print step, which was performed...
johnny_Hoppe13 asked March 19th 20 at 09:31
2
answers

How to connect to the database in pythonanywhere?

How to connect to a database on the website pythonanywhere using SQL Server management studio?
Lindsay.Orn asked March 16th 20 at 21:46
1
answer

How to present the query result as text?

Good day, there is a need to provide a query result as text, not every time remember that you have to press CTRL+T, or the icon on the taskbar. Is there an equivalent in the form of code, something like set dateformat dmy for dates. For that would just click run and not to think every time about this?
general.Sawa asked March 13th 20 at 17:15
1
answer

Where can I find a template of the script in Microsoft SQL Managment Studio 2008?

Tell me how to customize the template Microsoft SQL Managment Studio 2008 to team "Select 1000 rows" (/****** Script for SelectTopNRows command from SSMS ******/). Searched the whole Template folder, but was never found. Thank you.
Solon.Zeml asked October 7th 19 at 15:06
1
answer

MSSQL backup import?

Trying to restore MSSQL backup (.bak) server 17Gb, I pisep Management Studo that the restriction of the license in 10Gb. What license, if MSSQL free?
lilla_Boy asked September 26th 19 at 21:09
3
answers

How to login to MSSQL after installation?

Installed MSSQL Server 2008 Standard, run Managment Studio, it requires to enter a username and password. And where it to take if I was not even asked to create one during the installation?
lilla_Boy asked September 26th 19 at 19:22
4
answers

How to search a string in all tables in MSSQL?

SQL Managment Studio. Is it possible to search across all tables ? Don't see that functionality at all.
lilla_Boy asked September 26th 19 at 19:04