I do have the same problem once. I delete the job and create new jobs and it works file. To my understanding this is a connectivity issue. Check your job...

hi Noel

I am trying to use your script but i am little bit confused on it I appreciate if you will mention where to use the table name and...

Hi Linda,

It runs without error. giving message 13 rows effected but it doesn't create the author.txt file in the c: where I am doing wrong. help me

thanks

Hi try this. it gives command process sucessfully but its not creating  any temp.txt at c: is ther any things else I have to do to work on your script.

Thanks...

I appereciate for your time and help. Thanks to all of you for solving my issue. I am now feeling comfortable by joing this form.

Hi,

Thanks for your time. I did what you want me to do and I found one of the script which take care of my tempdb

Script to Shrink a...

Hi,

Thanks for your time. Yes recovery model is set to "Simple"

I found one of the script which take care of tempdb

Script to Shrink a Log File

/* Run "SELECT fileid,...