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

Design in Query Editor disabled for Azure databases

When I try to manage an Azure Database query in SQL Managements Studio 2012 I see that the "Design in Query Editor" option is disabled. It is enabled for other databases but not for Azure. Is there a way to enable it? Thanks
Osprey
  • 1,523
  • 8
  • 27
  • 44
7
votes
1 answer

Porting Visual Studio VSPackage to SSMS 2012 or 2014

I recently discovered an extension for visual studio that allows you to specify a watermark for the code window. This extension can be found on github here. https://github.com/nategreenwood/VSEditorBackgroundChangerExtension As part of a small…
RThomas
  • 10,702
  • 2
  • 48
  • 61
6
votes
0 answers

Why does this work in SQL Server? (@counter+++++ + 1)

Why does this kind-of work in SSMS and does not produce a squiggle or a run-time error? DECLARE @counter integer SET @counter = 42 WHILE @counter < 52 BEGIN set @counter = @counter++++++++ + 1 PRINT 'The counter is ' + cast(@counter as…
Alex Motz
  • 61
  • 2
6
votes
3 answers

Is there a way to favorite or star frequently-used tables in SSMS 2012?

80-90% of the time I spend in SQL Server Management Studio is spent dealing with the same 5 or 6 tables/views/stored procedures, out of the 100+ in some databases. It would be wonderfully helpful if there were a quick way to access those few…
friggle
  • 3,362
  • 3
  • 35
  • 47
5
votes
1 answer

T-SQL string email format issue

I am trying to build an email and have run into an issue. When the stored procedure runs, I get the following error message. Msg 14624, Level 16, State 1, Procedure sp_send_dbmail, Line 242 At least one of the following parameters must be…
joerdie
  • 379
  • 1
  • 6
  • 18
5
votes
0 answers

SSMS 2012 - Data Only Script Generation With If Not Exists

I would like to generate a data only insert script within SSMS 2012 which contain the if not exists statements to make the scripts idempotent. Right clicking the database I wish to generate the script for and selecting Tasks -> Generate Scripts the…
Jpin
  • 1,527
  • 5
  • 18
  • 27
5
votes
2 answers

DACPAC not including composite objects

I have a VS2012 database project which includes tables, stored procs, views etc. I then have a second database project which contains a database reference to the first project. I have ensured that the "Include composite objects" options is selected…
SmudgerDan
  • 413
  • 5
  • 16
5
votes
3 answers

SSMS 2012 System.OutOfMemoryException (client side) and SQL Prompt (debug info incl)

Some background: I've been encountering this memory exception within SSMS 2012 since it was released coupled with Red Gate's SQLPrompt (this exception never happens in my SSMS 2008R2 on the same laptop). I was originally encountering these…
artofsql
  • 613
  • 4
  • 11
4
votes
1 answer

BCP Login failed for user

Hi i am running below BCP query to fetch the data exec master.dbo.xp_cmdshell 'bcp "select top 10 ProductFamilyID,ProductSetID,ProductFamilyCode,ProductFamilyName from MPLA.dbo.tblLCFProductFamily" queryout D:\requirement.txt -w -T -S…
G.S Abhaypal
  • 362
  • 1
  • 6
  • 17
4
votes
3 answers

Unable to import/deploy database to SQL Azure: "The service objective (Business/Web) specified is invalid."

I'm trying to move my databases to a newer Azure subscription. I used to simply click "Deploy to Azure" on a local database from SSMS and have it deployed to a specified Azure server. Importing/Exporting a BACPAC file also works. However, I can't…
iamnobody
  • 646
  • 9
  • 23
4
votes
1 answer

SSMS Client Statistics: Total Execution time vs. Real Execution Time?

In the Client Statistics Window in Sql Server Management Studio, I get the total execution time. However, this time is often muss less then the time the query actually took. So what is the additional time spend for? For example, here I got ~5,6…
DanielG
  • 1,217
  • 1
  • 16
  • 37
4
votes
1 answer

Code Snippet - specify cursor position

Can I amend this code snippet so that when I use the snippet SSMSs cursor is at the end of the snippet ready for me to carry on writing the script?
whytheq
  • 34,466
  • 65
  • 172
  • 267
4
votes
1 answer

TFS 2012 and SSMS 2012

I have been trying for the last 12 hours to add items to a TFS Team Project using SSMS 2012, has anyone else experienced this issue? I am able to add items using SSMS 2008-R2 without any issues. In SSMS 2008-R2 when I wanted to create a new Project…
Mark Kram
  • 5,672
  • 7
  • 51
  • 70
3
votes
1 answer

Autocomplete table names are not showing up

My tables suggestions aren't populating when writing select statements. This only happens when I'm using my work VPN. How can I get the table name suggestions to appear? My thought was that it would be network related, but my internet speed is very…
Everett
  • 145
  • 2
  • 12
3
votes
3 answers

Get default value of stored procedure parameter

I have created below stored procedure with default value: CREATE PROCEDURE [dbo].[Sample1] @OrderID INT = 10285 AS SELECT ProductName, OrderID FROM Products P, [Order Details] Od WHERE Od.ProductID = P.ProductID AND…
Kavitha M
  • 263
  • 1
  • 7
  • 23
1
2
3
…
17 18