Steve Jones - SSC Editor (8/13/2014)

---

If someone is changing the encryption status, they're creating a lot of load to decrypt, and you'll create load to encrypt.

Don't automatically fix this. Catch...

The use database is required for the creation of the DEK, the ALTER DATABASE ... SET ENCRYPTION ON is not a database specific command, in fact focus should probably be...

No, the vendor has simply create the database user as FredBloggs instead...

its only a database user name, if you really wanty to enforce your standard then just inform the vendor

Rename a user with the following

alter user dbusername with name = [newdbusername]...

at 4 or 8 GB increments your going to experience excessive waits while the log grows.

What size does the log need to be?

Find this out and then leave it there

You're welcome

I wouldn't recommend running SQL Server 2005 on Windows 2008 either, it's frought with issues :w00t:

If you really want to though this is what i'd do (and assuming the hardware...

vsamantha35 (8/12/2014)

---

Hi,

Since I don't have a testing environment, I am seeking help on this.

In a 2-node SQL Cluster, if Node-1 is on SQL 2008 SP3 and Node-2 is running on...

Once the files are extracted you have to run the...

Philip Barry (8/11/2014)

---

Does anyone know if Microsoft does or does not support a cluster co-hosting SQL Server 2008 R2 Standard and Enterprise Edition instances?

I've been looking for definitive references either...

See my guide at this link[/url] for more info

Jpotucek (8/11/2014)

---

My SQL Server 2008 R2 setup.exe is located here:

E:\SQL_Server_2008\SQL_Svr_Standard_Edtn_2008_R2

My Service Pack 2 media is located here:

E:\SQL_Server_2008\SQL_SP2

My CU 3 media is located here:

E:\SQL_Server_2008\SQL_CU3

From a DOS prompt, I...

you're welcome

kesavan.rv (8/11/2014)

---

HI DBA's,

I have issue in starting a DB..

details:

I have created secondary log file in separate drive to perform an activity,late it was removed in DB Property.

yesterday backup was taken...

dan-572483 (8/8/2014)

---

All:

I have some VMs that with SQL Server that were built as stand-alone servers a few years ago for my own self-directed training. After buying some more powerful...