Questions tagged [sql-server-2012]

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

615 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
-1
votes
2answers
58 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
411 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
43 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
305 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
176 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
185 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
788 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
478 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
259 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
312 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
50 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
70 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 ...