|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Change Tracking Data Retention Options | |
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);What are the possible choices for xxx? | |
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) |
Copying Production Schema If I use DBCC CLONEDATABASE, can I remove some of the information from the copy? Answer: You can only copy or not copy query store data and/or stats info Explanation: There are flags to not copy statistics info or not copy query store data. All schema objects are copied. Ref: DBCC CLONEDATABASE - https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-clonedatabase-transact-sql?view=sql-server-ver17 |
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 2016 - Administration |
Object owner question - Hello, Currently all of our tables e.t.c are owned by dbo. In one of our databases I need to move the tables to a different owner to prevent an ownership chain. What I'm a bit unsure about is the best type of account to use for the table owner. I think 'user without login' is […] |
SQL Server 2016 - Development and T-SQL |
Encryption or Certificate - Trying to NOT put hardcoded password in Proc - We have a few stored procs where we need to a dos command "net use" EXEC master..xp_cmdshell 'NET USE \\\ /USER:<domain\username> /PERSISTENT:yes' I am trying to figure out a way to retrieve a password stored somewhere that is obfuscated from nefarious people, via encryption or any other way really, So that […] |
SQL Server 2019 - Development |
Next dates - CREATE TABLE ADMITS ( ID_NUM INT varchar(15) null ,provider_id varchar(15) null ,provider_name varchar(36) null ,ADMIT_DATE DATE NULL ,DISCHARGE_DATE DATE NULL ,swpa_description varchar(max) null ,date_dispensed DATE NULL ,drug_name varchar(max) null ,discharge_to_dispensed int ) INSERT INTO ADMITS (ID_NUM,provider_id,provider_name, ADMIT_DATE, DISCHARGE_DATE,swpa_description,date_dispensed,discharge_to_dispensed) VALUES ('008012773','006467','WHITE DEER RUN LLC', '2024-02-06', '2024-02-11','Residential Detox, Rehab, HWH (non hosp)','2024-02-22','GABAPENTIN, 300 MG ORAL CAPSULE',11) ,('008012773','006467','WHITE […] |
SQL Azure - Development |
How to resolve issue of custom Audit log table containing incorrect data? - We have created a parent table, child table & Audit log table in SQL Server database. For one parent record, there are multiple child records. When a child record in updated, a Stored Procedure is called in which a few fields of all the child records are updated that are associated with the parent record. […] |
Amazon AWS and other cloud vendors |
Moving a database from AWS RDS Custom to RDS Standard - Having real fun with this. It isn't possible to set the option group, to enable the AWS SQL backup routines, because you can't execute the CloudShell command to assign an options group (aws rds modify-db-instance), in RDS Custom. I can't restore an RDS Custom snapshot, because that will just create another RDS Custom, and I […] |
SSRS 2016 |
ssrs subscription file share - I am trying to create a subscription that posts to a one drive directory. I reset my password through microsoft and then copied that password when setting up the file share subscription. When the subscription executes I get 'a logon error occurred when attempting to access the file share. the user account or password is […] |
Integration Services |
OLE DB Provider SQLNCLI11.1 Is Not Registered - I am not sure if there are components I need to install on my local PC or on our server, so I am hoping for some help. I have Visual Studio 2019 installed. For a few years, I have been creating SSIS packages for a Microsoft SQL Server 2016 (SP1) - 13.0.4001.0 (X64). I had […] |
Editorials |
Data Sovereignty in the Cloud - Comments posted to this topic are about the item Data Sovereignty in the Cloud |
Ghostworkers - Comments posted to this topic are about the item Ghostworkers |
MySQL |
MySQL 5.6 not writing any logs - We are using MySQL version 5.6 in our Windows Server 2012 R2 environment. We have enabled the error, general & slow logging in the config file, but the logs are not being written even in case of errors. The below is a snippet from the ‘my.ini’ file: # Commented lines aren’t included [mysqld] […] |
Article Discussions by Author |
What is Delayed Durability in SQL Server — And Should You Turn It On? - Comments posted to this topic are about the item What is Delayed Durability in SQL Server — And Should You Turn It On? |
Which MAXDOP? - Comments posted to this topic are about the item Which MAXDOP? |
Fetch fields like email address from multiple records into single cell - Comments posted to this topic are about the item Fetch fields like email address from multiple records into single cell |
SQL Server 2022 - Administration |
SSL certificate to connect Google Looker Studio to on-prem SQL Server - We have been asked to connect Google's Looker Studio to an on-prem instance of SQL Server 2022. Our instance has "Force Encryption" enabled, and uses a private domain CA certificate. In the connection string dialog for Looker Studio, there is an "Enable SSL" checkbox and an option to upload a Microsoft SQL Server SSL Configuration […] |
SQL Server 2022 - Development |
where did my topic on a new ssms 21 bug go - Hi should i repost my latest ssms 21 bug, the one in which sql agent now doesnt show property details on steps in the gui but does show them when the job is scripted? It disappeared a couple of hrs ago because it was under eval. |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |