Hi Apple.... what I meant was..... I open a Stored procedure.... add a comment statement with text.... not changing any functional code.... execute the Stored Procedure.... it runs successfully.... I...

Thank you for the reply/information. I actually have been trying to get management to let me install the "Ola" script for a long time now.... but..... did I mention it...

Thank you for the information and advice.

Charlie

I actually tried that.... still did not seem to finish. I was thinking about running T-SQL code stating to run OFFLINE. I had tried to run from Management Studio by...

Great! Thank you very much for the information.

Charlie

Thank you for the explanation.

Charlie

Hi Andrew,

I configured the "Data Collection" located under "Management" in SQL Server Management Studio. There are three reports that are set up... Server Activity History, Disk Usage Summary,...

Alan,

Thank you for the code.... it worked great!

Charlie

Erin,

Thank you very much for the information!

Charlie

Thank you for the information OPC. I am sorry... I meant db_owner.

When you go to a table in SSMS and right click on the table and left click on DESIGN

Hi IgoMi,

I have a lot of Space on the tempdb. The tempdb is located on a SAN. I was Rebuilding offline... then I tried to Reorganize the...

Hi Gail, Sorry in the delay getting back to you. I ran the test last night from home. The Index rebuild was running and another process was being blocked by...

To be honest... I did not check... I will test off hours and let you know. Thanks for the advice!

Sorry... had to refresh screen.... thanks again.