Change OLEDB driver to MSOLEDBSQL

Thanks Brain I mix the terms up - <<"owner" (aka creator)>> is clearer.

If I take 2 backups of PList

1. with tstSVC member of db_backupoperator > c:\temp\PList_tstSVCEXists.bak
2. Remove tstSVC  from PList...

Thanks for replying Brian - I didn't explain well

I'm not testing backup/restore. This is part of a Monthly Automated Release Process.  "tstSVC" is a domain account the release process runs...

Thanks Scott

Any experience of Disk/snapshots restores on Virtual machines with MSSQL.

Say the Data files on D: drive and Logs on E: restoring snapshots/backups of whole disks via VM, does this...

I don't know our Azure setup, probably wouldn't understand it anyway

I'm going to ask to get Sendgrid setup, from what I see its free up to 100 emails per day.

Would...

Thanks All

@ken can confirm (1) backup doesn't work with expired cert.

Cannot test restore because these backups aren't used for DR but as a way of transferring data between...

Thanks Eddie,

Sorry,  I gave Wrong info. There are 2 certificates with very similar names one in Master DB and one in a user DB.  I mixed them up

looking at

            
October 12, 2023 at 8:31 am
            
#4306477

            
            
                                                
        

Thanks

I set "log extended information.." on the maintenance task - didn't know this existed

In the subplan job in Agent I set "include step output in history"

Next time it happens hopefully...

Thank you Andreas I will certainly check this out, the thread also links to

https://techcommunity.microsoft.com/t5/sql-server-support/sql-bulk-copy-error-8220-operating-system-error-code-5-access-is/ba-p/316231

Which looks promising..

Never used SQL anywhere and I haven't used Crystal Reports for many years. This is from memory so might be wrong. Assuming your tables are identical in MSSQL Server and...

Copying SQL into Excel's connection properties window and clicking refresh.

The data is saved in the workbook. If the user has SQL rights an optional refresh will work  otherwise fail but...

For a bunch of string fields, numbers you're absolutely right.

I use the last excel file, which I just go into and change the query save it and send it. The...

I know I'm not answering your question here.

I'd be mindfull about copying and pasting data from SQL to Excel because of locales; how does Excel know what format your date...

Thanks Scott

I will not use this time, but I'm going to file this away - I can see this being useful sometime.

Thanks Scot

I've scripted ALTER statements on the indexed views so I get to keep permissions. I've also included index creation as running the ALTER drops the indices.

I've not used synonym...