I side with Hugo here, you shouldn't need the log file. In fact, you probably can shrink this down as low as possible for your database. I'd guess 1MB would...

SQL Prompt and Search for me. Of course, I work for Redgate, so I get the former.

I change fonts usually to make it easier to read.

That may be the biggest...

Apologies, the hex value wasn't well formed.

I've changed this to return 000 now

bump

bump

Bump

bump

eccentricDBA (2/9/2016)

So I think there is a great value in Democratizing data. However, how do we do it and ensure privacy?

For example, at what point do we loose our privacy....

If you use SQL authentication, then the AD and domains don't matter. The name/password combo works for logging in.

Thanks for sharing. That's a good way to track these errant processes down.

I'd still disagree. There are more and more tools available that allow small groups and organizations to do lots with data.

You are welcome. One thing I'd watch is the msdb backup tables. If they're issuing commands through there, you should see things logged. Make sure no log backups in there...

As mentioned by Jacob, you need three IF statements here, not a CASE.

IF @client = 1

delete table 1

else if @client = 2

delete table 2

The DELETE cannot take...

Robert,

You said aggregation favors the large. I disagreed. Aggregation can happen cheaply, and with individuals because of low cost computing power and remote access to records.

In terms of the politics...

The way things work is that log chains are separate from full backup chains.

For example, if this happens:

Full backup Monday, 11:00pm

Full backup Tuesday, 2:00pm

Full backup Tuesday, 11:00pm

And I have log...