bpowers (12/7/2009)

---

How can I accopmlish the following? I want to update the Cust_Line_Del table based on information from the Cust_Order_Line and Customer table. I am not sure how to join...

sql_lock (12/7/2009)

---

You could try changing the recovery model (if you operational policy allows it).

If you do change the model then be sure to backup the db (after you set back...

Please post sample data and table schema.

The two should return the same results. It seems that some data may be amiss, or maybe a setting in the linkedserver setup.

It...

NewBeeSQL has hit it on the head.

Do you see commonality between the ones that were successful versus those that were not successfully transferred via your script?

Also, have you checked your script to see that the 71...

sureshdeenu (12/7/2009)

---

the servers are not side by side, wht I did was, Selected all jobs(ctrl+A)->Rt.Click on it-> open script. Copied this script and executed on SQl 2000 server, but I...

Please post the view, sample data, and table structures. This will help in coming up with a legitimate answer.

You may be asked any question that is in line with SOX compliance. You have made the security changes based on SOX guidelines, you can bet you will be...

Once you layout the code in a readable format, I think the error and resolution will become obvious to you.

As Gus said, you are missing some spaces. Remember that...

ROFLOL

jason.stephens (12/7/2009)

---

GilaMonster (12/7/2009)

---

A rough rule-of-thumb, given by a former program manager of the storage engine is around...

The user would need to exist in a place where both nodes could reach it. In a cluster, you would be better served to add a Domain User. ...

Many jobs or just a Single job?

Side by Side upgrade to SQL 2005?

One option could be Redgate Data Compare - and compare the MSDB database (sysjobs,sysjobschedules, sysjobsteps, sysjobservers, sysjobhistory).

Too bad it is gone now - probably U2 drivers. Tried to respond to it - but I think Steve got to it.

Antiquated