GRANT view definition TO [uRole_ViewDefinition/useraccount];

• why haven't you launched that question at the individual sites ?

someone must have granted at least read to public ( for the tables ).

• This reply was modified 3 years, 1 month ago by Johan Bijnens.

Thank you for the feedback.

Your assumption is incorrect !

It needs the space, not according to backup size, but according to the size of the files of the original database !

Sequence should be:

1. check available...

Best practice is hat match the SIDS. (or you'll have to fix that with every failover )

Easiest way to do that is do use DBATools (free)  Copy-DbaLogin

You can restore any kind of db as long as you have a FULL backup (and the needed diff/log restore to get it to the PIT you need).

After the restore,...

• This reply was modified 3 years, 1 month ago by Johan Bijnens.

why do you need to convert to char(8) ?

where CONVERT(DATE, CONVERT(CHAR(8),[WED] ))

What's the data type of your column [WED]  ??

Rule number 1 ( with ANY RDBMS ):...

SELECT M.mailitem_id
     , M.profile_id
     , M.recipients
     , M.subject
 --    , M.body
 --...

• This reply was modified 3 years, 1 month ago by Johan Bijnens.

DBownership also by the same account ? ( check when primary on instance )

Read this: Author Jeff Moden - Article:  Tally OH! An Improved SQL 8K “CSV Splitter” Function, http://www.sqlservercentral.com/articles/Tally+Table/72993/

Example query:

SELECT ACC.ts_easeofworking
      ,...

• This reply was modified 3 years, 1 month ago by Johan Bijnens.

Read this:

Author Jeff Moden - Article:  Tally OH! An Improved SQL 8K “CSV Splitter” Function, http://www.sqlservercentral.com/articles/Tally+Table/72993/

Example query:

SELECT ACC.ts_easeofworking
      , GOM.ts_easeofworking
 ...

• This reply was modified 3 years, 1 month ago by Johan Bijnens.

If that is a business rule for your database, you should enforce it in the database. ( mainly to avoid manual mistakes )

ERD:

Drivers - id/name/...

Busses -  id/LicensePlate/Capacity/...

DriversBussesAllocation - Date/DriverID/BusID/... -->...

did you try adding an OUTER APPLY ( with e.g. DelimitedSplit8K or string_split ) to your queries to handle the multi valued column ?

Tell your client Microsoft advises this "Data Migration Assistant"