Thanks for your reponse Elliott, this is fare enough.

Any other suggestions or ideas would be greatly appreciated.

Alex

Thanks Bru,

There is no question that a SQL DBA is a sysadmin on the SQL Server.

But according to Elliott's response (and my research) sysadmin rights still would not allow...

Thanks Elliott,

I know that you can add a Group from the Active Directory with a Windows Authentication; this is not a problem.

The problem is that a SQL DBA not always...

Thanks a lot for your responds guys,

Steve I will definitely try a .NET Reflector approach from RedGate and let you know how it went.

Thanks again for all your help and...

It is very frustrating though; since I'm a SQL DB and have no control over these objects in SQL Server.

Did anybody have any luck with other approaches?

Any recommendation if anything...

Unfortunately I cannot do it because this is a client's machine and even more; it is outside US.

And yes, Jeffrey, there is a space limitation issue with this Server.

I can...

Also, is there anything I can do about the 'Latch'?

This is a Live database. Is it not going to affect performance?

I'm trtying not to wait more than 5 minutes

That is the only difference Gail

PAGEIOLATCH_SH79PAGEIOLATCH_SH5:1:3760981

How would I do that in MS Gail?

Should I set a trace in Profiler?

To get the free space, I right click on the database, go to Tasks > Shrink > Files

I'm using the DBCC SHRINKFILE command.

When I'm putting the Initial Size as...

Hi Gail,

Thank you so much for your respond.

Finally I got the technical answer I was expecting. The free space is in a data file. 40% space is unused.

I'm guessing...

This is a good thought Jared, I will try it and let you guys know when I will have a chance to restart Sevice on this machine

So, I'm guessing there is no help available for this issue?