Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2017 - Administration |
Migrating Always On cluster to new Domain and cluster - We are in the process of migrating to new Windows AD. What would be the best approach for this with minimal down time? Essentially we have several databases in AG on different nodes and a single listener name. The idea is to move to new Windows AD/new servers and retain the listener name. Normally if […] |
SQL Server 2017 - Development |
Rules based updates - I found an article that is very similar to how I would like to apply business rules to update my table. I will have 4 colname values I would like to use: Channel,ShipFrom,ProdLine,CustType Channel -- Will be only 2 values ShipFrom - Could be single entry, or ALL, or ALL except(xx,xx,xx) Prodline -- All(*), or […] |
Missing abstrophe in dynamic SQL - Hello , I haven't been able since morning to find how to add the missing abstrophe in my procedure that uses dynamic SQL I added a print in my script to display the exec instruction and I have a missing apstrophe in the name of the proc Anyone have an idea please? USE [test] GO […] |
SQL Server 2016 - Administration |
'Alert- Sev17 Error:Fatal error in resource limit exceed occurred' on server - Hello! I have setup SQL Audit and it is writing to the Security log in the Event viewer. It is working but getting this error message below few times a day. "SQL Server Audit could not write in security log". What can be done to resolve this alert? Thanks. |
SQL Audit in Always On Availability Group - Hello! I have setup SQL Audit in Always on Availability group (2 node) for ddl and dml to write to Event viewer. I have configured on both nodes using the same GUID. It writes to Event viewer in the Primary node (1) or when I fail primary and and make secondary primary, it works. But, […] |
SQL Server 2016 - Development and T-SQL |
Filetred index - \hello Guys, Mayyou help wuth the corect index filetred creation using modulo? The query need to assist is select col1,col2,......... WHERE ISRECNUM % 20 = 1 and i wish to create a filtered index on ISRECNUM column which is INT like WHERE ISRECNUM % 20 = 1 . Thanks, Best Regards, […] |
Disabling backup Jobs - I've not done a lot with disabling jobs with script, I need to read the job names from a text a disable them or enable them on all servers within the environment? Is there any good examples for doing this? |
Rows won't return using where with one of the columns - Select * from tablea where comt_dim_id = 3947804 -- returns no rows Select count(1) from tablea where comt_dim_id = 3947804 -- returns count = 32 Why? How? There are no current locks in the database. The column datatype = INT. Selecting these 32 rows based on a different column value works and shows the comt_dim_id […] |
SQL Server 2019 - Administration |
PBALP User in SQL Server - Hi Everyone, Currently looking at tidying up some SQL servers and i have a number of local users (PBALP) being one of them i would like to drop. Is there a way i can check to see what if anything is dependant on that user? |
Hi everyone! - I'm Johnson, and I've just joined these forums. I was looking on Google for SQL Server Forums and found forums.sqlservercentral.com. I just wanted to say hello to everyone to start. Once I feel like I belong, I will talk more on the forum. @SQL Server Forums Munchkin Cats |
Monitor SQL Server Job Failures - Ahoi, i am usually working with SSIS and SSAS, but since there is no one else i am also "in charge" if adminsitration it seems. We have multiple SQL Servers + Instances. Now i am looking for a good/central way to monitor Job failures across the entire scope of servers/instances. Since the guy who was […] |
Notify with backup file name - Hello, I have the tlog bkp job that runs in every 5 mins. There is another monitoring job which checks if the tlog backup job runs for more than 30 mins and if yes, it should notify the same to dba via agent alerts (notifying via email). Unable to find a method to notify the […] |
SQL Server 2019 - Development |
DateDiff - Data Type conversion Issues - Hi Experts Not able to do DATEDIFF between two dates, but it works when these dates are part of ( a.ClosingDate, calc.maxDate ) CTE and in select I use DATEDIFF , My result is taking forever so I was trying to get rid of CTE so I encounter this issue. Any help please. I attempted […] |
Integration Services |
Data Collection from restful web call - First off. Sorry for formatting - on a mobile device. —————— So a little back sorry - I know almost nothing about this topic, so forgive me if I use a phrase out of turn. I’m looking at being able to pull data from a training platform and dumping it into my local database so […] |
Anything that is NOT about SQL! |
Building a front end for a database - Hello everyone! I'm a beginner with databases and I'm getting started with building a front end for my database so that end users can add/edit data. I've been trying to find information about this online but I guess I'm not searching the right words because I can't seem to get a hit. I'd really appreciate […] |