Thank you HanShi, that worked perfectly!

DaveK

I got it to work.  It turns out that the proxy was not set up on the linked server where the xp_cmdshell call is executed from.

Thank you.

Sorry, I posted the wrong code.

• This reply was modified 5 years, 4 months ago by  oradbguru.

You guys are absolutely right.  Sorry, I was in a production crisis with another issue and I was looking for a lifeline to get this one off my plate.  I...

Disregard.  I just used

ALTER DATABASE [tempdb] REMOVE FILE [tempdev_2]

October 11, 2018 at 12:48 am

#2008994

Yes, duh!  I have not found one that helps yet. That is why I am asking here.

Thanks

Cool.  I will try that. 
Thank you!

David

Okay, i tried it on another instance/server and it worked fine.

Thank you!

I am just launching it from SSMS.  See attached screenshot.

Thank you!

That worked!  Thank you very much my friend.

David

I now have a drop down that provides a list of vendor names to choose from.  It works fine if I specify only a single value.  As soon as I...

Great find.  I never had any duplicate index names so it never reared itself.  Thank you for the correction.

David

The script does exactly as it is intended to do and is great for analyzing whether or not indexes are being used efficiently or not.  It excludes clustered, unique and...

Wonder if it pasted wrong.  I don't have that issue in my database with over 14,000 indexes.  sorry, I will have a look at it.

That works. Brilliant Luis!

Thank you,

David