| CARVIEW |
Select Language
HTTP/2 200
date: Thu, 24 Jul 2025 22:50:44 GMT
content-type: text/html; charset=utf-8
cf-ray: 9646fa668ddfa403-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=927f900d-a975-40b0-b0e6-080e34f491d8; expires=Fri, 24 Jul 2026 22:50:43 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: 80163111-9b3d-4497-a7eb-124ff6872eec
x-worker-origin-response-time: 526000000
x-dns-prefetch-control: off
set-cookie: prov=927f900d-a975-40b0-b0e6-080e34f491d8; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=LFJW99q0GZxb00oSVCSo7I.ktlj4depkc27rQYQBnt8-1753397444-1.0.1.1-U8MUAiK4ORDqmyHmrYdh2kWr8AP42721kgaZdo9YQzzE0isD0GjlP2obX2GRTLPDUmDLfBC_geboT3sCphg.CS6T6z1uQhpFEHAWR.sZNag; path=/; expires=Thu, 24-Jul-25 23:20:44 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=V_3x.odqeL4ayhKagpNIZkvemFWbW9iCX4XFW5YDlG4-1753397444136-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'sql-server-2016' 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-2016]
SQL Server 2016 (major build version 13.00.xxxx). Please also tag sql-server.
2,805 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
44
views
ADO.NET client occasionally attempts connection to SQL Server mirror partner even when principal is online
We're running SQL Server 2016 Standard Edition with database mirroring in synchronous mode and automatic failover enabled. Our .NET applications use connection strings with Failover Partner.
...
1
vote
1
answer
156
views
How can I execute Openrowset in the named instance I am currently in?
I am running this openrowset query about jobs on my current server and I see that the result set is not correct.
I was expecting a bunch of jobs but I only get one.
when I run the following piece of ...
0
votes
1
answer
50
views
SQL Server Extended Events - collecting SP Object_name
I'm going round in circles trying to work out how to collect the object_name in extended events, I can use it to filter like in the session definition below
CREATE EVENT SESSION [xetest] ON SERVER
...
0
votes
2
answers
112
views
Sql Server Agent service not starting because the Agent XPs is disabled. How to solve this problem?
I have a bunch of servers hosted in Canada,
one of them has some erratic behaviour when under too much pressure for some time.
it just looses connectivity as probably the CPU is on high.
this is ...
0
votes
1
answer
44
views
where is my ssis package saved after importing data from source server to destination server?
so I am importing some data from a different server on a table I have on master database
this is done through a query on the destination server, but I need to specify credentials on both servers.
...
0
votes
0
answers
62
views
Same query, different execution plan, massive runtime impact
We have a JavaEE application that calls a stored procedure (SP) for some kind of search form. It's a massive query utilizing multiple joins and conditions.
We now observed, that this SP seems to use a ...
1
vote
1
answer
306
views
Query Stuck in SUSPENDED State Wait Type BPSORT
I have a query which was stuck in state SUSPENDED for several hours when running sp_WhoIsActive. We run SQL Server 2016 SP3 on a VM with 16 cores and 192 GB memory. This query is an INSERT query for a ...
0
votes
1
answer
53
views
query to find the latest transactional backup for a server involved in availability group
I got a query to find the latest transactional log backup.
in this particular server it is not working for some reason.
here is the query:
SELECT
@@Servername AS [Server_Name],
B.name AS ...
0
votes
1
answer
243
views
SSIS Package Failing: Version of the Flat File Destination is not compatible with this version of the data flow
Built a simple SSIS package that pulls data from six SQL tables and dumps out to flat files. Package works fine within Visual Studio but keep getting the error code 0xC0048021 when deploying within ...
1
vote
1
answer
84
views
SQL 2016 Small ETL batches load very slowly while large batches load normally in terabyte database with giga-row tables
Bear with me, I've got a ton of setup before getting to the questions.
SQL Server 2016, 13.0.7050.2 (but this also happened on earlier builds). I think it's SQL Enterprise Edition (but it could be ...
2
votes
1
answer
122
views
SQL Server Index Rebuild Lock
I had a Rebuild Index Task from Manteinance Plan running the ALTER INDEX REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = COLUMNSTORE) on several large tables WITH OFFLINE = OFF due to license. This ...
1
vote
1
answer
193
views
is there a way I can see if a specific patch has been applied to my sql server?
How can I see if this patch has been applied to my sql server server?
I know about @@version, but that shows me the latest patch applied, about about the other patches before that one?
4
votes
2
answers
368
views
double quotes on a sql server code inside powershell - in visual code - how to make it work?
double quotes are used in sql server, and their behaviour can be defined by the option SET QUOTED_IDENTIFIER ON\ OFF
double quotes are also used in powershell.
SET QUOTED_IDENTIFIER must be ON when ...
0
votes
1
answer
120
views
xp_regread() returned error 5, 'Access is denied.'
I can understand when permissions to folders are missing,or restore,or bulk insert, but even me being an admin on the box is not helping on the error below.
what permission is missing?
this is what I ...
0
votes
1
answer
88
views
where does sql server store replication monitor info?
it is not my way to check the replication, however, on this instance I have many publishers on my replication monitor, as you can see on the picture below:
where does sql server store the publishers ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
sql-server × 2238
availability-groups × 229
performance × 166
t-sql × 151
query-performance × 120
backup × 90
ssms × 88
execution-plan × 86
sql-server-2012 × 73
sql-server-2014 × 69
replication × 68
stored-procedures × 58
permissions × 57
index × 55
restore × 52
clustering × 51
optimization × 48
transaction-log × 48
windows-server × 48
security × 45
ssis × 44
database-design × 43
sql-server-agent × 43
sql-server-2017 × 41
more related tags
Hot Network Questions
- Distribution of a dot product of multinomial variables
- What *IS* switch bounce REALLY? According to evidence
- Why does “brew search” for “peertube” match with “freetube”? How does the search work?
- Write two very different programs with the same characters
- Why is Shunt Voltage Reference (LM4040DBZ-3) Not outputting a stable 3V supply
- When was the last time all alive humans stayed on earth?
- Trinity question: what does to subsist/subsistence mean?
- Do the constructible lines and circles (not merely their intersections) cover the plane?
- Processing All Files [0-9]*tex
- Early Sailing days in September 1066... Could Harold defeat William at Hastings, if it happened before Stamford Bridge?
- Finding the value of collector resistor
- Console-based Casino Game in C++
- Where did the name of Windows XP come from? Was it connected to the Cairo project?
- Lilypond to MusicXML
- Is there a way to retrieve my inventory from the void in Minecraft Java Edition?
- How to move points in geometry nodes like a venetian blind?
- Is the surface of Mars or the Moon mostly (or relatively) homogeneous, unlike the Earth?
- Visual glitches on Chrome - but only in some places. What could be the problem?
- Why were two 2x6 boards installed on top of a window rough sill?
- Business technical issues lead to unsuccessful payment being considered successful. Do I have any duty to notify?
- List Based Off Another List
- A soviet sci-fi novel (novelette?) with frogs?
- What is that "T" in the pattern string of the date-command?
- Is it okay to email researchers if I’m just a high school student?