I'm at loss here - just tried it on my own server, resetting session completely even and bcp not trapped - bulk insert is logged fine (once I add the...

better give us the extended events script - it's likely it needs slightly different capture settings and a few of us here can help with that.

all information is on the manuals at https://docs.microsoft.com/en-us/sql/relational-databases/replication/sql-server-replication?view=sql-server-ver15

more specifically you wish to look at the supplied stored procs which will allow you to do all work. full list here https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/replication-stored-procedures-transact-sql?view=sql-server-ver15

with...

for a standard normal DBA no - for you and based on your interaction here over last few years I would say it will add a lot of work

and if all this is within a transaction scope why not use a temp table - if created and used within the same transaction it will be available to all...

datetime DOES have a format on convert - and that is what is causing it to fail.

format 1 is US - so date string should be...

datetime DOES have a format on convert - and that is what is causing it to fail.

format 1 is US - so date string should be on format "mm/dd/yyyy"

for YYYY-MM-DD...

the truncate sp needs execute as owner.

the sp that calls it does not need to have "execute as owner" - only change you need to do on that one is...

either ALTER table or execute permissions on a proc that does the truncate like the following

create procedure TruncateMySchemaTable
with execute as owner
as truncate table schemaname.MyTable;

no. not the best way, neither the minimum access - its more like FULL access.

grant control on a table is a SUPER SET of permissions that include ALTER (which is...

• This reply was modified 5 years ago by frederico_fonseca.

you may be right - issue here is that the process is backing up all databases and outputting all commands to log - and it shows truncated.

so backup would have...

if you go from Access to SQL and with 8 users you most likely will be able to work well with a 2 vcore and 8-10 GB ram - won't...

date(o.created_datetime)

change to

convert(date, o.created_datetime)

if(od.amended_quantity is not null, od.amended_quantity, od.quantity)

change to

case when od.amended_quantity is not null then od.amended_quantity else od.quantity end

regarding "and date(o.created_datetime) >= '2020-04-01'" - this should be changed as using...

attach that as an image or text and someone may be able to help - and do explain what you trying to do

try values instead of value