Off the top of my head there will probably not be a fail-over. Your users may experience some lost connections.

But as I think about it I don't think the...

You can do some conversion from varbinary(max). But I guess the question is, what are you trying to do? What is your goal?

CEWII

I have been spending a lot of time playing with the XML data type in SQL lately. And I have been largely UNDERwhelmed with the performance. I would...

Deprecated yes, unavailable NO, you can still get to the configuration. In the properties of the package there is a line labeled Configuration and an ellipsis to far right,...

The full backups should not affect the log shipped databases.

CEWII

That was my question as well..

CEWII

sreekanth bandarla (12/10/2013)

---

What version of SQL Server you are running on? If 2008 or above, you can simply turn on TDE at the database level if that's Okay with your...

Cpt_Picard (12/9/2013)

---

Thanks for your reply!

All the email accounts are to individuals and not distro list(s).

The To box contains: username@example.com;user.name@example.com

I am also asking my exchange admin to check...

That is a yes/no question. The answer is Yes BUT you can't do it without some work. You'll need to write a SQLCLR to do it that way....

Does MS still offer upgrade pricing? Like you own SQL 2005 but you want to upgrade to 2012, we'll sell you the license at a discounted price and you...

Lynn Pettis (12/9/2013)

---

Not completely true, if...

If they are a member of the sysadmin server role you can't. My understanding was that effectively that role bypasses all security checks, so even a deny would be...

In most cases the schedule will be set by the business and that schedule will be automated so the DBA probably won't be doing much with it.

For me, most of...

Who owns the job?

CEWII

A bak file (provided the backup uses the normal convention of full backup files carry the bak extension) contains ALL the needed data to restore the database.

So your question is...