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
1 answer

How to automate daily scripting process and backup result to Excel

I'm using SSMS 2012. I'm running set of SQL scripts on a remote desktop on a daily basis and backing up the data to an Excel spreadsheet. I would like to automate the process where the SQL scripts are executed automatically and the results are…
Raja
  • 85
  • 1
  • 1
  • 7
0
votes
1 answer

SSMS crashing when opening SSIS in SQL Job Agent

Using SQL Management Studio 2012, When opening SQL Job Agent -> Open a job -> Wanting to edit a SQL Integration Services Package -> SSMS crashes and comes with this error message: TITLE: Microsoft SQL Server Management Studio The type initializer…
AceAlfred
  • 1,111
  • 3
  • 21
  • 35
0
votes
2 answers

SSAS : Last 12 months data from cube returning NULL

I run this query in SSMS 2012 SELECT YTD([Date].[Calendar].[Month].&[2003])ON 0 FROM [Adventure Works]; I am getting this error Executing the query ... Obtained object of type: Microsoft.AnalysisServices.AdomdClient.CellSet Formatting. Cell…
Ameya Deshpande
  • 3,580
  • 4
  • 30
  • 46
0
votes
0 answers

I have SQL server name and DTS packages name. How can I view it in SQL Server Managment Studio 2012?

I need to know, where I can see these packages under SSMS 2012 while connecting to server where DTS packages are actually stored. As this is first time I am going to play around DTS packages so not sure what server type (databse engine, integration…
user948401
  • 31
  • 6
0
votes
1 answer

TFS in Visual Studio and SQL Server Management Studio

I got a project which includes both a windows service (a C# project/solution in VS2013) and some SQL scripts (a SQL Server Script project/solution in SSMS 2012). Both of these use TFS as source control. The strange thing is that pending changes…
adrianm
  • 14,468
  • 5
  • 55
  • 102
0
votes
0 answers

There is lock on the table which persists the disconnection

I have a very small table in my database with only one row in it. When I do select statement on it, my query always times out. I have tried following things: Conecting/disconnecting from the database server doing select * from table(nolock)- which…
Lost
  • 12,007
  • 32
  • 121
  • 193
0
votes
0 answers

SSMS new data is not showing

I am using SSMS 2012 express and I have got into some case, maybe you can help me. I am running a simple script like: select * from table. The table gets new data every day by some service. But I can see the new data only if I would reconnect to…
Serg
  • 103
  • 1
  • 1
  • 6
0
votes
1 answer

Subquery or Unions for adding more strict conditions?

I have some rows that are coming up that I want to exclude My Code: SELECT DISTINCT T1.FILENUM, T5.OFG, T4.UN FROM T1 LEFT OUTER JOIN T2 ON T1.ID=T2ID LEFT OUTER JOIN T3 ON T1.ID = T3.ID LEFT OUTER JOIN T4 ON T3.ID=T4ID LEFT OUTER JOIN…
user4187073
0
votes
2 answers

comparing a row and including the null

I have a column that has numbers like this p123 p139 d291 c9384 p393 null null c148 I want to compare this column where it says it includes only the p and null values. My code is: WHERE (COLUMN NOT LIKE 'C%' AND COLUMN NOT LIKE 'D%' OR COLUMN IS…
user4187073
0
votes
2 answers

SSMS Searching for a Column

How do I look for a certain column in a Database with 100+ tables? For instance, in the frontend, I see a tab with displayed data.. A information with columns = email's, mailbox, note1, sent dt/tm, note2 etc.. but in the DB there are about 100+…
user4187073
0
votes
2 answers

Not able to create folders in integration services catalog SQL Server 2012

Not able to create folders in integration services catalog SSIS 2012 Error:
Sandeep Pulikonda
  • 774
  • 3
  • 13
  • 26
0
votes
2 answers

SQL left outer join with nested select optimisation

I am querying SQL Server 2012. I have a left outer join onto a large result set, that looks like the following: Data LEFT OUTER JOIN ( SELECT MemberID ,MIN(Date) FROM Tables GROUP BY MemberID ) T ON…
MattMcGowan
  • 117
  • 1
  • 6
0
votes
1 answer

How to alter the SQL output messages

I have multiple INSERT / SELECT statements as part of a single SQL data import script. When I run my script I get the output (141926 row(s) affected) (124366 row(s) affected) (4 row(s) affected) (1 row(s) affected) But what I would really want…
Kye
  • 5,919
  • 10
  • 49
  • 84
0
votes
0 answers

How to remove duplicates in spatial database?

I don't have much experience in work with Spatial Database and want to ask, how can I check for doublets in spatial DB ? Is it possible to do it with SQL? How to check polygons geometry?
user3486513
  • 29
  • 1
  • 5
0
votes
2 answers

How to use find and replace wildcards in SSMS?

So I have something like: Price1 Price2 Price3 And I'd like to do a Find and Replace on them so the end result is this: COALESCE(Price1, 0) COALESCE(Price2, 0) COALESCE(Price3, 0) I tried using this: Find what: Price. Replace with:…
dotnetN00b
  • 5,021
  • 13
  • 62
  • 95
1 2 3
…
17 18