|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Change Tracking Default Retention | |
I turn on change tracking for a database with this code in SQL Server 2019:
ALTER DATABASE Sales SET CHANGE_TRACKING = ONWhat is the default retention period for changes? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Third Party VDI Backup I am using a third party backup utility that creates backup files from the VDI interface. I install this utility as a sysadmin and it adds extended stored procedures to SQL Server. I then change the software to use a lower privileged login that has db_backupoperator set in each database. Will the backups run successfully? Answer: no for all databases Explanation: This will not work. The VDI interface is a privileged connection, and therefore any utilities that use this require sysadmin privileges. Ref: SQL Server VDI backup and restore operations require Sysadmin privileges - https://support.microsoft.com/en-us/topic/sql-server-vdi-backup-and-restore-operations-require-sysadmin-privileges-4797c4bc-ed60-8f1b-7978-8ee1cc701eab |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
Event log filling up with Sql error - Windows event log filling up with ERROR 1 : "The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-]' running on queue 'test.dbo.SqlQueryNotificationService-' output the following: 'Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.'" And Error 2: An exception occurred while enqueueing a […] |
Informatica -SQL Error - We get a sql connection from host informatica server and the query runs in sql for almost 50 minutes and fails. We see the below information from informatica logs shared. We dont see any resource utilization or error logged in sql at this time frame. Any suggestion on what could be the reason. Waiting for […] |
SQL Server 2016 - Administration |
SSRS Zero-Day patching? - Hello all, I've been tasked (rather randomly) with finding out if there is somewhere we can specifically find any Microsoft zero-day patches that would need to be applied to SSRS servers. Mind you, I don't handle patching of any kind for our servers, so I'm at a bit of a loss as to where I […] |
Development - SQL Server 2014 |
Last Successful Completion Date for SQL Job - I am trying to write a query to get a list of all SQL Jobs that have failed. The part I am having an issue with is getting the "Last Successful Date" the SQL Job completed without errors. It seems what I am getting is the last "successful step", not the last time the entire […] |
SQL 2012 - General |
How to remove data and index fragmentation in a table - The picture is showing the results that I used sp_spaceused for OldTable and NewTable, I used "select into NewTable from OldTable", and created the same indexes on newtable with the OldTable, as per the data of the picture, the OldTable taking more space than the NewTable, so seems that the OldTable has many many fragmentation […] |
Database Recovery but DB is 7GB and log file is almost 3 - I have had a server crash and although I was able to recover the disks and the contents, the SQL database isn't working when I drop the files into the DATA folder and Attach to them. The database immediately goes into Recovery Mode. I tried all the usual commands to get the database up and […] |
SQL Server 2019 - Administration |
Splitting table into multiple tables - I have a requirement where we have a table of 1 billion rows, which is causing some performance issues. so we decided to split the table into multiple tables this is the table structure, there are no primary keys, constraints. There is just one clustered columnstore index name(varchar) date(smalldatetime) category(varchar) A […] |
AlwaysON on one Node - Hi friends, Is it possible to configure ALwaysON with two instances on one node ?One of them to be Read-Write and other to be Read-Only. Any document reference link as steps would be great.Newbie on AlwaysON.Thank you in advance. Thanks and Regards Arshad |
SQL Server Single Instance FCI - Failover Error - I have the following setup. 3 Node WSFC Cluster hosted on EC2 in three different Subnet Installed Single Node SQL Server FCI on all of the three Server But When I try to move one of the Role from one node to another it gives me the following error: It will be great if someone […] |
SQL Server 2019 - Development |
CREATING TRIGGER THAT INSERT DATA WHEN A PARTICULAR COLUMN OF A TABLE IS UPDATED - Hello, I am looking for a way whereby a trigger will be created ONLY when a particular column of a table is updated. Take for instance, I have a table with about 5 columns including start column. I want a situation whenever start is updated(from false to true ), some data will be inserted in […] |
How to do Join - Hello, I am looking for output where EG_RequestID = 175998968 and Reissue from paymentID = 333333 from above both temp table. I will get multiple reissue payment ID, Can you please help me to write query ? |
SQL Azure - Administration |
Housekeeping of SQL Azure DB's - Hi all, I have a question for you, as some move into the cloud and on Prem SQL databases become SQL Azure DB's I wonder what housekeeping jobs are required in SQL Azure DB's (by that I mean single db's, elastic pools and serverless - NOT Managed Instances or VM's running SQL in Azure. With […] |
Disk Latency in SQL MI - For SQL Managed Instance, disk latency for Reads and Writes, when I query through ssms is very high for the user databases (latency is >300ms). I've been using below query to get the disk latency for Onpremise and SQL MI databases. The Query works fine for Onpremise, but on MI it is showing up high […] |
Reporting Services |
Disabling all access to the server - Hello everyone! We have a small group of users (4) using MS Access 2000 to run queries on our MS SQL 2000 SP3 server. When specific queries are run, a deadlock is created, disabling all access to the server. We narrowed it down to these specific queries. We've tried setting the queries to "Record Locks: […] |
SQL Server 2005 Integration Services |
Can't upload all files from the S3 bucket - Hi all, I have a package that uploaded files from S3 bucket. Currently I need to add two another files. All previous files started with the phrase FA. The files that I need to add started from the phrase FARAN. And contain the name of the country in the format "Country_" or "_Counrty". The S3 […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |