As the others have indicated, you need to give us more information. How did you find out indexes were missing? What process, error...

Daniel Bowlin (1/19/2011)

---

The administrators of Area 51 have decided that since everyone knows about them that they are going to hold an open house on April 1st in an...

Ditto to Lynn's comment.

I've found that if there's network connectivity disruption during a file move, that the connection on my side doesn't necessarily know that it's been broken. So the...

I'm not sure I understand the question. Did you actually create the indexes? If so, are you sure they actually created and didn't just error out?

I don't see them in SSMS either. I think this is probably the way it's supposed to be.

Does the .dll need to be registered?

What you want to do can be as easy (or as hard) as you want it to be. Look up SSIS tutorials on Google or Microsoft's websites. Books Online is...

I should add that this Date table is based off a Named Query pre-exists in the DSV, so it's not one I'm creating from scratch.

And I could do one on auto restores to another instance / server. If you wanted something that comes after the basic.

I've actually seen people use the data file extension for backup and vice versa. Then they complain when they can't restore because they grab the wrong one.

<headdesk>

jcrawf02 (1/18/2011)

---

Not sure I'm following the paradox of the free range chicken. Are you saying it's a paradox because they no longer roam the great plains in vast flocks, covering...

Ba-DUM-da (Cymbal crash)

Steve,

I just tried what you instructed with the Unknown. I actually had the Unknown Member already set to Visible, but I missed changing the Error process part of it originally....

Okay, I don't think these scenarios will work, but maybe I'm just confused. Let me try to re-phrase what I was trying to say earlier and see if I'm missing...

How's this for a job title?

"Potential Linux Administrator"

I kid you not. I saw this advertised. There are so many jokes I want to make about this...