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

Cannot Open DataFile SSIS Package via SSMS

Background Created package in BIDS. Deployed to SSMS Package writes files to a CSV file in a network fileserver. The default name of the package's flat file destination is $path\workcsvout.csv Package derives filename from an expression Issue When I…
Hituptony
  • 2,740
  • 3
  • 22
  • 44
0
votes
0 answers

Running Sum in SSRS that Resets and Starts Resumming, With Remainder Once a Threshold is Reached

I;m looking to create a formula in SSRS 2008 for Bal_Toward_Thresh in the example output data I've provided. The "bal_toward_thresh" will allow me to sum up to a threshold ("Bal_Toward_Thresh") which is defined as a variable in my query(in the…
Calverzp
  • 1
  • 2
0
votes
2 answers

SQLCMD to import large sql file gives "Invalid object name" error

I am trying to import a large .SQL file (downloaded here) (210mb) containing postcodes in a table called postcodelatlng. This is the setup: I tried executing the query directly in SSMS 2012 but it's complains about the lack of memory. Further…
benscabbia
  • 17,592
  • 13
  • 51
  • 62
0
votes
0 answers

comparing two tables with identical columns using T-SQL in SQL server

Scenario: need to compare two different tables with identical columns and need to load the different records into a new table with date and table name from which they are loaded. Data is loaded again into one of the initial tables and are compared…
Nik0814
  • 1
0
votes
1 answer

BCP output file not getting generated

i am running below query in the ssms 2012. exec master.dbo.xp_cmdshell 'bcp uctconfiguration.dbo.requirement out D:\requirement.txt -w -T -S "servername"' Below is the log NULL Starting copy... SQLState = S1000, NativeError = 0 Error = …
G.S Abhaypal
  • 362
  • 1
  • 6
  • 17
0
votes
0 answers

Insert/Update Stored Procedure with Output Parameter

Background: I have a series of stored procedures that inserts one new record into 5 tables (all have a one-to-one relationship). Each stored procedure creates a unique ID for the related table. The last stored procedure adds all of those unique IDs…
alybaba726
  • 390
  • 4
  • 14
0
votes
1 answer

How do I update a table from a SELECT statement in SSMS 2012?

I have a table that I would like to update based on the results of a query. The table that I want updated is called dbo.CSL. The field I want to update is called dbo.CSL.PartType. How can I update this field based on the results of this…
tsqln00b
  • 355
  • 1
  • 4
  • 20
0
votes
1 answer

Running SSIS Package Remotely with SSMS Fails, Why?

Why running SSIS package locally on the server where MS SQL reside using SSMS works fine, but when I run the same SSIS package remotely on my pc using SSMS fails? The error message complains about the acquireconnection to connection manager failed.…
user2103970
  • 703
  • 3
  • 9
  • 15
0
votes
1 answer

How do i get the execution time of an View

I created a view for testing purposes and would like to see the execution time. But i was unable to find an option to do this could somebody please guide me how i could get this information.
WiiMaxx
  • 5,322
  • 8
  • 51
  • 89
0
votes
2 answers

Run SSMS 2012 as administrator Application can not start error

When i tried to run SSMS 2012 as administrator it gives the error "application can not start". I am using windows 8 64 bit and sql server 2012. Actually yesterday i tried to install ssms 2005 side by side installation but i stopped the installation…
Mohsin
  • 1
  • 3
0
votes
2 answers

How do I merge many similar tables?

I have many tables that all have identical structure and similar table names and am looking for a way to merge a few columns from them all into a new table with two additional columns: an auto-generated integer PK, and the name of the source table. …
Land Surveyor
  • 99
  • 1
  • 7
0
votes
1 answer

Accidentally enabled an autocomplete list which is slowing everything down

I was typing too fast and accidentally pressed some key combo which enabled this monstrosity: I still want local members to autocomplete as before, but this is overkill; it lists all available databases, tables, functions, etc. Disabling…
user928112
  • 483
  • 1
  • 6
  • 24
0
votes
2 answers

how to get the result set via multiple tables in stored procedure

In SSRS, i got only the result set of first table, and not the second table @ABC, is there any other way to get the values of X_Q, Y_Q and Z_Q IF OBJECT_ID('PrGetDetails') IS NOT NULL BEGIN DROP PROCEDURE PrGetDetails END GO CREATE PROCEDURE…
Kavr
  • 17
  • 10
0
votes
1 answer

Show only table name in SSMS 2012 Tab for table (edit all rows)

The tab name in SSMS 2012 is in the format : [SERVER_NAME.DATABASE_NAME - dbo.TABLE_NAME] Is there is any way that i could show the tab like [dbo.TABLE_NAME] only, so more tabs would apear instead of only 4 tabs in case of oppening tabs with Edit…
Hussein Khalil
  • 1,395
  • 11
  • 29
0
votes
2 answers

Error during exporting result to Excel using SQL Agent

I'm using SSMS 2012. I'm using Export wizard to run a script and export it to an Excel file. I'm saving this as a SSIS package in SQL server. Then, I try to schedule a job using SQL Agent to execute this SSIS package. I schedule it as a recurring…
Raja
  • 85
  • 1
  • 1
  • 7
1 2 3
…
17 18