I believe it won't be related to your issue but who knows. It might be.

Applying the same configuration for a database, even tough nothing changed will result in plan cache...

Time flow like a river and history repeat.

See this article, it use EFS natively from windows

http://www.sqlservercentral.com/articles/Administration/implementing_efs/870/

If you wish to encrypt backup only, you can go with VDI, but you'll need some programming knowledge to implement...

MSI, our installation process call the SQL Server setup process with parameters for a silent installation.

Here's the summary file.

I've empty out dates, sensitive data and instance name that could pinpoint who it is. Other than that everything stayed the same.

This is a new fresh installation,...

Were you able successful in getting past that error from the command prompt? Had the same on R2

(Yeah the post is 2 years old...)

This is true, at least for 2k8 and R2.

When having one, something has gone terribly wrong with the SQL Server instance.

I've notice this file is created only under critical situation,...

Thank you very much for the answer, I know understand what's going on.

Unfortunately, there's seems to be no "Showplan XML: Completed" event or something similar in the profiler to get...

This is a quite a subject regulations, but to make it short, as long as the wallet is not involved mankind do not move. Why should they (risk of a...

I understand your point of view about sometimes a row might be missed. If I compare a nuclear plant for instance with a web forum, I understand that one's highly...

There's even a compiled plan of that stored procedure! Which shows as empty.

The requested actual plan from SSMS is empty and the estimated one give a 0 operator cost.

Yet having...

I also had that issue a while back.

It's probably not as restricted as what I'll list but this is what I've observed so far:

Not machine dependent (happened 3 times on...

Technical details are one thing which don't matter really to me. It's a great opportunity to learn.

What's the basic, and I believe it applies to any jobs, is how do...

Thank you for your reply,

I've read the article but so far there's no mention SSRS supporting this functionality.

What I'm unaware of is does SSRS support also UDDT?

Do we need to...

Thanks to both of you! This will help me very much!