I have no personal experience with Asigra, but I have worked about a year for a company that offers backup solutions based on one of their competitors (Ahsay). I assume...

I need some help in this topic.

Short story: OP tries to give users access to a view but not to a base table. First went about this wrong (different owners,...

Hi Arbra,

My apologies for the delayed reply.

The problem you are seeing is caused by ownership chaining. Or rather, lack thereof.

So what is ownership chaining? It is a bit like the...

Thanks for posting the repro script!

Here is one way to get the results you need:

WITH Denormalized

AS (SELECT PersonID,

...

Lowell (4/8/2016)

---

another reason to avoid them: Linq To SQL and Entity Framework side affects.

we just had an issue with transactions rolling back without any SQL error;

the issue was a linq...

Some examples off the top of my head:

* Auditing (depending on the exact audit regulations - in some cases, triggers...

Without CREATE TABLE and INSERT statments I cannot test anything, but my gut feeling is that you will end up with a pattern somewhat like the below:

SELECT List, the, columns

FROM...

Pop music

I personally...

szejiekoh (4/7/2016)

---

q1) Can I know the rational/reason behind on why full backup with transaction log will not allow the truncation of the transaction log ? (-- at least on the...

I am at this time not able to look at your problem in detail. But one thing in your description points to a possible explanation.

Cached execution plans are stored along...

Unless specifically stated otherwise, SQL Server express installs slightly different than other editions. Most editions will by default install as a "default instance", which means you can connect to them...

Eric M Russell (4/7/2016)

---

By default, a new login has access no databases, and once granted access, they cannot select from anything.

To maximize security, I'd suggest first creating a view that...

Check the setting of the server level option "backup compression". If it is off, change it to on.

Also check if your backup scripts use the default server option for backup...

Nor should you. In production code, I would always write out the explicit intent instead of relying...