Thank you so much! exactly what i was hoping to hear!

John,

Good point ! That would be my luck!

Thank you both so much !

HI John,

Yes, the both indexes are on the same column. Probably the best thing to do, let vendor fix it.

Thank you!

Gail, Thank you so much for the reply. Would you have a recommendation on which index to delete? i am thinking i would keep the 'UNIQUE' index.

Thanks again !...

good idea ! thank you !

Hello,

Unfortunately it has 3 fields and none of them are date fields to help determine when added

juanita

HI..

Well I can easily delete the transaction but in a few days we will get a new transaction... but the profiler idea is a good one. I think i will...

hello !!

it was an old server that was trying to make a connection and nobody remembered about it...

Thank you so much !!!

juanita

Sorry everyone, i just realized I posted this under sql 2005. sql 2005 would at least give me more info if i could be so lucky for this to be...

Hello,

I am trying to modify a newly created ssis package. I understand I have to go to BIDS to do this but where do I do this?

I read in...

HI,

I am experiencing the same where in BIDS under solutions explorer, there is nothing to right click on??

Juanita

HI,

Thank you so much... I ran the backup in query analyzer and see the messages.. looked in the output file that the maintenance plan creates and no messages there. But...

Manu,

You were right! I actually applied sp3 to my desktop and REPORTS are there now. I have never applied a sp to my desktop to upgrade sql server component.

Thanks again!

Juanita

HI,

No, I didn't apply any patches to management studio on my pc. Is that what you are referring to?

all of my actual sql servers have the most current patches.

Juanita