for SQL Server 2012, major build version 11.00.xxxx. Released April 1, 2012 with a projected end-of-life date of 7/12/2022.
0
votes
0answers
16 views
SQL Server 2012 Transactional Replication Issue — Table Data not updating at subscriber
In my projects we configured Transactional Replication for my Database - one publisher, one distributor and two subscribers
For 2nd subscriber every table data is updating properly
But for 1st ...
20
votes
2answers
692 views
Why does query error with empty result set in SQL Server 2012?
When running the following queries in MS SQL Server 2012 the second query fails but not the first. Also, when run without the where clauses both queries will fail. I am at a loss why either would fail ...
0
votes
0answers
33 views
Looking for package with stored procedures for drop, create, disable, enable operations [on hold]
I become tired to write stored procedures for mass drop, create operations, e.g drop all from table, schema, drop with scripting and follow recreation, etc. Even enable/disable all triggers on table ...
2
votes
1answer
45 views
How to allow connections to SQL Server with 2 differents ip
I have a small issue here: I have a SQL Server instance 2012 (let's call it INSTANCE) on a cluster. I also have 2 network interfaces for this instance:
SQLINSTANCE.my.metwork
...
0
votes
0answers
51 views
Map multiple external-id to single internal DB-id
I have been tasked to add a new functionallity to a application and I'm not really sure how the best way to go about this would be...
Basically there is a application that receives messages with some ...
2
votes
2answers
48 views
SQL Agent - PowerShell step “syntax error”
I have the following code setup in SQL Agent Job step that is not running. The message received is simply:
Unable to start execution of step 1 (reason: line(46): Syntax error). The step failed.
...
2
votes
1answer
55 views
Speed of Searching Text vs INT/BIGINT - SQL Server 2012
I am building an application that will need to handle extremely high amounts of traffic. The traffic will consist of incoming requests for information from a SQL Server 2012 database. When a request ...
0
votes
1answer
28 views
Can SQL Agent job notifications be sent to one operator for success and another for failure?
We have a requirement that some people are sent notification on success, and other on failure.
But the UI seems to only allow a combination of 1 operator + 1 condition.
So I was wondering if we ...
1
vote
2answers
35 views
Dropped the Distibution database before disabling publishing and distribution, how to proceed?
I'm setting up my first Distributor database on SQL Server 2012. I successfully created one and then wanted to blow it away and perform the task again just for practice.
This was a brand new ...
1
vote
1answer
37 views
CDC not picking up changes
CDC has been set up for one of our databases in our test environment but it's not capturing any of the changes. I've made sure the capture job is running. I've disabled CDCs for the database, enabled ...
0
votes
0answers
25 views
Generating dynamic table CREATE and iterative INSERT INTO script in TSQL?
I'm starting to create a dimensional database for BISM development using tables and views from a relational database on the same SQL instance. I've been looking for a way to dynamically generate ...
2
votes
1answer
65 views
How can I use running total aggregates in a query to output financial accumulations?
I am attempting to write a query that will be consumed by a SSRS 2012 report. Given a paid invoice, with a certain set of account allocations towards which the money paid towards it must be saved, I ...
0
votes
0answers
28 views
Linked Server for MultiSubnet AG Listener
How do I create a linked server for an AG Listener that is in a multi-subnet configuration? I have a couple clusters that need to be able to query the listener at hand but the node that is on the ...
5
votes
1answer
106 views
How to avoid a race condition with cross db proc calls? and other concerns
I am not even sure this question is necessary but I am curious to know everyone's thoughts. I have two databases on the same server, dbFoo, dbBar. dbFoo has the following table please note this is a ...
1
vote
1answer
32 views
automatic transactional replication failover to noce2 with AG failover
I am working on to set up high availability group like
SQL01,SQL02,SQL03(DR) and SQLRPT01 as the reporting server which has our reporting DB.
* From SQL01 to RPT01, I am running transnational ...
