Colleen M. Morrow (12/7/2011)

---

I have a login that I currently use to collect information on a SQL Server instance, including instance properties, databases and their properties, logins, etc.

A...

That would be the easiest.. If you need to do it more than once I'd save the package created by the wizard since it is really just an SSIS...

1. Integrated security is probably the best but in some cases where the web server or a middleware piece are not in the same or a trusted domain this cannot...

TravisDBA (12/7/2011)

---

Not exactly accurate. With the advent of people's medical/psychological historical data becoming more and more sensitive every day, I can think of virtually thousands of databases across the country,...

Steve Jones - SSC Editor (12/7/2011)

---

Elliott Whitlow (12/7/2011)

---

But TDE doesn't help with replication, it only protects data-at-rest and as long as the database server is up you have no visible...

I enjoyed that article.. Saved for future reference..

CEWII

Steve Jones - SSC Editor (12/7/2011)

---

Fair enough, but does it hurt to have...

Look in services..

CEWII

Ah Robert, you beat me to it.. 😛

CEWII

I typically only go EE on the OS when I intend to use clustering.. The other reasons I could think of are more than 32GB of RAM can be...

itsamarnath (12/7/2011)

---

Elliott Whitlow (12/7/2011)

---

In SQL 2008 MSDTC no longer must be clustered, but I am 99% sure that it is running on the existing nodes that the first instance can...

I am in partial agreement with TDE being on more versions, Standard sure, express, not convinced..

A lot depends on what you are using TDE for. By and large you...

Ran accross something similar last week. Not sure what you are asking here.. Why would we be working on this? SQL Injection is usually due to vulnerabilities...

In SQL 2008 MSDTC no longer must be clustered, but I am 99% sure that it is running on the existing nodes that the first instance can run on.

So no,...

You have not provided enough information to respond to your question.

These 7 sprocs, what do they do?

How do they do it?

Do they reload the report data...