Questions tagged as 'ssms'

Tagged questions
0
answers

SQL Management Studio only connects remotely without the instance

When trying to connect to a remote first SQL, I noticed that my Management Studio could not connect using the instance, as follows: Afterthisattempt,Iremovedtheinstance,andasthisserveronlyhasaSQL,ittookthedefaultsystem,andloggedinnormallywit...
asked by 04.10.2018 / 16:31
0
answers

SSAS Process.Add Calculated vs. Non-Calculated Partitions

I was trying to Process.Add my SSAS Database via TMSL following the instruction of this URL: ProcessAdd with TMSL Script    The JSON DDL request failed with the following error: Failed to   execute XMLA. Error returned: 'A Refresh reques...
asked by 20.06.2018 / 14:35
0
answers

Restoring database sql server management studio

I'm creating a development environment. I went into the production environment open the sql server management studio right click on the tasks database > do backup I came back in the development environment I opened sql server management studi...
asked by 09.08.2017 / 16:37
3
answers

Select first place first half only - SQL Server Code

I made this code for SQL Server to select how many times the pilot "AsdoVolante" came first in the first half of 2017. However, it does not work. What could be wrong? SELECT P.Data, Nm.Nome, epp.PosicaoFinal FROM Prova P, Piloto Nm, EquipaPart...
asked by 11.06.2017 / 02:45
1
answer

Question for SQL Server - Code [closed]

What are the names of the riders who did less than 1:12 on the 1st lap of the 2nd race? How can I make lap times? Will I have to make a new table? The SQL Server tables created were as follows: CREATE TABLE Carro( IdCarro INT NOT...
asked by 10.06.2017 / 16:28
1
answer

SQL Server Code for Question

After 1 hour back from this question I can not solve the code for it. Can someone help me? Question: "Please indicate the number of riders for each car brand" The SQL Server tables created were as follows: CREATE TABLE Carro( IdCarro INT...
asked by 10.06.2017 / 01:43
0
answers

The "Bank" database is not accessible. (ObjectExplorer)

I created a new windows 10 local account. With this new account I can not access the database. Because the old Windows 10 account was in trouble. This is why I created a new local windows account. (New user) Former local windows account was "...
asked by 25.05.2017 / 20:35
1
answer

Sql query formatting in just one line

In some cases, when we save a query .sql, even if it is indented correctly in SSMS when we open it in notepad (windows) all the text stays in a line only, joining END with GO (ENDGO) at the end of a change in procudere ( for example). How to...
asked by 09.01.2018 / 18:23