Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [sql-server-2012]

SQL Server 2012 (major build version 11.00.xxxx). Please also tag sql-server.

625 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
1answer
224 views

SQL Server 2012 - login mapping to user

I'm still struggling a bit in moving from Oracle to SQL Server, especially with the login-vs-user thing. I've restored a database from a client site so we can have a development copy. I want to set ...
0
votes
1answer
171 views

Best approch to replicate data from one db to other db on same server

I am facing issue of time out and slow data response so I did search on Google and found that I could create a server which replicates main database data to secondary database and both on same server ...
0
votes
1answer
626 views

Issue in installing SSIS MS-SQL2012

While installing the MS SQL Server 2012 Enterprise Edition, everything goes through fine but I'm not able to install Integration Services alone. I get the error as following: The following error ...
0
votes
1answer
7k views

SQL Server 2012 - The application has failed to start because its side-biy-side configuration is incorrect

When opening Sql Server Management Studio I'm getting the following error message: Then when I have a look at the Event Viewer the following message is displayed related to this: Activation context ...
0
votes
2answers
1k views

Error cs1567 while installing ms-sql on windows 8.1

I tried to install sql server 2008 and 2012 on my windows 8.1 laptop, but at both times I faced with the same error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the ...
0
votes
2answers
1k views

Only one simultaneous connection per user?

I'm currently experiencing some trouble, seemingly because my application refuses to connect to the database if there is already another connection open from the same user (but in a separate process). ...
0
votes
2answers
254 views

Need to maintain transactional consistency of the data across both servers, need to achieve these goals without manual intervention

I got this question about MS SQL Server 2012 administration, two production servers in the same data center. You need to ensure that database remains available if a catastrophic server failure or a ...
0
votes
1answer
1k views

Scheduled Job Succeeds, Does Nothing; Manual Job Succeeds, Performs Requirements

I have a job in SQL Server Agent (2012 Instance) that deletes rows from a table. When I manually run the job, it succeeds without issue and in reviewing the table, does exactly what I want it to do. ...
-1
votes
1answer
40 views

Problem adding a replica to an Availability Group

I'm getting an odd problem in trying to add a replica to an AG. This is part of a POC project to upgrade a 2-node AG running on Windows 2012 and SQL Server 2012 to a new 2-node AG running under ...
-1
votes
1answer
706 views

Oracle Linked Server in Azure SQL Database Managed Instance

I am migrating my On Premise SQL Server to Azure SQL Database Managed Instance. But I have linked server to Oracle database in my SQL Server. Can we create linked server to an On Premise Oracle ...
-1
votes
2answers
59 views

Join 2 tables by using id in the first table and DB name in the second table and update the name in the second tables

Join 2 tables by using id in the first table and DB name in the second table with the matching string and update the name in the second tables. Please help me if it is possible. Thanks
-1
votes
1answer
448 views

module_end extended event enough for stored procedure logging?

Using extended events I plan to capture stored procedure executions particular the time of execution, duration and who executed it. Is the module_end event enough to capture this data? In a test ...
-1
votes
2answers
44 views

I have create new login and I have to map same login to three different databases

I have create new login and I have to map same login to three different databases but default database language need to be set to British English how to do this can anyone help me??
-1
votes
1answer
321 views

Installation/Configuration Error Installing 2012 SSRS Native Mode

I believe I properly installed Reporting Services for SQL Server 2012 Developer edition however I get a HTTP 500 error when attempting to view the report viewer or manager URLs in both IE 10 and ...
-1
votes
1answer
178 views

AlwaysOn Multi-Subnet Setup

Without using SAN-to-SAN replication, how does data synchronization occur across subnets in a multi-subnet AlwaysOn (AVG) configuration? I want to setup a separate VLAN (replica lan) to synchronize ...
-1
votes
1answer
40 views

cannot consistently view or drop a trigger

I have a database trigger called ddl_refresh_views that provides dynamic binding for views (if you alter view V, it refreshes all the views dependent on V, and all the views dependent on those views ...
-1
votes
1answer
187 views

on every row on SELECT Query must lookup to other table

I'm working on Login/Logout System and I'm facing this problem regarding on SELECT Query. I have 2 tables namely dtr_tbl and shift_tbl. In dtr_tbl are the logs of the user(login/logout time details) ...
-1
votes
1answer
853 views

How can I register an SSRS server in SSMS and connect to it?

Under the Registered Servers window, I switched to Reporting Services and created a new server registration. By way of trial and error I figured that the Test button would succeed if I entered http://...
-1
votes
1answer
487 views

SQL Server Memory Cap reached its maximum state and threw an Out Of Memory Exception

We have set a memory cap limit of 43GB in SQL server instance, so thereafter it keeps 42 GB near about and keeps near about 1 GB for its processing operations. But then we received near about 500,000 ...
-2
votes
1answer
293 views

NVARCHAR(MAX) to datetime conversion (SQL SERVER 2012)

I have a table in which a column is nvarchar(Max) and date value is stored as for eg: 'Tue Aug 22 00:00:00 PDT 2017' How do I convert this value to proper datetime value I tried Try_Convert, ...
-2
votes
1answer
351 views

Optimize a query using same temporary table in outer apply

I have a query using outer apply on the same temporary table again(written by someone long back). It is performing very slow.Please suggest ways to improve. Thanks in advance. UPDATE fb ...
-2
votes
1answer
43 views

SQL Server 12 Instance / server name change

I created a sql server instance and the name show up differently in test and prod. How can i change the prod name to not have the names repeating ? Prod : select @@servername EHCPSQL12\EHCPSQL12 ...
-2
votes
1answer
51 views

Design for table

I have a table: TABLE ( A int, B int, ..., H int, DataValue float ); All of my queries do aggregate operations, with A and some other columns (several combinations) in the WHERE clause (A is ...
-2
votes
1answer
43 views

when adding a table to my dbo.view I don't get the entire view

here is the code for my view that calls all rows from the tables: SELECT dbo.Purchase_Order.Purchase_Order_ID, dbo.Purchase_Order.Purchase_Order_Number, dbo.Purchase_Order.Purchase_Order_Date, dbo....
-2
votes
1answer
71 views

how to select column3 from rec1 value which is matched to column1 val in rec2

i am having following scenario : col1 col2 col3 10 2 13 13 4 14 14 5 15 15 6 16 form the above given table col3 value(13) in row1 is seen in col1 value(13) in row2 ...