name won't matter - but the version of it must match the server version (unless changed in recent versions)

so on the download for PBIRS January 2026 you also have a...

would be great if you did bother to google for the error

https://www.sqlservercentral.com/forums/topic/ssis-warning-global-shared-memory/page/2

multiple explanations and a solution - and regardless you can and should ignore that warning/error - its only for...

declare @LastKnownRowVersion varbinary(8) = 0x00000000000007D3
SELECT * FROM YourTable
WHERE RowVersionCol > @LastKnownRowVersion;

but both varbinary and binary are the same - only difference is that (as per manual)

A...

use varbinary

@Grant - purpose is normally to use it as "what has changed since last time I did ETL..." so the last rowversion used is stored elsewhere - and can't...

Hi , i installed winscp on my pc, added it to GAC thru vs (i think a developer script) on my pc as well, and added a reference to...

Ola's index script DOES NOT allow for datacompression as a parameter.

while anyone can change it and allow for that to be supplied as a parameter, this is not desirable, nor...

easy to check - why not try it out instead of asking someone to confirm what you found - or read the code itself.

it depends.

• how frequently is the direct access. tooo many calls is a good pointer to bad application design (depending on application)
• is it doing...

its getting tiresome that you @semolina keep posting same information prior posts already gave, just for the sake of showing off. if you don't have new information to supply refrain...

see this link https://learn.microsoft.com/en-us/sql/relational-databases/tables/manage-retention-of-historical-data-in-system-versioned-temporal-tables?view=sql-server-ver17

scroll down to "Use custom cleanup script approach"

price should not be the reason - there are some free tools to use. and others (like EA from sparkx) isn't that expensive.

hum... I would query the client and see how they are loading the file (to whatever system) and what are the chars they consider NON UTF-8.

or is it that they...

• This reply was modified 5 months ago by frederico_fonseca.

go read the manuals. your comment shows a lack of understanding of what the openrowset command is so you need to study it

you can backup the db to a UNC share - so if she has permissions to do backups, permissions to share a drive with the SQL Server account then she...

I would say it isn't setup correctly on the NAS.

as you are using a SP - check that the SQL Server account also has required permissions, not just the SQL...