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
3
votes
3 answers

SSMS shows up in taskbar but is invisible

I came across this very weird issue today. When I open SQL server management studio it shows up in the task bar but somehow it never appears on my screen, even when I do alt+tab to switch to SQL server window, it still shows up in the list of…
braceyourself
  • 227
  • 4
  • 20
3
votes
1 answer

Opening a SSRS project using Powershell

I have a report that is copied to a number of different servers. It is imported manually and the data source properties are altered to match the current server's specs. I would like to be able to automate the process by enabling users to open a the…
Michelle Santos
  • 257
  • 4
  • 20
3
votes
2 answers

How to get rid of cursors?

I have written a SQL query that uses cursors and I realized that it eats up too many resources on the server and it is also slow. So, this is the table: Source I need to calculate the time difference between Status = Assigned and Status = In…
Szekely Zsolt Karoly
  • 57
  • 7
3
votes
0 answers

SSMS 2012 crashes with mssqllocaldb table edit top 200 rows

SQL Server Management Studio 2012 mssqllocaldb database When I right click on a table and select Edit Top 200 Rows I get this error: TITLE: Microsoft SQL Server Management Studio Exception has been thrown by the target of an invocation.…
Joe
  • 4,143
  • 8
  • 37
  • 65
3
votes
2 answers

Default toolbars in SSMS 2012 (SQL Server Management Studio) at startup

I am running Windows 7 and Microsoft's SQL Server Management Studio 2012 (Version build 11.0.5058.0). I know that the available toolbars can be customized, but every time I close SSMS and reopen, it resets the default toolbar sets that I had showing…
Cameron
  • 31
  • 2
3
votes
2 answers

SSMS Intellisense is not consistent

I have a problem with my SSMS. For every 5 minutes of interval Intellisense is not working. Is there something wrong with my SSMS software or something wrong with the local server. I won't say it is not working but it is not consistent. Can anyone…
Pரதீப்
  • 91,748
  • 19
  • 131
  • 172
3
votes
1 answer

Greyed out Connection options in SSMS

I've run into an instance where I created a new query window, right-clicked to connect to a server and found the following options:
John Waclawski
  • 936
  • 1
  • 11
  • 20
3
votes
2 answers

Why does my SQL Server column appear to have no default value even though it acts like it does?

I have a SQL Server table that has four columns in it, one of which is a datetime column with a default value of getdate(). I have two copies of this table, one in a development database server over which I have full control, and another in a…
user2023861
  • 8,030
  • 9
  • 57
  • 86
3
votes
3 answers

SSMS status bar color bug

I tried to change the color of my status bar in ssms 2012 depending on the connection to registered servers. I registered the servers, checked "Use custom color:" in the connection properties and chose a color. Now when I open a new query editor…
bego
  • 99
  • 3
  • 9
3
votes
5 answers

How to search for a string/substring in SSMS results?

This seems pretty straightforward, but for some reason I'm not finding anything about how to do it. I'm using SQL Server Management Studio 2012, and I have a set of results returned from a SELECT query, say, select a,b from x. How can I search in…
sigil
  • 9,370
  • 40
  • 119
  • 199
3
votes
1 answer

SQL IF block code causing error even though it shouldn't execute

I have a case in which I have SQL code with an IF-ELSE block. The code in the IF portion should not be reached, but I still get an error when the SQL executes. In the code I first test for the linked server, and when that fails, @reval is set to 1…
RoastBeast
  • 1,059
  • 2
  • 22
  • 38
3
votes
2 answers

Option to change database compatibility level disabled in SSMS2012

I'm trying to use SQL Server Management Studio 2012 to alter the Compatibility level of a database, but the drop-down is disabled: Why is the option disabled? How do i enable it? I try manually changing it using T-SQL: ALTER DATABASE…
Ian Boyd
  • 246,734
  • 253
  • 869
  • 1,219
3
votes
1 answer

Start SSMS for SQL 2012 using CMD

I have installed SQL 2008 R2, and then I installed SSMS for that server. After a few months, I've installed SQL Server 2012 and its SSMS. Location of theese tools are different in file system, logically. But, when I type in CMD next command:…
veljasije
  • 6,722
  • 12
  • 48
  • 79
3
votes
1 answer

SQL Server 2012 Management Studio Intellisense not working over VPN

I am on a company laptop and intellisense works flawlessly while at the office. However, when I connect to the company network via VPN (using same comp laptop), I am able to see the various DBs and objects as well as query those DBs. The only thing…
alex.davis.dev
  • 411
  • 7
  • 18
3
votes
1 answer

Check if column is indexed

Is there a way in SSMS to check if a column is indexed? The reason I ask is because I am thinking of changing a varchar(500) to varchar(MAX) and have read that if the column is indexed then you cannot insert data greater than 900b. I want to make…
dav_i
  • 27,509
  • 17
  • 104
  • 136
1 2
3
…
17 18