| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 19:59:56 GMT
content-type: text/html; charset=utf-8
cf-ray: 963dc2d468cbcf00-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=c6ade6d0-99e9-4a8e-9f7d-785231223591; expires=Thu, 23 Jul 2026 19:59:55 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: 84b5515d-da04-43a2-a22f-361eed6b4184
x-worker-origin-response-time: 467000000
x-dns-prefetch-control: off
set-cookie: prov=c6ade6d0-99e9-4a8e-9f7d-785231223591; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=PcEg6A_.7WuQ_0Fg_Wahv6r4z6c76C5Kux5YuKmRDps-1753300796-1.0.1.1-F7NtdShwS8cIYvIOh0d9IceHOZjWFtazht1A4Jm0Oqj814_COsry1acc5UcW6LEM2eokwQqWZOrldxgkjVZQ8cEtKLHJcNa82CFUukSYeU8; path=/; expires=Wed, 23-Jul-25 20:29:56 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=hrJ_he8qKBGLbdqnNVQMXrTHGSoHXAIFLR3DTtozdEk-1753300796059-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
43
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
154
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
109
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
296
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
83
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
190
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
- Why does internal energy end up higher in an irreversible adiabatic process, even though the work done is less?
- Why is this endgame winning for Black?
- How to show the Desktop and not the Activities Overview upon logging into Ubuntu 24.04?
- Can you identify this shell case from Flanders?
- When is XLOOKUP() faster than VLOOKUP()?
- Why were two 2x6 boards installed on top of a window rough sill?
- Console-based Casino Game in C++
- What is the consistency strength of Russell & Whitehead's ‘Principia Mathematica’?
- What is that "T" in the pattern string of the date-command?
- Render / Convert .midi / .mid to FLAC on Linux
- Regex: how to match all strings except when the pattern occurs at a specific position
- Do standing sound waves sound different?
- bootstrapping for variance estimation takes too long
- In QGIS installed via OSGeo4W on Windows 11, what is the path to the command history file for the Python console?
- Pourquoi "better to use ne alone" dans ce cas, "with savoir followed by an indirect question"?
- Australian TV show about two dimensions separated by a deteriorating purple energy wall
- Is buying random stocks and then selling off the ones that go down a good way to reduce capital gains tax?
- Will I lose my seat reservation on Deutsche Bahn EC if I skip the first leg?
- How to handle missing weather data (predictors) in production time series forecast with Prophet?
- Is a chemistry-first technological paradigm as plausible as one focused on physics or biology?
- Sum of ranks of blocks
- Is it rude to make someone an academic reference without getting their permission first?
- Ubuntu Server installation -- options for boot disks are grayed out
- Why does contact with the ground make my touch-activated LED brighter?