Reposting msg from other thread :

chris.s.powell (12/1/2010)

---

We recently just performed this exact scenario as we were wanting to add new hardware but keep the server name and SQL version....

Moved here. plz no further posts in this thread.

http://www.sqlservercentral.com/Forums/Topic1028810-146-1.aspx

That's one of the reasons I wanted to see when it failed... my next questions would have been what's the error and what else is taking a lot of ressources...

alen teplitsky (12/1/2010)

---

no, always runs. sometimes it runs for hours. and once a month or so it gets stuck to where i have to stop it and delete data manually....

alen teplitsky (12/1/2010)

---

i...

Nadrek (12/1/2010)

---

Kwisatz78 (11/24/2010)

---

Ok I have got myself in a tiz about device CALs now!!

How does a web front end not qualify for a device CAL when all external users will...

sebastien piche (12/1/2010)

---

i belive getdate -30 return not the same values depend some configuration for me is retuen this

for sql 2000 2005 and 2008

SELECT getdate() - 30,GETDATE()

...

Is this script scheduled?

Are you getting any errors in the logs?

Are you logging the @@rowcount after each exec?

We don't have much to go on without that info...

SwayneBell (12/1/2010)

---

Hi Alan;

Someone with much more expertise than I will be by in a moment to provide correct syntax, but " getdate() - 30" does not subtract 30 days, it...

Care to post the statement and sample "not deleted" data.

Have you confirmed that the jobs have run and NOT deleted the data?

Maybe there's a weird if in the job or...

Moreover, there's no mention of functions in the explanation or the answers. Those definitions are also available in syscomments.

So I guess that none of the above is also a...

Hardy21 (12/1/2010)

---

Ninja's_RGR'us (12/1/2010)

---

Toreador (12/1/2010)

---

The first and third answers are definitely correct (the first being a subset of the third), so I went for 'all of the above'. A good question,...

Toreador (12/1/2010)

---

The first and third answers are definitely correct (the first being a subset of the third), so I went for 'all of the above'. A good question, spoiled slightly...

It's strange how the most disturbing and important post of this thread just disappears at the same time that 3rd party app post appears here!

and I'd be the first 1 to never buy this thing... so wasted effort assumin gyou're not trying to cover your tracks with that post.