Questions tagged [sql-server-2012]

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

631 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
22 views

Microsoft SQL Server 2012 Audit Problems

I have a current audit in MS sql server 2012 that is set up with the following audit properties: queue delay : 1000 milliseconds on audit level failure: continue audit destination: file file path C:\...
1
vote
0answers
96 views

Testing Data Compression

We have a 1TB table that gets queried a lot. I have suggested we use Data Compression to save on space as well as help put more in memory. Because of the concern of CPU overhead, I have been tasked ...
1
vote
0answers
33 views

File Extensions are missing from new SSMS 2012

One of my colleagues SSMS recently got updated to 2012 version from SSMS 2008 R2. After that they are view only a few editors in SSMS for adding different File Extensions Tools ==> Options ==>Text ...
1
vote
0answers
142 views

SQL Server Agent Alert does not pick up some of Events from Application Log written by SQL Server Audit

My end goal is to be emailed when new object (schema, table, procedure etc.) is created / altered / dropped at one of my databases on SQL Server I created a server-level audit, that writes to Windows ...
1
vote
1answer
433 views

Mirroring on-premise SQL Server to AWS EC2 SQL Server

Trying to mirror an on-premise SQL Server instance to EC2 instance, but not much information is available on this topic. The closest one I managed to find is: Implement SQL Server High Availability ...
1
vote
0answers
218 views

Why isn't prod level updated after applying SP - SQL 2012

My environment is SQL Exp 2012 | SELECT @@VERSION = 11.0.2100.6 (RTM) I then installed SP4 + GDR with no errors. Now, SELECT @@VERSION = 11.0.2100.6 (RTM). I would have expected 11.0.7462.6. ...
1
vote
0answers
244 views

SQL Server with peer-to-peer replication migration from on-prem to AWS EC2 instances

I need to move three on-prem servers with peer-to-peer replication to AWS. SQL Server version is 2012. The AWS SQL Server will be on EC2 instances as the SQL Server RDS doesn't support replication yet....
1
vote
0answers
549 views

Create BCP Format File From SSMS

I want to create a BCP format file from within SSMS. Is there anyway to do this? All the sources are asking to use the BCP command line. I would rather utilize in SSMS window. https://docs.microsoft....
1
vote
0answers
44 views

Restricting users to execute queries that bloat up tempdb

we have many a times faced a scenario where bad queries using tempdb just bloats up this system database filling 700 GB of tempdb in like couple of hours. I know there is a scope to tune them up. But ...
1
vote
1answer
143 views

Log Shipping Server Restart Problem

I have Log Shipping setup from Primary Server A to Destination B. Server B is both Destination and Monitoring server. Yesterday, we restarted both servers around the same time for patching. On the Log ...
1
vote
1answer
35 views

Can I add 1 primary node in existing cluster?

I have a 2 node windows 2012 cluster and SQL Server 2012 installed on both. In this I have added a database on nodeA as primary and one on nodeB as secondary. I want to add more 2 databases which will ...
1
vote
0answers
601 views

Sqlserver cannot write large text to excelfile with ACE, using IMEX=1, result=object is read-only

I have a table Test with column id (int) and column label (varchar(512)) and an excelfile test.xlsx with sheet test and the two columns. I use the ACE-provider to write from sqlserver to the excelfile....
1
vote
0answers
463 views

SQL Transactional Replication - some tables frozen, but others working fine

