Hi Rudy,

I actually saw that link, but thank you for sending it to me. It ended up being Open Transaction. I should have checked that first... I...

the higher ups are super stingy with disk space.... we have to squeeze out all we can to run the system.

Is there a better way to regain this free space other than a Shrink..... which leads to a rebuild or reorganization of the now fragmented indexes?

Thanks for the reply Gail. I relayed your response to the person that asked the question. He said he really meant to ask about "free space"... I told him there...

Thank You SSCommitted!!

yes... all 8000 records have that pattern. I need to change the drive letter and the first two folders, but retain the reamining information in each record. Thank you again...

Hi Lowell,

Thank you for the information. The backups are on a separate drive... this actually an instance on an Active\Active Cluster and we have a completely separate drive for...

Hi Gail,

Yep... I was tracing the correct instance. I checked the SQL Error Log before I received your last message. I noticed the messages had stopped. I contacted the...

Hi Gail,

I actually created a new Profiler Trace per your instructions after your first post. Still no failures reported.

Charlie

Gail,

Thank you for the reply. I tried running the profiler with the standard template and removing everything except the login infomation. I saw the new account logging...

Hi Anthony,

Thank you for the information. I ran the profiler earlier with Standard Template and just removed all options except for auditing successful and failed logins. I could see...

SS Carpal Tunnel,

Thank you for the reply. I actually had checked the security on the Linked Servers. It is set to use the context of a specific account...

Thanks for the additional information Elliott. That scenorio is exactly what I was hoping to achieve. I have not had the need to create SSIS packages as of yet, so...

Derrick,

I like that plan. Thank you for the information.

Charlie

Thank you for the information CEWII. I guess what I am asking is.... if by the formula I mentioned in the original post, I have (32/2)-2 or 14 GB of...