So, you just want to treat the symptom instead of the cause, correct?

The first thing that comes to my mind, and really should not be done, change the recovery model...

Just one question, did you even read the first article I reference below in my signature block regarding asking for help?

Are you saying that you have no maintenance windows in which this can be done?

Instead of posting fake code, how about showing us what you are trying to accomplish. You will get much better help if you follow the instructions in the first...

Please don't double post, it will simply fragment any responses you may get to your question. Please post responses here.

Please post your final code, as there may be a possible improvement based on what Ihave seen already.

Here is one option, unfortunately I can't test it as I don't have Northwind available.

select

o.OrderID,

o.CustomerID,

o.OrderDate,

...

mcbtiger420 (4/26/2010)

---

Hello Dear

My problem is writing Stock query problem i have project to create Stock Software...

itskumar2004 (4/26/2010)

---

Hi,

I have created a stored procedure ABC and a view in a procedure .since i can't declare variables in a view i created a stored procedure and declared variables...

Assuming that each DBA uses their Network login and this network login is given sysadmin rights only on the named instances to which they have rights to admin, then they...

Using my Tally table to provide the "rownumber" the following code is what I came up with, hope it helps:

select top (26 * 3)

N,

...

Yes, it can be automated. One way is to add an additional job step that handles the network copy.

I'm open either way, as long as it is addressed somewhere. A good place to do that may be a FAQ that could expand on the code and provide...

- Win. (4/26/2010)

---

Hi All,

Please suggest me if am doing wrong.

Am using below Query in SQL JOB to automate the backup to network path. Its working successfully.

The thing is it executes...

The best way to resolve this issue is to backup to a local disk then copy to your network resource. The network copy is more resilient to network issues...