I find it easier to write to capture useful details while I write my script...

Thnx Jeff..

In which version of sql server did u run the script?

YEs , It's fixed. Thanks Gila...

select a.[Database Name],a.[Type],a.[Size in MB],b.LastUserUpdate

from

(

SELECT [Database Name] = DB_NAME(database_id),

[Type] = CASE WHEN Type_Desc = 'ROWS' THEN 'Data File(s)'

...

Guys

The below query works. I think per CTE, before "AS" we need to add the column names which were missing. I chose Option #4. Not sure, why Option#4, is not...

HI Lowell,

Please suggest how to capture DML operation here.

Thanks

Sourav

🙁

Yes, I got the issue and fixed it. 🙂

Thanks.

I will share with you my final rebuild index script.

please suggest if you see any correction or modification neeeded.

Cheers

Thanks...

When you pasted the script here, are you enclosing

Code

/code

For the proper indentation and color as is in SSMS?

It was not clearly mentioned about the schema!!

I hope that the question should be loud and clear , rather for users to guess around

Ah...got it. you're right. Many thanks. I will try tomorrow and will let you know how it goes. But what you said is right for sure.

No Error.

I was expecting the raise error function to be thrown if the option was not provided correctly. It only printed the message in the ELSE block.

Can you help me...

Hi

Can you please share the script???

If this could have brought the details for all the DB's would have been highly useful.