| CARVIEW |
Select Language
HTTP/2 200
date: Thu, 24 Jul 2025 22:50:22 GMT
content-type: text/html; charset=utf-8
cf-ray: 9646f9dd5df48087-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=55fcda86-23a8-4568-9325-e4e68ca61901; expires=Fri, 24 Jul 2026 22:50:21 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: e2d5b05a-7dee-4886-917f-26380c9cce9b
x-worker-origin-response-time: 530000000
x-dns-prefetch-control: off
set-cookie: prov=55fcda86-23a8-4568-9325-e4e68ca61901; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=Q3nXe5JwPTvsVG6s.JtyNXWEoTEdl6ChNo9uUqqWE00-1753397422-1.0.1.1-StznA0qZacA5zfqLA4ftZJSQURp0EqnNWqKptb_doJAuXcss7brnUV6La5gtSZDkUrqw.atKsW2wks06Xf1AUgv1.pkcEQo.5W8LRXtXG6k; path=/; expires=Thu, 24-Jul-25 23:20:22 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=py7rP1S.EIZ1vPYZh5oTJJ95.NQkX3SmZw4TI8XhR.A-1753397422190-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
174
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
132
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
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
- Do the constructible lines and circles (not merely their intersections) cover the plane?
- Which domain (time or frequency) does filtering actually occur in real-life?
- Will I lose my seat reservation on Deutsche Bahn EC if I skip the first leg?
- Do things unknown automatically become unknowable in normal epistemic modal logic
- How do mechanical gyros maintain rotational speed?
- Is there a way to retrieve my inventory from the void in Minecraft Java Edition?
- What was the source of the image of pelican in Catholic churches?
- MATCH issue across multiple tabs - floating point, INDIRECT
- Which workflow is more effective: worldbuilding before plotting or the other way around?
- tac-command is it a bug or a misinterpretation of the manual?
- OId Movie about an alien city that plays a repeating melody
- What is that "T" in the pattern string of the date-command?
- Why does “brew search” for “peertube” match with “freetube”? How does the search work?
- How to \input file as arguments?
- Write two very different programs with the same characters
- Make a Mulenère encryption program
- Why does my laptop's display turn off when I'm away from the keyboard?
- A question about as ..... as comparison
- Can a limit be taken on a sum of divergent Laplace transforms?
- How can a perfect God have desires?
- Access denied attempting to delete file on Windows Server
- Early 70s scifi novel about underground people, caste is determined by the color of your poncho, and everyone eats mouldy grain
- Can a humanoid that fell supine and is then Levitated alter his orientation?
- Was Hermann Ganswindt's helicopter actually the first manned heavier-than-air motor-powered flight?