|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
The Secondary Database Name in an AG | |
I am setting up a SQL Server 2022 Availability Group and I am ready to restore the database on the secondary. The primary database is named Finance. However, we also use this instance for QA and already have a database named Finance. How do I configure the AG to use a different database as the secondary? | |
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) |
Dropping a Logon Trigger I created this trigger for testing on SQL Server 2022: CREATE TRIGGER checksteve ON ALL SERVER FOR LOGON AS BEGIN IF ORIGINAL_LOGIN()= N'ARISTOTLE\Steve' PRINT 'Steve logged in' END; GO Now I want to drop it. What do I run? Answer: DROP TRIGGER checksteve ON ALL SERVER Explanation: DROP TRIGGER checksteve ON ALL SERVER is what works. Ref: DROP TRIGGER - https://learn.microsoft.com/en-us/sql/t-sql/statements/drop-trigger-transact-sql?view=sql-server-ver16 |
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 |
Unknown queries showing in SQL Sentry tool - Hi. we are noticing this following query frequently in our production environment in SQL Sentry. They are definitely not from application. Do you know what it could be and how we can track it down? SELECT do.object_name as [object_name], do.schema_name as [schema_name], do.referencing_type_desc as [type_desc], do.referencing_type as [type], ds.referenced_server as [referenced_server_name], do.referenced_database as [referenced_database_name], do.referenced_schema […] |
SQL Server 2016 - Development and T-SQL |
Flexable/Effective means to join the Nth record - I have no doubt this has been covered many times and has many answers but I'm hoping by now this has been refined down to where you can get not just teh 1st or last record but the Nth record. Let say I has a join like the below and I want just teh first […] |
Development - SQL Server 2014 |
“user_scans” of table “sys.dm_db_index_usage_stats” - I am trying to find answer to the below. What exactly the scan means for the field "user_scans" being with the table "sys.dm_db_index_usage_stats" ? Like, there are tables in our prod which aren't used for sure as the module is shutdown 4 years back but the DB holds all the tables related to that module. […] |
SQL Server 2019 - Administration |
error -SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Proc - Hello experts, Recently we have migrated sql 2012 to 2019 post migration Az VM while running db bkps into url ,we are getting alerts error SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=5924. Thread=7452. Client. Instance=. VD=Global\{EA1DBCBD-17D1-4C54-884D-07424674DC54}2_SQLVDIMemoryName_0. Pls suggent |
SQL SSRS license info - hello, i am trying to find where SSRS edition and product key information are stored in SSRS 2019 and above version. until 2016 i was ablet to pull information from registry for some reason it is not available from 2019 and above versions. HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\($instance)\SSRS\Reporting Services\ReportServer |
SQL Server 2019 - Development |
Encryption & Decryption in SQL Server - Dear All, I have a requirement as below, Export a table/query output in a file with encrypted format. Import the file content to a table in a different server SQL database and decrypt the content. I request forum members to help on this please. Thanks in Advance! Chella |
Reporting Services |
YTD Not working - Hi All Please see the below screen shot, YTD column is nit working. Showing the same as complete year values. =(Sum(Fields!Accounts_Receivable_Application_Patient_Payment_Amount.Value) - Sum(Fields!Accounts_Receivable_Unapplied_Patient_Payment_Due_To_Refund_Amount.Value)) + Sum(Fields!Accounts_Receivable_Application_Insurance_Payment_Amount.Value) + Sum(Fields!Accounts_Receivable_Application_Insurance_Recoup_Amount.Value) Thanks |
General |
Have you seen this in the news today? - You might want to look into this issue: Windows flaw lets hackers sneak into your PC over Wi-Fi | Fox News I don't know how serious this might be, but maybe should be checked out. |
Analysis Services |
SSAS Multidimensional Configuration - Hi Everybody, I could really use some help. My company uses SQL Server Analysis Services 2019. We have a 75gb multi-dimensional cube. 95% of our report data is sourced from the cube. We also have several teams that refresh their excel workbook connections. For the past couple of months, we have been plagued with CPU […] |
SQL Server 2022 - Administration |
how to find the cpu memory disk and network of the OS where RDS is residing. - hi, i have one RDS, but i do not have any other permissions, and i need to know the cpu , memeory disk and network staus of the OS where RDS is residing. if i had sqlserver on my machine it was so easy for me to press alt ctrl del to find the status […] |
Contained Availability Groups and Replication - Hi, I have a couple of questions around contained AOAG: Is it still the case that you cannot replicate a database within a contained AOAG? Are you able to replicate to the nodes involved in the cluster outside of the contained AOAG? TIA |
SQL Server 2022 - Development |
Removing Filestream - How? - Hello, we are migrating our SQL Server database and one of the tasks is to stop using Filestream. I am wondering how do I extract all the actual files from the filestream data file? How can I get access to the actual files so that we can store them elsewhere? I have tried doing google […] |
how to assign studentid from one table to other one? please - Good Morning, how to assign query one results to query 2 student id, each record should have each value, rather assigning one to all 20k students. please advise. i tried one but it is assigned same id to all STG_Student. please -- Query 1 SELECT STATESTUDENTID FROM DEV_SLDS.LEGACY.STUDENTIDPOOL WHERE IDSTATUS = 'UNASSIGNED' AND […] |
How to run custom python module on SQL Server? - I am working on a small test script on SQL server 2022 using python module. The module does the simple calculation of pi * 2 (3.1415926 * 2). The test script does not work with MouleNotFoundError when using the custom module. While the test script worked fine when same python code was directly imbedded in […] |
Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps - Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps and Pre requisites to optimize Query Performance and CPU Usage |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |