Moved to SQL 2000

govindarajan69 (4/21/2014)

---

Hi All,

Our company procured MS SQL Server 2008 R2 with 5 CAL. I installed MS SQL Server 2008 R2. How to ensure that only 5 CALs are...

I don't think this is the case. Public should have very few rights, and I'd be surprised at this. Public has few rights, and I wouldn't expect this to be...

I tend to agree with jasona.work here. You may or may not mask or relieve some tempdb issues with a second instance. There isn't a hard and set rule...

CDC is an enterprise only feature as well. That can be an issue.

The CDC stuff can get complex and be cumbersome to deal with, especially with DR environments. Make sure...

You can use the UPPER() or LOWER() functions to force case for a comparison.

A few things here. You say log drive, but I think you mean log files. Is that correct? The drive is the letter/path designation your Windows host sees. Like c:,...

nlion84DBA (4/21/2014)

---

Our shop is has taken virtualization to almost an extreme. The VMWare team has modified configuration files so they can build a SQL Server from the ground up...

Eric M Russell (4/21/2014)

---

In addition to the general advice "never stop learning", another piece of advice is "never stop browsing the job posting sites". The career advice dispensed by your...

Thanks.

When I was 12, I still wanted to be in law enforcement of some sort, though I had...

This might help. Not sure if it's exactly what you need, but if it's running, this can determine some information: http://blogs.msdn.com/b/taylaf/archive/2010/01/25/determine-the-currently-executing-statement-in-a-long-running-sql-stored-procedure.aspx

If you have a trace or eventing set up, I...

Greg Edwards-268690 (4/19/2014)

---

Steve -

Although attention to details is part of or job, I wonder if something could be done at some time to at least pop up a message that...

There's a lot to this.

First, encryption. I'd do the encryption on the data load. If not, then potentially you are storing data that compromises your security. You can create...

Encrypted data needs to be stored as varbinary. You cannot also store the decrypted value.

However, if you also store the decrypted value, there's arguably no reason for you to encrypt...

It's yours and thanks.