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

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 ...

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)

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?

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...

How to connect to a database on the website pythonanywhere using SQL Server management studio?

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?

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.

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?

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?

SQL Managment Studio. Is it possible to search across all tables ? Don't see that functionality at all.