I investigated and came to this conclusion too....

Thanks for your $0.02!

Solved!

I went into the registry with regedit and looked up the key that I needed to edit. I gave "all users" full permission and then it worked!

Thanks for your input,

Hmm, yes I see that I was misinformed or sleeping during training.... probably the latter :doze:

I am going to buy the Professional Microsoft SQL Server 2014 Administration book; we already...

It was a typo indeed, I meant DROP LOGIN [test-login].

I did solved it by the way by your suggestion to run it directly, then it worked well... it appeared that...

Thx for the replies. I understand that there can be gaps indeed, but suddenly a gap of 1000? It was never an issue before in SQL, it started in SQL2012....

I am not an expert at all, but we have been running SQL Server (currently Enterprise 2012) for a year or three under VMWare and we are very very very...

Hey guys,

Thanks for all the feedback. Got to read it all and see what to do...

Thx

Will test, thanks!

We noticed that once we remove the tablename (catalog) from the Linked Server, we can't reproduce crashing anymore. Maybe this will solve the issue? Any other feedback, background info etc....

All our servers are in the (same) datacenter, all are in VMWare, and with all SP's and updates. When I check latency with PING it's always less than 1ms. We've...

Thx!

Hi,

Thanks for your reply, was afraid this would be the outcome.

The reason I need it is: my users can create a "campaign", and based on what's needed within that specific...

That simple eh...

Thanks!

Raymond

Thank you all.... wil test your suggestions on Monday!

Ray

It would work indeed, but I'm hoping to find a better way

Thx!