Here is the updated script.

I have also updated the online script, Just waiting for it to be published.

/**

Script: list all Usernames, Roles for all the databases.

Author: Shiva Challa...

This issue did not reoccur yet. but my concern is that it might and i dont have any explaination of what happened.

Do any of you good folks at sqlservercentralville...

Thanks Cathy !!

Do you mind if I add this to the online script?

For 2000, you...

You can't run this script on SQL...

Key DBA (8/28/2008)

---

I get the following error when running the query against one of my servers:

Msg 102, Level 15, State 1, Line 14

Incorrect syntax near '-'.

(260 row(s) affected)

(260 row(s) affected)

......

Hi Jeffrey

You just made my day!!!

Thanks a lot for this info.

My hunch is that its an authentication issue.

You can test it in two says.

(1) Try using "Be made using this security context" and enter the remote Login and password....

When using "Be made using login's current security context", SS2005 will use your logged in userid and password. If this is working on your server, where is it failing?

by using...

There were some miscellaneous characters in the below statement that was causing that issue.

I have attached the image highlighting the code that have those characters in it.

Also, I have...

You should install Oracle 10 64bit client.

You have to install a 64 bit client (or any app for that matter) on a 64 bit machine. It doesnt matter which...

Thanks for your help GSquared!

Thanks GSquared!!

so, its like a copy of the existing index is created on tempdb while the original index is being reindexed in online mode?

thats why you see the tempdb...

Thank you Ola Hallengren...

I will check it out.

Hi GSquared, thanks for the response.

This happens during an idle time, 3:00 am.

But I cant change the script for this alone, its automatically generated as a part of Rebuild...