My e-mail notifications (except for the newsletter) stopped working at the end of June. But it seems the problem is resolved now.

I'm going to attempt to post a 64-line script I first posted as a response in a thread months ago, as a SQL code block.

DROP TABLE IF...

Something has changed in the last week or so. For months, I have not been receiving any notifications of new topics or replies to my posts, but a few days...

I still don't really understand what you are trying to achieve.

You have a database on server A. Users can access some tables and execute some procs.

You restore the database to...

Can you go into a bit more detail regarding this 'ownership chain' you are trying to prevent?

I'm a fan of the flexibility of tablixes (tablices?) but one thing I find really awkward/annoying about them is when saving as XLS, you inevitably end up with merged...

I learned Git by working with it. There is a lot going on & I can sympathise if you're feeling overwhelmed.

Jump in and try the following

• Create a 'Database' repo...

Like you, Window functions and CTEs changed the way I write a lot of my T-SQL. DROP … IF EXISTS also makes code much tidier.

When they made Developer Edition free...

Despite this being the same error message as the original post, you should really start a new thread, as it's likely a different issue causing the same error.

You do not...

Thanks for posting back. Glad it helped you.

This is still happening. Can anyone assist?

As I mentioned earlier, I have stopped receiving e-mail notifications of replies, for some reason.

The actual procs are not named with numbers! They are named based on the tables they...

PQ can be used in many other places, including Power...

Something like this?

DROP TABLE IF EXISTS #product;
DROP TABLE IF EXISTS #VendorRank;

--Product table and data
CREATE TABLE #Product
(
    ProductID INT
  , ProductSKU INT
  ,...

Thanks, Brian. There is no parallelism requirement. The fact that T3 and T4 are at the same level implies only that they are independent of each other and can be...