Questions tagged [sql-server]
All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.
34,394
questions
0
votes
0
answers
11
views
Error Trying to Replicate Database
I am getting the following errors in replication monitor when trying to do a Merge Replication between SQL in two locations
The subscription could not be initialized using an initial snapshot because ...
0
votes
0
answers
25
views
TRUNCATE WITH PARTITION Constantly Fails on 1 Out of 620 Tables
There is a table that seems to have constant updates. There is also a stored procedure that runs periodically and iterates through tables and attempts to truncate a partition of data using the command ...
0
votes
0
answers
22
views
Trouble with slow stored procedure performance on 35M rows with CTE/Temp table
We recently went through a new feature release to our app that added about 25 new columns to a large table (~35 million rows), and now we're having some major query performance issues. I assume that ...
0
votes
1
answer
33
views
SQL Server Trace Flag 5013
We have been advised to apply Trace Flag 5013 to our Production servers running SQL Server 2017 or above. My issue here is that this flag undocumented, so we are not able to verify exactly what it ...
0
votes
2
answers
37
views
Output empty rows
Good day everyone, I have this query that returns logs with different Event IDs that occured in the last few minutes:
SELECT LogEventID, LogMessage, LogTime
FROM Database.dbo.ApplLog
WHERE (LogEventID ...
1
vote
0
answers
36
views
The specified @server_name ('') does not exist
We have an SQL Server 2019 instance (let's call it 'sample_instance') with server collation of 'Turkish_CI_AS'. When I try to create a job, SSMS creates the part of the script that adds the target ...
0
votes
0
answers
22
views
Can we store always encrypted column into temp table in Azure SQL Database?
I have encrypted a column in Azure SQL Database and now when a proc which has used temp table and being used to UPDATE/INSERT data into always encrypted table. The exception detail is
Msg 33293 Level ...
0
votes
1
answer
29
views
import extended properties of sql server database from xls file
I have a list of extended properties for all databases in an excel file. How can I import that into extended properties of each database in sql server.
0
votes
0
answers
39
views
TCP Provider, error: 0 - The wait operation timed out
I have a system where many users connect to a database SQL Server through an application, everything works as it should, but sometimes, very rarely, an error occurs.
Message: A network or instance-...
2
votes
1
answer
93
views
Most efficient way to determine if a SQL Server database is using Read Committed Snapshot?
The conventional way to determine if a SQL Server is using read committed snapshot is a query similar to the following:
SELECT is_read_committed_snapshot_on
FROM sys.databases
WHERE database_id = ...
-1
votes
1
answer
29
views
MSSQL server mirroring
I have two VM's One is primary and the second is secondary both having sql server with same make and model. I want to make a communicate both VM's to make sure if the primary server goes down the ...
1
vote
2
answers
95
views
error when re-applying the permissions script into the original database - sql server
when I run the following script:
-- ——— SCRIPT GRANTS for Object Privileges—————
IF OBJECT_ID('[sys].[sysrowsets]') IS NOT NULL GRANT CONTROL on [sys].[sysrowsets] to [db_myrole_BA]
I get this ...
0
votes
0
answers
27
views
Automatic startup of SQL server when configured with SCCM - Who is responsible?
I have configured SCCM with a remote SQL server in the same domain, and it is working fine.
When I stop the SMS_EXECUTIVE service fo SCCM and SQL server in the remote machine, SQL server gets started ...
0
votes
0
answers
40
views
Unable to select "other data source" when creating linked server
I am unable to select the option for Other data source when creating a linked server in SSMS, because the option is completely grayed out. I have installed Microsoft OLE DB Driver (MSOLEDBSQL) for SQL ...
4
votes
1
answer
88
views
Backups/CHECKDB errors - "Cannot find server certificate"
I have been exchanging TDE certificates on various servers to make restores easier - some had the wrong name, the wrong thumbprint, or even both. This involves transferring databases to a temporary ...