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
vote
0answers
333 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
506 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
611 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
55 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
226 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
69 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
334 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
379 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
58 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
70 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
106 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
629 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
0answers
426 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
235 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
0answers
1k 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
45 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
268 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
2k views

SQL Server CLR 'Failed to create AppDomain' debugging

I am having the 'Failed to create AppDomain' issue in a production instance. This is typically attributed to memory pressure(not the case here) or pending .Net updates. The OS has been restarted and ...
1
vote
0answers
112 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
94 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
53 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
324 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
501 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
4k 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
2k views

BCP Error SQLState = S1000, NativeError = 0 , Unable to open BCP host data-file

I am trying to execute the below BCP query in my TEST Server, where BCP has a connection string to the production DB, so my destination folder is in my Test Server and I am getting an error, I think ...
1
vote
0answers
48 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
534 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
233 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
520 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
79 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
630 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
74 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
140 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
596 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
433 views

Modifying Ola Hallengrens index maintenance script for deadlocks

In a SQL Server 2012 Enterprise database without a true maintenance window, I would like to run Ola Hallengrens script to optimize indices. Testing has shown that while indices are reorganized and ...
1
vote
0answers
744 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
298 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
vote
2answers
889 views

New Server Query AD is giving permission error

We replaced a physical server with virtual, I copied all the logins, and linked servers from the old server and restored all the databases from the old server to the new. Everything works fine except ...
1
vote
0answers
121 views

AlwaysOn alert metrics for Solarwinds

Currently, we have Solarwinds in place for monitoring our servers. I would like to know if we are okay to leave the default metrics for AlwaysOn as is or do we need to increase that a bit. The reason ...
1
vote
0answers
74 views

SQL Server Errorlog file not releasing space when recycled

I had a series of SQL Server errorlog (1 to 6) files taking up 39GB. I needed the space for database growth. Being a belt and braces sort of guy, I zipped them (or moved them to compressed folder) ...
1
vote
0answers
90 views

SQL Server 2012: An older Index that used to help a SP overnight

Hopefully this isn't a repeat question. I haven't had much luck finding an existing answer. I have an index on a somewhat large table (About 60 million rows, 25gbs with indexes) that has been in ...
1
vote
0answers
1k views

SQL state S1000 in SQLConnect (but not all the time)

I have a CentOS6 webserver and a database server (MS SQL Server 2012). When I use the website everything is going fine except that once an hour or so I get a can't connect error in my php code. I ...
1
vote
1answer
70 views

From a user table check if one of them exists on a table

I'm developing a database with SQLServer 2012 SP2. I have these tables: CREATE TABLE [dbo].[Code] ( [CodeId] INT IDENTITY (1, 1) NOT NULL, [Serial] NVARCHAR (...
1
vote
0answers
41 views

decrypting sql function

I have the passcode to decrypt the function. I have read several articles about decrypting. I have logged in as DAC and tried to view it but unable. I used someone's SP from an article (SqlDecryptor) ...
1
vote
0answers
58 views

Low drive space on c: partitions on clustered servers

I have a 2 node cluster on Windows Server 2008 R2, with a SQL Server 2012 AlwaysOn AG. Both C: partitions are running out of space. Can I expand the C: partition on the secondary node, reboot, ...
1
vote
2answers
71 views

Proc caching on read only db's/replicas

I've been given the task of finding which stored procs are being called in our database. To that end I started querying sys.dm_exec_cached_plans. All is well and good, until I go over to our ...
1
vote
0answers
1k views

SQL Server: DB STARTUP blocking processes

I am trying to run DBCC CHECKTABLE (or CHECKDB, same result), but I keep getting this error: Check statement aborted. Database contains deferred transactions. I've made some researches and found ...
1
vote
1answer
81 views

Shredding Query Plan XML For Potential Skewed Estimates - Data Type Conversions

I'm using the below T-SQL to check for root level estimate skews in execution plans by pulling the estimated rows from the execution plans and comparing to the last rows from the sys....