CARVIEW |
Select Language
HTTP/2 200
date: Sat, 26 Jul 2025 11:06:37 GMT
content-type: text/html; charset=utf-8
cf-ray: 96536db98b58b277-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=7925f8e3-cb7c-4430-ae62-e75d10491fd8; expires=Sun, 26 Jul 2026 11:06:37 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: c9537ff0-4a17-4662-935a-477558d82e64
x-worker-origin-response-time: 1054000000
x-dns-prefetch-control: off
set-cookie: prov=7925f8e3-cb7c-4430-ae62-e75d10491fd8; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=1m5iqdGk7vh6sN8w.wcTTKgyK6G6DTud96QxR6ijhYk-1753527997-1.0.1.1-YE1n4o0NOuzocae_SwEk9yJheu3mXzQli_A6Grv_4AaI169KDiR..0SUTnyP3oeDPQDtlBt6ueWCIKwOHE4A457lSjBnDYuiYsIdioOcREs; path=/; expires=Sat, 26-Jul-25 11:36:37 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=1nU2mCD_ParfVwpf0Gs7c9yjmsBxn34hK25MCXJwzlw-1753527997468-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 ExchangeTeams
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
303
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
408
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
175
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
137
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
45
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
210
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
- Early Sailing days in September 1066... Could Harold defeat William at Hastings, if it happened before Stamford Bridge?
- I am looking for a French mathematician who contributed to complex analysis
- Heretofore I think I have been using 'heretofore' incorrectly
- Why is 0.0 printed as 0.00001 when rounding upward?
- Is it possible to use the PC power button to pre-select the OS in rEFInd UEFI dual boot setup?
- How can I evenly space my instances after they've been progressively scaled?
- Did the first sin in the garden of Eden actually take place before the fruit was eaten?
- Where should a drain saddle for an RO system be installed?
- Break long equation: vertical alignment of indentation
- The pea and the sun paradox
- Not being introduced to the team – should I ask for it?
- Why are police personnel of all ranks called officers?
- What does "Store Name" mean on the Tokyo-Narita Airport Bus timetable?
- About security concerns using in find -exec vs interactively performing the same task
- Symbols for A.P. Morse's book in Set Theory
- Is there such a thing as 'aerospace grade software'?
- Blinded despite Blindsight?
- How can I turn the text in a PNG file back into text layer?
- tac-command is it a bug or a misinterpretation of the manual?
- Not your ordinary affix riddle
- Are you required to protect trade secrets revealed to you even if you didn't sign an NDA?
- What Isp can be gotten from a napthalene (mothball) hot gas thruster? Did it work in space?
- Which workflow is more effective: worldbuilding before plotting or the other way around?
- About Harp Pedaling for a Pentatonic Glissando