Thank you everyone for your input. I am buying a third party defragmentation tool. I defraged one of my servers the other day and my users reported an...

Brian,

Sorry for the late response, got carried away at work....many thanks for your response. I think that I may just have to rely on my script (which e-mails...

Thanks Brian,

I just reread what I wrote and I goofed up since I wasn't clear enough on what I wanted. The problem I am having is that my users...

Hi Marco,

No, we don't have one.

Thanks Happy!

Wow, thanks for the link. Just what I needed!

It's been a while, but I think I went to the sys tables and deleted that linked server manually. I would reseach what tables hold the data for linked...

Westley, I just tried your approach, and I got the error message:

Error 18456: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

Renato, I have let my sys admin know that this needs...

Hi everyone,

Please accept my delayed thank you, it has been crazy here at work. I appreciate your help, I'll test your input and will report what works. Thanks...

Hi everyone,

I posted a response and just checked and the response is not posted for some reason.

He is using Windows login. The SP has two insert statements, one is...

Hi Aaron,

I tried what you said and had the user run the stored procedure and he got the same access violation error saying that he cannot insert into a...

Hi Aaron, thank you for your thoughts. The code is actually compiled as a stored procedure and the user has execute permissions on the SP. His code inserts...

Hi Aaron,

The user has execute permission on the stored procedure, but when the stored procedure tries to insert, he gets a permission error.

Thank you, thank you, thank you!

Thank you alzdba. Can you (or anyone) tell me what the rollback immediate will do? What happens to running scripts? What happens to the data that is...