| CARVIEW |
Select Language
HTTP/2 200
date: Thu, 24 Jul 2025 14:18:24 GMT
content-type: text/html; charset=utf-8
cf-ray: 96440bed7c46c462-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=50820089-e583-4b22-91fb-91ac9ebbc867; expires=Fri, 24 Jul 2026 14:18:24 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: 2bb0d1c3-dd0b-478e-b07b-54ee5ed44efb
x-worker-origin-response-time: 501000000
x-dns-prefetch-control: off
set-cookie: prov=50820089-e583-4b22-91fb-91ac9ebbc867; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=.XtLZ0QkZMTrhrSXlyPETuE6OdUyPwyYgocBAhjH.WY-1753366704-1.0.1.1-vp2xCu9bf1CNUm4SGsDAXetGBZH7del1EvtlAHylLte3NGgxX64H1EqDpmr3djUXXP4zEcdCcZVHAGiUFkxYkoIFlB3.RafC.brJiV0uTqM; path=/; expires=Thu, 24-Jul-25 14:48:24 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=uM1Z0g_HiW0icWt9ad_.rS5rwC4k3Ewo0098gaDWu6k-1753366704745-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
111
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
43
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
301
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
191
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
- How do mechanical gyros maintain rotational speed?
- Is there a way to retrieve my inventory from the void in Minecraft Java Edition?
- Differential amplifier layout: closer to MCU or Load?
- Is it rude to make someone an academic reference without getting their permission first?
- Can a humanoid that fell supine and is then Levitated alter his orientation?
- How to model This Twisted Torus?
- Etymology of the word skulduggery?
- Did Germany declare the Donetsk People’s Republic to be a terrorist organization, at some point?
- MATCH issue across multiple tabs - floating point, INDIRECT
- Is a diet of one third Tuna ok for an eldery cat?
- Will I lose my seat reservation on Deutsche Bahn EC if I skip the first leg?
- Macro Definition Outside Current Group
- Have philosophers ever defined a notion of "luck" or "surprise" that is separate from probability?
- When was the last time all alive humans stayed on earth?
- How much power does the Fed chair have over interest rates?
- Where did the name of Windows XP come from? Was it connected to the Cairo project?
- How should a typical reward curve look like while training a RL model
- Ubuntu Server installation -- options for boot disks are grayed out
- How to \input file as arguments?
- How to show the Desktop and not the Activities Overview upon logging into Ubuntu 24.04?
- Which domain (time or frequency) does filtering actually occur in real-life?
- I am looking for a French mathematician
- Do standing sound waves sound different?
- Why is `&self` allowed in the parameters of `&mut self` methods, but not `&mut self`?