yes - you need to create a login from credential (not login from windows) and then add that login to the required dbs as needed

it would be better you show us the code you are using for this as well as details of server/version

and what was the fix? its good to post the solution in case any other users face the same issue.

Sharing a report does not require a PRO license only - only PUBLISHING a report to a server requires that licensing.

Assuming you are talking about using powerbi on cloud -...

No... its Sunday... special extended weekend 🙂

regarding the update to null - depending on the frequency of that table being updated you may be able to create another table with same structure (including indexes), insert all...

spam again - we really should block this thing

info is on MS licensing document itself - if that one is wrong ....

you buy the license for 2019 - and that license allows you to install 2016 as part of downgrade license terms.

see https://docs.microsoft.com/answers/storage/attachments/96089-sql-server-2019-licensing-guide.pdf - page 39

so you to install sql 2016...

that ONLINE=ON is whats causing all that growth and elapsed time.

you should also add sort_in_tempdb = on.

and... the DDL you supplied does not include the filegroup it is being created...

and information about how you are running the index creation - within a transaction, multiple index being created or just one, online or off line, sort in temp db or...

google has lots of examples - so which ones did you try and what was the result.

its not like YOU trying it will cause any issues - and you will...

you are aware that this has been answered rather often and that what you need can be found with a simple google search - not to speak on the old...

Remember, too, that the logical data model should be easily understood and use by business people.  In fact, if possible, keep all developers out of the first...

replacement for format to return just yyyy-mm-dd (or yyyy-mm) is easy - convert(char(10), datefield, 121) - change the char(10) to char(7) to return just yyyy-mm - but as mentioned...