Stack Overflow
Stack Overflow

Questions tagged [ssms-2012]

Microsoft SQL Server Management Studio 2012

Microsoft SQL Server Management Studio (SSMS) 2012 is an easy-to-use graphical management tool for managing SQL Server 2012 Edition with Advanced Services.

The tool includes both script editors and graphical tools which work with objects and features of the server.

258 questions
0
votes
1 answer

Querying a SQL table column that contains JSON and updating a value in that JSON based on a condition

This table has about 1.5 million rows. A particular column contains JSON. What I need to do is query that column for that JSON and then query for a particular boolean key/pair "FLAG" in that JSON. If that "FLAG" is True, I'll need to update another…
mche
  • 616
  • 10
  • 16
0
votes
1 answer

Dynamic SQL not Capturing all Columns

I am trying to capture a set of columns, but the set can change depending on the data in question (it changes every month). Because of this, I am working on a way to capture the distinct values in the Service column, and put the column names…
PartyHatPanda
  • 712
  • 8
  • 14
0
votes
1 answer

Making SQL Server Management Studio use SQL Server 2016 instead of 2012

I was recently using SQL Server 2012 which was connected properly with my SSMS (SQL Server Management Studio). Then I downloaded SQL Server 2016 yesterday and installed it. Problem is, when I run SSMS, it opens up SQL Server 2012 instead of 2016.…
Timothy Macharia
  • 2,641
  • 1
  • 20
  • 27
0
votes
1 answer

Renaming database prefix to always be previous month

I'm using SSMS 2012 and trying to figure out a way to write a query so that my database name will adjust to the second to most current month. We have billing databases for every month that go like BillingMonth01206 and BillingMonth022016, as well…
TWaller
  • 81
  • 1
  • 7
0
votes
1 answer

SQL Date Parameter Using 2 Date Columns for SSRS Report

I have 3 columns,a reference number, a start date and an end date, These date columns are both in the dd/mm/yyyy format. I'd like to create a parameter in SSRS that allows the user to select a month (2016-07 for example) and it returns any dates…
Mike
  • 27
  • 1
  • 1
  • 5
0
votes
1 answer

SSMS 2012 - table designer doesn't show recently added fields

I cant see in table designer fields created via SQL script. If I add new field to designer it warns me about difference detections and lists all added fields via script Is there any way table designer to display all table's fields no matter if…
Maciej
  • 10,423
  • 17
  • 64
  • 97
0
votes
1 answer

Free SQL Server Management Studio memory usage

Is there a memory usage limitation for SQL Server Management Studio and is there a way to free SSMS memory without rebooting it? I am currently using SSMS 2012 and I always getting error message like below: 'An error occurred while executing batch.…
Ye Peng
  • 183
  • 6
0
votes
1 answer

Does each Instance in SQL Server have to have a specific instance based port number?

I am using SQL Server 2012. I found that, MSSQLSERVER is a default instance which has 1433 as a default port number. Now, I create a new instance named "INSTANCE1". "Do I have to specify separate port number for this instance or INSTANCE1 uses 1433…
Naresh
  • 47
  • 2
  • 10
0
votes
2 answers

Arithmetic overflow error converting to data type datetime

I am having issues with the formula below. The goal is to project a future date based on (CEIDAvgUsage-Usage/Burnrate). I have been searching for an answer for quite sometime and can find anything helpful. Either the expression im using is wrong or…
user5963760
  • 35
  • 4
0
votes
1 answer

Change selected instance in SSMS

In SSMS, each tab is related to an instance and a DB. There's a top left drop down where we can change the selected DB for current tab. But, if SSMS is connected to multiple instances, I don't see a way to change the selected instance of a tab. I…
Hikari
  • 3,797
  • 12
  • 47
  • 77
0
votes
1 answer

It is possible to get access to the SSMS Intellisense?

I'd like to add synonyms to the SSMS Intellisense. How can i get access to the standart SSMS Intellisense in my own Addin? Thanks in advance!
Evgeny Vorobyev
  • 111
  • 1
  • 2
  • 11
0
votes
1 answer

SQL Management Studio won't connect to TFS

I am doing some research regarding continuous integration with SQL servers. I downloaded some free trials of Red-Gate to play around with. However, I am having trouble getting my SQL Server Management studio to connect to TFS. The error I'm getting…
ARHassing
  • 23
  • 4
0
votes
1 answer

SQL query unique values based on 2 colums

I need help figuring this out. At the moment I have this query: SELECT Table1.Column1 AS Company ,SUM(DATEDIFF(Day, Table2.Column2, Table1.Column3)) AS DiffDate FROM Table1 INNER JOIN Table2 ON Table1.Column6 = Table2.Column6 AND…
SisU
  • 57
  • 1
  • 8
0
votes
2 answers

ssms.exe /resetsetting not a valid command

When I open SQL Server Management Studio 2012 running on Windows Server 2012R2 Datacenter in Azure I get the following error. "A problem occured while loading the Microsoft SQL Server Management Studio menu. To fix this problem run 'Ssms.exe…
h24601
  • 31
  • 1
  • 7
0
votes
1 answer

Why does SQL Server Management Studio hang (Not Responding) when connecting to Amazon RDS?

When I use SSMS to connect to a database hosted on Amazon RDS, the IDE hangs (as in goes to "Not Responding) after login. I enter SQL Authentication credentials and click Connect and the login window closes as it would for successful authentication.…
Boris Nikolaevich
  • 1,451
  • 11
  • 21
1 2 3
…
17 18