Nope, and Happy New Year to you

No real danger. Some things take effect immediately in the patch, some don't until reboot. However no issue as long as (mentioned above) it isn't a patch that tries to...

Watch datetime v datetime2 for things as well.

They should be dropped if they're not system tables. Perhaps you have an application connecting or you are running some queries? SQL Agent?

How are you checking for temp tables? Also,...

BrainDonor (12/24/2014)

---

Lynn Pettis (12/23/2014)

---

Okay, I have a question about PASS 2015. I can save a lot of money by registering for PASS 2015 now. My question is when...

Haven't specifically upgraded to 2014 for SSRS, but the data sources should work fine. The connections from applications are the same (OLEDB/ADO.NET/etc) and those work fine from 2005->2014

Upgrade SSRS to ...?

Do you mean you have SSRS only on the 2008 instance? Or are you looking to update all instances? Is this a separate 2008 instance, but connects...

Ahh, sorry. Fixed it

File operations are cumbersome in T-SQL. There aren't really extensions to do it well. Powershell works really well, and you can schedule these in SQL Agent.

Lynn Pettis (12/27/2014)

---

I am not actually complaining...

Apologies. Points have been awarded back.

This was a snippet from the stored procedure, so I didn't think about the output variable when looking at it.

Rory and Keith,

Congrats and PM the email you'd like to use for your prizes. I'll shoot them out ASAP.

I don't see 2014 certs yet, but I'd agree with Jeff, work on this. Most of the changes are in limited use, but if you learn other stuff, it will...

Please mark Jeremy's advice as the correct answer if it worked. That will help others find the answer.

You should be able to do this with the control panel above for your account.