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

Calling a stored procedure (A) from stored procedure (B) and using the result set form A in B

In SQL server 2012 I am looking for a way to call a Stored Procedure (A) from stored Procedure (B). SP A returns a result set that I then will need to use in SP B. Is this possible?
tbdevmanager
  • 373
  • 5
  • 15
0
votes
3 answers

SSMS not releasing system memory

I just started at a new office as a Data Analyst. The job entails upgrading client systems from our dbase platform to our new RDBMS. The actual conversion is handled by some in-house software that is a black box to me but at the end of the…
Oliver
  • 167
  • 8
0
votes
2 answers

Connection string for a localhost SQL Server instance on a different machine in the same network?

I'd like to connect to a local instance of SQL Server on another machine within the same network, and am wondering if it's even possible. For example, say we have Machine01 and Machine02, both on the same internal network. I have several IIS…
BenR
  • 2,791
  • 3
  • 26
  • 36
0
votes
1 answer

return best value found for query in N seconds

I have this query: SELECT MAX(LEN(MyColumn)) FROM MyTable But there are many rows and no index on the column. Is there a way to get the highest MAX(LEN(MyColumn)) found in N seconds instead of the absolute maximum?
user1151923
  • 1,853
  • 6
  • 28
  • 44
0
votes
1 answer

DMX processing Mining Structure Error

I have a problem while processing mining structure... This is my Mining Structure CREATE MINING STRUCTURE [QUESTION1] ( [ownerReviewID] LONG KEY, [makeName] TEXT DISCRETE, [modelName] TEXT DISCRETE, [price] LONG CONTINUOUS, …
Tuzki
  • 493
  • 2
  • 11
  • 20
0
votes
1 answer

T-SQL 'Cannot insert the value NULL' error with non-NULL values

I'm migrating a Simple Membership database to Identity 2.0. I'm copying a CreateDate datetime NULL column to a CreateDate datetime NOT NULL column. I've examined all the records in the Membership.CreateDate column in the data source table to verify…
Joe
  • 4,143
  • 8
  • 37
  • 65
0
votes
1 answer

SSMS database diagram

I have an sql database with more than 50 table. I have worked for the past two days creating relationships on my local server, and now need to export that diagram to the server. is this possible at all? I am using sql server 2012 express.
Afroman Makgalemela
  • 690
  • 2
  • 8
  • 21
0
votes
1 answer

Can't generate scripts from LocalDB in SQL Management Studio

I can't export scripts from my LocalDB database (localdb)\v11.0. (SQL Express is fine) The error I get is Save or Publish Scripts Report Getting the list of objects from 'XXX'. Failed System.IndexOutOfRangeException: Index was outside the…
Tom
  • 12,591
  • 13
  • 72
  • 112
0
votes
4 answers

how to do a search and replace for a string in mssql 2012

I am having to find and replace a substring over all columns in all tables in a given database. I tried this code from sqlserver 2012 ssms but resulting in errors from…
glant
  • 479
  • 6
  • 19
0
votes
2 answers

Filters in SSMS2012

This is not a technical question All I want is to know whether there is a filter option in SQL Management Studio. Which can be used to query through the tables and records without user typing the whole query in query editor I had seen the same in…
Sreenath Ganga
  • 696
  • 4
  • 19
  • 48
0
votes
1 answer

intellisense for columns in ssms 2012 doesnt work in the body of a stored proc

When I am composing a stored procedure in SSMS 2012, I am not getting intellisense. I am connected using ssms 2012 to a remote instance of sql server 2012. But i am not getting the wonderful intellisense that I was used to in ssms 2008 R2. It…
Jay Jay Jay
  • 1,970
  • 2
  • 25
  • 47
0
votes
1 answer

My DAC files extracted from SSMS have a file type in Spanish

I do a lot of schema compares in my work. I've started extracting DAC files from the databases using Tasks --> Extract Data-tier Applications in SSMS, then doing the schema-compare in Visual Studio. That part works great! Much better that saving and…
Michael McCormick
  • 304
  • 3
  • 11
0
votes
1 answer

Add case Statement to large query to allow result set to be more dynamic

I have the following MS SQL query using SSMS 2012. I've been fine tuning and tweaking this for a while. You can learn more about it here. CASE statement in monster query WITH Data AS ( SELECT b.ReportHeading1, p.DisplayOrder, …
Jay C
  • 842
  • 6
  • 17
  • 37
0
votes
2 answers

How to change the text in textbox with change of selected item in combobox?

I have a combobox cmbCity and textbox txtReference. At the form load the combobox retrieves the cities from database which I managed to do. I want the textbox to change the refrence no. stored in database with change of selected city in combobox for…
umuieme
  • 729
  • 6
  • 20
0
votes
0 answers

SQL Server Management Studio 2012 - Right-click to SELECT TOP 1000 ROWS not available. Properties option not available when right-clicking a login

I have just moved from SSMS 2008 to SSMS 2012. In 2012, I can not right-click on a table and "select top 1000 rows", nor can I "edit top 200 rows". This is despite having the valid settings in 'Tools -- Options -- SQL Server Object Explorer'. (Value…
John Lowry
  • 1
  • 1
1 2 3
…
17 18