Take it

SQL Prompt is working on a personal license. I'm not sure how it would work if you use lots of machines, but you certainly could have it on a single...

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...