Dear SSC Veteran,

Thanks for the reply! But, have you checked the output of query? It is same as the output given by ROLLUP.

--<><>-- --<><>-- --<><>-- --<><>-- --<><>-- --<><>--...

Yes in job history it shows all time jobs completed successfully & when I checked the Log folders then the Backup & Restore both are completed.

Dear Lowell,

Thanks for the reply.

But, in OpenRowset again without LINKED Server we can't to this process. I need Query based solution to perform this process without using XP_CMDSHELL &...

Dear Yarger,

Hi ! In your thread all is for Local system i.e. take a file from Local system & export in SQL Server of Local System.

My requirement is that...

Dear Satnam,

Thanks for your reply.

I need to copy an Image or PDF file from local computer to remote sql server either in a table field or in a...

Dear ALZDBA,

Thanks for the reply.

SQL-2005 version - Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86) Mar 3 2007 18:40:02 Copyright (c) 1988-2005 Microsoft Corporation...