SSCNewbee (7/23/2012)

---

Hi all my package was running good until last weekend where i'm getting the following error

Message

Executed as user: AD\MOSS_BI. ...te Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft...

GilaMonster (7/23/2012)

---

Why delete it? Does restoring mean that you'll never need to restore that backup again? What happens if the production DB fails and you need to restore full and...

Please read the following article, it...

Jeff Moden (7/22/2012)

---

Nagaram (7/22/2012)

---

Jeff Moden (7/22/2012)

---

There's a question in my mind that's still outstanding about all of this. Do you just want to return a...

Or you could do either of the following:

begin try

create index IX_NotNullID on dbo.TestUpd (

TestUpdId,

...

Realizing I have an unnecessary join, this would also work:

if exists(select 1

from sys.indexes i

...

Then you need to do something like this prior to the CREATE INDEX statement:

if exists(select 1

from sys.tables t inner join...

Welsh Corgi (7/22/2012)

---

I determined that if the Index does not exist you will get the error no matter what.

You have to first create the Index and then execute with that...

From what I can tell reading BOL, this is as designed.

DROP_EXISTING = { ON | OFF }

Specifies that the named, preexisting clustered, or nonclustered is dropped and rebuilt. The...

It is much more helpful if you surround the...

A little difficult to understand what you are requesting, but if what you want to prevent is that a Salary amount can't be less than 500.00, all you need is...

Looks to me that you have enough information to answer your own question at this time.

NOTE, the 6 seconds I talk about above is not for all the code, just the code returning records with a count of 4 or more in a 24 hour...

Doesn't tell me a thing. I don't know what the table is nor do I know what or how...

Not enough information to give...