Check the permission. Is there any permission issue? All jobs are failing with same error?

Replication will take care of all the SP and not the part of the SP. It is good that initial information comments to track the changes. If replication do this...

Did anybody gave you incorrect link?

Anyway refer following correct link:

http://www.microsoft.com/en-us/download/search.aspx?q=sql+server+2008+r2

No it will not wipe out existing data. But fill the extended files with 0. i.e. if you do have file size 100 MB with data of 80 MB and...

You can also add clause

"where/and unit <> 0"

OR

"where/and unit > 0"

check the code of job and study execution plan which will help you. Also ask your storage team to find out the details of disk issue at specific point of...

Refer this excellent article which is self-explanatory.

http://www.sqlservercentral.com/articles/FCI/92196/

HTH

Indeed a good question Andy, Thank you.

Is this production server? Do not try things on prod and make scenario worst. Do all your restore and R&D on junkbox.

Any luck with UPGRADE ADVISOR?

fyi... no need to configure 3GB switch as server is 64bit.

SAMPLE CODE, you can replace ListPrice with various file extention.

---------------

USE AdventureWorks2012;

GO

SELECT ProductNumber, Name, "Price Range" =

CASE

...

Good and easy one!

Thanks!

How about using CASE or IF...ELSE to check .txt, .xls etc.

HTH

How about using FILESTREAM?