It can, make sure the server is loggedoff and try thru a job. If you SQLServer itself is not running then when you execute by hand (not thru a job)...

Hey GRN that is where I was originally headed if you look at my previous example, but based on his example expected output he is wanting the data based on...

If you could post your cursor we can look at offer suggestions since this will give us an idea of what exactly you are doing.

"Don't roll your eyes at me....

Generally this comes from some sort of conflict in the connections parameters. For instance if the old server has a connection called NewServer then the package may fail on the...

Hey Dan I don't believe that RAID1 is any different than RAID5 on reads, it is writes where 5 is slower due to the parity it writes.

Also noodles is the...

Sorry about the sumofhourscharged that was from my test item. Anyway considering what yout gave try this.

SELECT

*

FROM

(

SELECT

[No],

ITEMCODE,

AMT,

AMT + (SELECT ISNULL(SUM(AMT),0) FROM Sl iT WHERE iT.AMT > oT.AMT) as...

quote:

---

and if its to do with index sorting etc

---

That answer is no. What it is...

Sorry to say this one is a bit overkill

quote:

---

Select customerID from customer_data where customerid not in (select customerid from customer_log where...

So far myself I have been lucky in that a very few number of our databases have a restore commitment of less than 24 hours and those that are are...

1) Agreed, especially with maintainence issues of SQL 7 and 2K are far superior and they are full supported currently by MS. W2K has it's advantages over NT4 but no...

Your best bet is to get a packet sniffer on the box to monitor the packets and see if anything specific happens. Also can use netmon but I have not...

Do a trace on the DB activity with an update query that should not cause the trigger to fire.

"Don't roll your eyes at me. I will tape them in place."...

The only problem thou with parallelized queries is they have to meet a threshold on the server before this occurrs (this is definable but default is usually best). Also to...

Can you provide an example. This is not clear to me.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

It is based on time value sections.

Ex.

run_duration = HH:MM:SS

1 = 00:00:01

335 = 00:03:35

102456 = 10:24:56

Hops this helps.

"Don't roll your eyes at me....