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
2
votes
0 answers

Finance Naming Policy ssms, Can't Create Tables error (ends in trigger)

I am getting the following error when I try to create even basic tables in any database in ssms 2012: Policy 'Finance Name' has been violated by 'SQLSERVER:\SQL\ACER-PC\DEFAULT\Databases\AdventureWorks2012\Tables\dbo.CustomersNew'. This transaction…
pdangelo4
  • 220
  • 4
  • 17
2
votes
1 answer

How add an existing SQL Server database to TFS source control?

I a working with VS, TFS and SSMS 2012. We use TFS source control for our source code solution. I've decided to add our database to source control as well. I tried different ways: Creating a new SQL project in VS, adding to source control,…
Fery
  • 471
  • 1
  • 5
  • 15
2
votes
1 answer

ssms hide (1 row(s) affected)

When running code, SSMS 2012 is writing (1 row(s) affected) into the messages window for every line in mydataset. This isn't unexpected (see details below) but is there any way to suppress these messages, while still getting important error…
Michael
  • 23
  • 2
2
votes
2 answers

Is this a SQL Server Management Studio bug?

I create a SQL Server 2012 Enterprise view thusly - CREATE VIEW [dbo].[vTest] AS WITH cte_LCH AS ( select *, Rank = ROW_NUMBER() OVER (PARTITION BY ClaimId ORDER BY Id DESC) from ClaimHistories where Status in (1,2) ) SELECT TOP…
Dave
  • 1,822
  • 2
  • 27
  • 36
2
votes
2 answers

SSMS Extensibility Project - howto research/debug

In the vein of this answer regarding creation of an SSMS Extension: namespace SSMSAddin { using System; using System.IO; using Extensibility; using EnvDTE; using EnvDTE80; using Microsoft.VisualStudio.CommandBars; using…
WernerCD
  • 2,137
  • 6
  • 31
  • 51
2
votes
1 answer

Confusion: Why SSMS creates a default clustered index for a primary key with an identity

I just executed the following script CREATE TABLE Test ( ID INT IDENTITY PRIMARY KEY, Info nvarchar(50) ) For my surprise, SSMS created a clustered index for the ID column. So, my question is why not a non-clustered index? From my…
System.Data
  • 3,878
  • 7
  • 32
  • 40
2
votes
0 answers

SSMS ADD IN : Status bar color

I'm writing a SSMS Add in (SQL 2012). I'm trying to change the status bar color but How ? The documentation is too poor and I have searched during hours. I'm blocked Here: TextDocument document =…
Aurelien Alderweireld
  • 21
  • 1
2
votes
1 answer

VS style snippets in SSMS 2012. Do they exist?

I am trying to setup a simple snippet in SQL Server management studio. When I heard the word "snippet", I assume that they would work like they do in Visual Studio. By that I mean that there are variables that get filled in, etc... I am not…
AngryHacker
  • 59,598
  • 102
  • 325
  • 594
1
vote
1 answer

SQL Server trigger to track annual revenue

I have a simple database with 4 tables: Customer (cusId) Newspaper (papId) SubCost (subId) Subscription (cusId, papId, subId) Newspaper has a column to track number of subscribers which is updated via a trigger on the Subscription table. It also…
Michael Carlson
  • 11
  • 1
1
vote
1 answer

Import & export database with all data in SQL Server Management Studio

I need to import a SQL Server database from SQL Server Management Studio. I'm using SSMS 18 for both the end. I want to export the whole database with all tables, columns, data and import with same. I tried few ways but that didn't help me. Hope…
Harsh Shah
  • 188
  • 2
  • 6
1
vote
0 answers

The semaphore timeout period has expired

I've tried to upload my records from excel to azure managed instance using Import Export Wizard SSMS 12. Below are the error I faced while upload the data. I tried 5 times to upload with using 5 same records. only 1 time the data inserted. another 4…
user12549357
  • 11
  • 2
1
vote
2 answers

Dynamic date case statement

I'm using SQL Management Studio 2012.I Have a query output like below. I would like to have a column that looks at the date completed and if it's greater that 2019-01-01 then the exam is'valid' if earlier then 'Renew'. It can't be a hardcoded…
Clem_Fandango
  • 254
  • 2
  • 18
1
vote
1 answer

Looking to be sure that errors get caught properly in my stored procedure

I'm looking to see if I am able to capture my errors correctly in this stored procedure: ALTER PROCEDURE [dbo].[sp_UpdateText] (@aID AS INT, @CompanyID AS INT, @CompanyName AS VARCHAR(MAX)) AS BEGIN DECLARE @Result VARCHAR(MAX) …
Koosh
  • 876
  • 13
  • 26
1
vote
3 answers

Need to concatenate to a field value, after checking if value [isnull]

I have a stored procedure where I'm pulling data from a table. The value in the field can either be NULL or a number value (ex: 15). I am hoping to display this value with a $, however I'm finding it a little hard to do that, since I'm checking if…
Koosh
  • 876
  • 13
  • 26
1
vote
2 answers

Adding text to code blocks in bulk on right side

I know you can use ALT + Mouse Select or ALT+SHIFT+Mouse Select to to insert text along the column of the scrip. This works well when you are adding something to the left side of the script, where everything is inline. Is there a way to do the same,…
jmich738
  • 1,565
  • 3
  • 24
  • 41
1 2 3
…
17 18