That's done it, thanks!

The smiley face emoji threw me for a bit until I looked up the net use syntax!

You might also want to check the memory limitations for your edition and version before you start throwing too much memory at the problem:
https://msdn.microsoft.com/en-us/library/ms143685(v=sql.105).aspx

Although obviously...

Thanks Ness but I don't think that solves my problem. The user has the exact same permissions (member of db_datareader only) on another database on the same instance and is...

Hi, I appreciate this is a pretty old thread but did you ever get to the bottom of this? I'm experiencing the same issue - a user is a member...

Hi Stan

Really useful article, thanks.

I have a question around the long term use of this solution. I've done a bit of testing and the subscription still seems to work even...

try this...

DECLARE @ORDER TABLE (SUPPLIERID INT,

ORDERPRIORITY INT,

STOCK INT)

INSERT INTO @ORDER VALUES (1, 1, 5), (2, 2, 4), (3, 3, 51)

SELECT * FROM @ORDER

DECLARE @QUANTITY INT...