Viewing 15 posts - 226 through 240 (of 1,494 total)
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
In SQL Server UTF-8 collation is only available with SQL2019.
With SQL2016, you might be able to get away with importing into a varchar with a French collation. (eg French_100_CI_AI)...
May 23, 2023 at 2:29 pm
You will get a quicker reply if you post consumable test data:
CREATE TABLE #t
(
emp_id int NOT NULL
,check_in datetime NOT NULL
...
May 22, 2023 at 10:10 am
Viewing 15 posts - 226 through 240 (of 1,494 total)