what i'm trying to say that the alert is firing continually after that the server runs for a couple of days.

i've opened a bug in MS SQL SERVER.

let's see what...

I've installed this sp3 on 2 sql servers and both making this same issue.

right after installing sp3 and restart the server those alerts continue firing all the time.

no guys it's not relate to the server that was stop or start or anything like that.

no the cache hit ratio is always above 99%.

and the alerts continue.

for now i disable this alert.

right after installing sp3 and reboot the server,this alert start to come up.

has anyone that have sp3 install and setup this alert in the SQL alert doesn't suffer from this...

thx for your answer.

I've read in the BOL and didn't see any mention about the /USERVA.

what is it ?

THX

thx.

i need the path,not the filename.

thanks,i know that,but my question is how in the script i can adjust it to work on a databases that i specified(4-5 databases)?

THX

hi,

I've create this script that rebuild or reorganized my index according

to the frag level.

how i can run this script on a few databases?(it can be a stored proc or one...

Thx.I'll give it a try when I'll face the tempdb problem again.

David Levy (1/2/2009)

---

I should have added that while freeing the proc cache will clear the symptoms you are seeing temporarily the root cause is likely proc cache bloat. If all...

SQL 2005.

yes i'm seeing that my tempdb database sometimes grow for 40-50GB.

even if i wait few hours and try to shrink the tempdb data file i can't.

so if i can't delete temp tables from my session (query analyzer) what are my options to delete those tables that i know eat up my free space and they...

THX.

yes the backup is done,but the created database is not function no noting in it.

thanks anyway ,but i think that i will go on the sql agent and check for...