| CARVIEW |
Select Language
HTTP/2 200
date: Thu, 24 Jul 2025 05:17:04 GMT
content-type: text/html; charset=utf-8
cf-ray: 9640f2f29ad9cb77-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=2999e6e4-50cc-41d5-b662-c9969f9163cb; expires=Fri, 24 Jul 2026 05:17:04 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: aac42fe1-4b77-4a38-909c-8e37bfd48161
x-worker-origin-response-time: 1039000000
x-dns-prefetch-control: off
set-cookie: prov=2999e6e4-50cc-41d5-b662-c9969f9163cb; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=lo66HWi8gunfHfl.IwTNcD9eHggYr.UfooUra19K0zQ-1753334224-1.0.1.1-yYlTARMsU2FlCgkh1rbAZDYPm1jWnq1ca4M_Ae_mMNjmyzB0ztX2konFk08uhK8HVavH.o0Rs7vNV81GHaWqGiN2cS6UfCzIQ7qSuoVb7dc; path=/; expires=Thu, 24-Jul-25 05:47:04 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=uoMuJZKUSN8oWo8L4tis.i_qmMmLPVz5PYRZvIteouU-1753334224829-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'sql-server-2012' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [sql-server-2012]
SQL Server 2012 (major build version 11.00.xxxx). Please also tag sql-server.
4,533 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
3
votes
2
answers
301
views
How to import an image from a file, using OPENROWSET, to a table record?
I am trying to import a small image from a file located on my MS SQL Server to a column in a database setup as VARBINARY(MAX). I have declared a variable as VARBINARY(MAX) and would like to assign ...
0
votes
1
answer
72
views
Split columns into hierarchy
I have a table that is structured in the following manner that we have imported from another source into SQL Server:
Tier 0
Tier 1
Tier 2
Tier 3
AA;AB;BB
T1A;T1B
T1A2A;T1A2B;T1B2A
T1A2A3A;T1A2B3A;...
-3
votes
1
answer
50
views
i am getting error of The column 'AEDAT' was specified multiple times for 'd' [closed]
---===============DATA WORKING LEVEL======================-----------------
DECLARE @date NVARCHAR(8), @to NVARCHAR(8);
SET @date = '202412';
SET @to = '202501';
with
dn as
(
select substring(...
5
votes
1
answer
407
views
What is a good way to handle an error while parsing a T-SQL command that doesn't exist on an older version of SQL Server?
I am trying to grant the [CONNECT ANY DATABASE] permission to a specific SQL account on multiple instances. However, one server is running SQL Server 2012 and that permission was not introduced until ...
0
votes
1
answer
53
views
Database replication - multi hop
We currently have a SQL 2016 database replicating to a SQL 2012 database and we are upgrading our SQL 2016 instance to SQL 2019. According to the compatibility documentation, replication between the ...
0
votes
2
answers
173
views
Cannot shrink log file
I cannot shrink a log file, for a database that is in Simple recovery model (used to be in Full , and was changed to Simple).
I have tried every solution I can find on the internet, even the mighty ...
6
votes
1
answer
540
views
How to Determine if a Stored Procedure is Being Recompiled on Every Execution in SQL Server 2012
What query can I use to determine if a stored procedure is being recompiled every time it is executed in SQL Server 2012? I suspect that some of our stored procedures might be getting recompiled, but ...
1
vote
1
answer
109
views
Does Postgres have anything analogous to Microsoft SQL Server's Batch Mode?
In traditional usages of Microsoft SQL Server, exactly one row flows from one operator in a query plan to the next. In Batch Mode, huge performance gains are obtained by moving thousands of rows at a ...
0
votes
1
answer
130
views
Transactional replication Snapshot agent not starting
I am trying to consider all the options before setting up transactional replication on my 2008R2 server to 2012 distribution server to 2012 Subscriber server. All the three servers are on FULL ...
2
votes
1
answer
86
views
SQL Server Database I/O Consistency Error Disaster Recovery
I have a corrupted SQL Database that is inacessible by any means. It is to the point that simple commands, like USE MyDatabase, won't execute.
The error I get is: SQL Server detected a logical ...
1
vote
1
answer
44
views
SSMS Version of 2008R2 Publisher not compatible with 20012 Subscriber
I am setting up transactional replication on my 2008R2 server to 2012 distribution server to 2012 Subscriber server. All the three servers are on FULL recovery mode. Log backup is taken every 15 ...
1
vote
0
answers
126
views
sp_send_dbmail fails when query is included
I am running SQL Server 2022 Enterprise inside a company domain. I have a SQL Agent job that runs a stored procedure. The job runs under a domain account say 'domain\myuser' that is a member of '...
-1
votes
2
answers
209
views
Sql query result in a single row with multiple dynamic columns
i have multiple rows and want to make dynamic column i tried below code with case it work fine but i need the column to be dynamic based on the count of max Code
EventId
Code
Date
1
A12
12/12/2020
1
...
-1
votes
1
answer
167
views
Delete operation taking time from SQL Agent Job
I am running a job which deletes data from 7 tables, 2 of which contains 1-2 million records. But the job gets stuck at a point when deleting data from web_activity table which holds only 42 000 ...
0
votes
1
answer
105
views
What happens if the Subscriber goes down - will the t-logs keep accumulating on the publisher in Transactional Replication?
I am trying to consider all the options before setting up transactional replication on my 2008R2 server to 2012 distribution server to 2012 Subscriber server. All the three servers are on FULL ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
sql-server × 3286
performance × 274
t-sql × 270
availability-groups × 245
sql-server-2008 × 184
sql-server-2008-r2 × 171
backup × 164
sql-server-2014 × 132
ssms × 130
query-performance × 128
replication × 116
permissions × 112
ssis × 101
restore × 99
index × 86
clustering × 84
transaction-log × 84
stored-procedures × 83
security × 82
sql-server-agent × 81
memory × 76
execution-plan × 74
sql-server-2016 × 73
windows-server × 67
linked-server × 64
more related tags
Hot Network Questions
- Pourquoi "better to use ne alone" dans ce cas, "with savoir followed by an indirect question"?
- tac-command is it a bug or a misinterpretation of the manual?
- Does Philosophy Need Quotes?
- Is the appearance of certain kinds of clouds at altitude of > 30000 feet a recent phenomenon?
- How to permanently get rid of (possibly) elm bushes in the garden
- Heavy shelves, but not a center stud
- Legolas Master Archer removed with 2nd triggered ability on stack
- Do standing sound waves sound different?
- How should a typical reward curve look like while training a RL model
- Make a Mulenère encryption program
- How can I delete a stubborn file on Windows Server?
- Will I lose my seat reservation on Deutsche Bahn EC if I skip the first leg?
- In QGIS installed via OSGeo4W on Windows 11, what is the path to the command history file for the Python console?
- A complex polynomial inequality
- Distance Between Subspaces
- How to move points in geometry nodes like a venetian blind?
- In this video why are the astronauts wearing only their flight suits during dragon training while in others they are in their full starman suits?
- Can authors be blacklisted by academic publishers for multiple rejections without any ethical misconduct?
- Differential amplifier layout: closer to MCU or Load?
- Dystopian 80s sci-fi movie about the USA choosing mediocrity
- How to get most recent common ancestor of a set of tips using ape package in R?
- What was the Russia-Germany 1996 "Defence pact" that Russia recently announced has been terminated?
- Is buying random stocks and then selling off the ones that go down a good way to reduce capital gains tax?
- How do mechanical gyros maintain rotational speed?