I am trying to write disk space report script without using XP_CMDshell and OLA SP's.
3 weeks, 4 days ago
I have some issue with execute procedure with new certificate .
We have inside procedure WIT…
3 weeks, 5 days ago
Can anyone assist in resolving this error (Attached Error)
I did have the Linked Server working on …
By: Jeff Moden
Is it possible to grant a regular user (domain account) read/see user accounts and SQL agent jobs?
I want to remove 6 digits and 8 digits from a text column see example in picture
There are 6 dig…
Error - Conversion failed when converting the varchar value '+ cast(@BookId as varchar(Max))+' t…
3 weeks, 6 days ago
BookId & StudentId has int DataType
ALTER PROC [dbo].[USP_SessionBookPlanningSearch] --'0','20,…
4 weeks, 1 day ago
By: Jonathan AC Roberts
I have a linked server from SQL I have updated the Excel spreadsheet and when I run a query on …
1 month ago
We've ventured into the world of AAG's as we have now moved across to SQL2019. We have a Pri…
By: dennis.miller 20021
If I setup log shipping for a database, and I want to do a manual transaction log backup for some r…
I setup a staging environment to test basic always on availability group on SQL servers standard Ed…
I have a target server that I have read-only access to with Windows authentication. We'll call this…
1 month, 1 week ago
I am having error in creating AG Group Listener. We finally try to create one from Failover Clu…
My requirement is to to take full backup of the databases in below two production enviro…
I am really starting to regret upgrading to SQL2019. I had to install SQL2017 Express along side of…
Viewing 15 topics - 31 through 45 (of 832 total)
You must be logged in to create new topics.