Viewing 15 posts - 226 through 240 (of 1,496 total)
DECLARE @FilePath ...
August 3, 2023 at 10:53 am
The reason why I'm calling it is that there's near-zero adoption of 2022 development servers.
I play with SQL2022 on Docker Desktop - maybe other people are doing the same....
July 27, 2023 at 4:10 pm
Using a sequence, can a process get a set of 5000 values
How to return multiple sequence numbers with sp_sequence_get_range - Simple Talk (red-gate.com)
July 13, 2023 at 7:40 am
Try checking the ODBC data sources with odbcad32.exe. The 64bit one will be system32 and the 32bit one will be in syswow64.
The ODBC data sources might be referenced by the...
July 11, 2023 at 6:32 pm
I would like an option that it will not try to backup the log when there is no full. But I can't find it.
I think Ola Hallengren's Maitenance...
July 10, 2023 at 2:26 pm
As I am sure you are aware, extensive testing, including stress testing, is key to any migration. Personally I would be loathed to put any critical production systems on a...
June 17, 2023 at 8:12 pm
It is a lot easier to get recent backups from the tables in msdb:
June 15, 2023 at 6:41 pm
I have had a similar problem with Install-Module. What I installed only seemed to work correctly from VSCode so I gave up using the ISE. As I will soon be...
June 13, 2023 at 3:12 pm
Some basics of version control can be found here:
https://www.sqlservercentral.com/books/sql-server-source-control-basics
Git is also worth looking at and integrates with Azure Data Sudio:
https://www.w3schools.com/git/
Even saving files on OneDrive can help as it...
June 6, 2023 at 5:42 pm
You are going to have to read up on this yourself as it is too involved for a post.
Personally I would not have a SP acting across two databases with...
May 30, 2023 at 8:03 am
More information is required. What is the error etc. When using Service Broker you will have to monitor it in case it stops throws errors etc. You should get out...
May 28, 2023 at 6:48 pm
These are backups taken using the SQL Server VSS Writer service which was presumably invoked by whatever backup software your infrastructure team are using to back up servers. If you...
May 26, 2023 at 10:47 am
The combination of [Item No_], [Variant Code], in BBI$Barcodes, is obviously not unique so you have to find some way to make it unique. eg If BBI$Barcodes has a DateAdded...
May 26, 2023 at 9:11 am
May 24, 2023 at 7:47 am
Viewing 15 posts - 226 through 240 (of 1,496 total)