Background We are "republishing" 20 SQL Server 2012 source databases, using SQL 2016 as the republisher and subscribers, with SQL 2017 acting as the single distributor for both "hops" (Hop 1 being ...
1
vote
0answers
848 views

Ola Hallengren Backup - stuck at 100% complete

Full Backup started on 4/21 12 AM. While backing up one of the database, it is stuck. sp_WhoIsActive shows following information wait_info: (1208ms)PREEMPTIVE_OS_WAITFORSINGLEOBJEC CPU - 188,528,...
1
vote
0answers
787 views

Yet Another “Connection Timeout Expired pre-handshake acknowledgement” problem

This is SQL Server 2012SP4 on Windows 2012R2, with .NET Framework 4.7.02053. I've RDPed into the database VM and open SSMS. It times out with this error the first time I try to connect. If I try ...
1
vote
0answers
62 views

Decoding timestamp number in “change in schema version between compile time and run time”

I am trying to track down a "who/why" for the error <...> reported a change in schema version between compile time ("185302088475260") and run time ("185448117384521") for table <...> I ...
1
vote
0answers
275 views

SSIS FTP Package job fails when scheduling through SQL Server Agent job

I am using WinSCP inside SSIS Execute task for downloading and moving the file in FTP location. It works great through visual studio. I am passing parameters inside the SQL Server Agent job and the ...
1
vote
0answers
98 views

2-dimension Row Level Security Design

I'm working on a SQL Server 2012 database where the entity [scenario] has a One-To-Many relationship with a [client] table. The users working with this database might have access to only a subset of ...
1
vote
1answer
621 views

Always On shared network location

To use the wizard from SSMS, we had to provide full access to "everyone" to the shared network location. Is there a way to avoid this and just limit the access to a specific user? Already tried the ...
1
vote
0answers
659 views

Log Reader Agent Blocking Distributor Agent T-log Stuck with log_reuse_wait_desc Replication

I've got a nasty SQL Server 2012 replication issue. I have a transactional publication going to a pull subscriber. The log reader agent on the publisher has gotten stuck in a loop of: Delivering ...
1
vote
0answers
72 views

SQL Server 2012 Management Studio not loading

I have installed SQL Server 2012 on my Windows 10 machine, but when I launch SQL Server Management Studio, the splash screen shows for a minute but then the tool never comes up. The computer is ...
1
vote
0answers
117 views

Get the records matching the combination of column values from a temporary table

I have a temp table with 4 columns question_tbl: TempTable -- combination to lookup id | Code1 | Code2 | code3 --------+----------+-------------+--------- 111 | AA | A1 ...
1
vote
0answers
116 views

Cannot connect to the AGListener name when in SSMS on the passive node

We have a two node cluster built on Windows Server 2012 R2 with SQL Server 2012. This is a multi subnet configuration. I have tested the failover of the windows cluster and the availability group. ...
1
vote
0answers
892 views

SQL Server 2012 not using allocated memory

I have an issue with a SQL Server 2012 SP2 std server on a windows 2012 64-bit server Even though I have assigned SQL Server 12GB of RAM - it won't use more than ~700MB I've simulated memory load ...
1
vote
1answer
662 views

Sql Server Query timeouts when duration is under a second

We are getting the following exception in an application: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. So, I looked ...
1
vote
0answers
568 views

SQL Server Data Tools 15.5.0 - Script Component Validation Error

When trying to use the script component in an SSIS dataflow I am getting a validation error meaning the script and my package will not work: Severity Code Description Project File Line ...
1
vote
0answers
307 views

HowTo: [Output File Cleanup] workaround for UNC targets

Hallengren job [Output File Cleanup] silently fails when the output file directory is a network file share. Question: Is there a better, cleaner way to resolve the issue detailed below when the job ...
1
vote
1answer
2k views

Server Local Connection Provider has stopped listening on local pipe due to a failure

All, I'm looking at a database where every so often, connections to it will fail. The event viewer and SQL Logs have the following error in them: Server local connection provider has stopped ...
1
vote
0answers
34 views

Availability Groups - When Does Synchronous Mode Actually Restart

Given the scenario where a connection for a synchronous replica of an AG is broken, 10 seconds (by default) elapse and the replica goes into asynchronous mode. This allows database clients to keep ...
1
vote
1answer
46 views

Get Data for user excluding another user blocked with its time interval

Two tables Message ID | Message | FromUserId | ToUserId | DateCreated 1 | M1 | A | B | 2017-10-05 12:00:00 2 | M2 | A | B | 2017-10-05 12:05:...
1
vote
0answers
463 views

Inserting into an table with identity column from stored procedure works even though it shouldn't

We have this piece of (anonymyzed code) create table #SomeTmpTable ( [RowNumber] integer identity, [Value] integer, primary key (RowNumber) ) insert into #SomeTmpTable (...
1
vote
1answer
35 views

What is a good script or free/trial tool to inventory/replicate all settings in master db?

Context: CU10 failed, reporting a corrupt master db when applied to SQL Server 2012 SP3 CU5. We built an empty new master on that server and will restore the backup of the CU5 master into a new CU5 ...
1
vote
0answers
151 views

CC/BCC and comments section is missing in the SSRS subscription page

We're using SSRS 2012. We tried to limit the permission level of users, and assigned them "Manage Individual subscriptions" role, instead of "Content Manager" or "Subscription Manager", however, now ...
1
vote
0answers
935 views

Primary Server is “Resolving state” & Quorum node is in “failed” state

I would like to say that in my environment I have a 2 node in WSFC with the nodes SQLServer-01 (Primary Server) SQLServer-02 (Secondary Server) And for third vote in cluster also One (File share ...
1
vote
0answers
110 views

Is there any harm in having PRINT statements in (production) SP's?

Is there any harm at all in having PRINT statements in stored procedures, even in production? I have some primitive PRINT debugging statements in a huge SP enclosed by a IF @debug = 1 parameter such ...
1
vote
0answers
56 views

What parameters should I use to measure storage I/O capabilities

I want to measure the throughput of my disk subsystem using: https://gallery.technet.microsoft.com/DiskSpd-a-robust-storage-6cd2f223 what parameters should I use to closely emulate SQL I/O? Is there ...
1
vote
0answers
451 views

Unable to start the Integration services for SQL server 2012

Suddenly we are facing some errors in starting up the integration services. From event viewer and ssms when we tried connecting we get below error message The SQL Server Integration Services 11.0 ...
1
vote
1answer
638 views

Maintenance plan to delete backup and restore history not working

I have a maintenance plan set up on our SQL Server 2012 that contains only a "History Cleanup Task", which is configured to delete the following data if older than 4 weeks: Backup and restore history ...
1
vote
1answer
5k views

SQL Server Cluster Service Online Pending Status

I have 2 Nodes of SQL Cluster running SQL 2012 Ent over Windows 2012 R2 and i don't know suddenly what happened the service is not coming online. Under Failover Cluster Mannager > Roles > SQL > ...
1
vote
0answers
50 views

Migration of SQL Server Database

We have a situation here our application is working on SQL server on a cluster environment. Now we wish to migrate the database to a standalone environment, we have approx 2850 databases 1.6 TB in ...
1
vote
0answers
673 views

Could not fail over Always on AG to DR ones Prod was down - Help!

Set-up: Prod-HA-DR - SQL 2012 SP2 Prod-HA Synch, DR Asynch Databases are distributed on Prod and HA equally like Active-Active Instances. PROD-HA in Datacenter A DR - In Datacenter B Scenario: This ...
1
vote
0answers
282 views

A transactional log backup could not be generated because database is in either NORECOVERY mode or STANDBY mode

We have configured Always on Group Database with Full Recovery mode and secondary replica is in sync mode with primary server.Now we have configured logshipping in primary server to supply t-log ...
1
vote
0answers
604 views

Service Broker - Add to queue but don't process till later

Our current implementation has a data coming into the system onto a Service broker queue a small amount of processing is performed in case more pertaining data comes in, then a SQL Agent job running ...
1
vote
0answers
90 views

Bring back Master database from Single_user to Multi_user mode

Over the weekend, one of our colleagues applied the latest patch SQL 2012 SP3 CU8. But when we came in this morning 'master' database is in Single_User mode. I did tried the steps mentioned in this ...
1
vote
0answers
953 views

SQL Server not Using Allocated Memory

I have a weird problem I am struggling to troubleshoot. I have a development server with 18GB RAM and two SQL Server 2012 SP3 instances with @@version output: Microsoft SQL Server 2012 (SP3) (...
1
vote
1answer
80 views

Improving Backup Performance using SQL native methodology

I am trying to gather some stats on comparison of run time vs performance between Litespeed backups and sql native backups. As we are no longer going to use Lite Speed [even though i personally loved ...
1
vote
0answers
169 views

Creation of a database, hangs up the server for 2 minutes

I have been using the following script to create databases for a while, but recently, when I run this, it runs for good 2 minutes and slows down sql server to a halt almost. Any ideas for to look ...
1
vote
0answers
731 views

Error in skipping command in transactional replication in SQL Server 2012

My transactional replication is failing continuously. I am trying to skip the command but not able to do that. Below are the steps which I performed. 1) use distribution select * from ...
1
vote
0answers
893 views

SSAS 2012 role fails to start in a Win 2012 cluster

I started a thread in MSDN SSAS Forum. Please see this and help me understand the problem. I have never seen this sort of issue before. I'll try to explain the issue here as well. I got SQL Server ...
1
vote
1answer
343 views

Include stored procedure text output in the maintenance plan log

I have a maintenance plan subtask in SQL Server 2012 Enterprise that executes a stored procedure (or a SQL Server agent job). In the log file for this maintenance plan, there are a few lines for this ...

1
3 4
5
6 7
13