Was on the phone with Microsoft for almost 2 hours and Microsoft confirmed it is a bug. They are not going to fix this anytime soon.

Please be noticed of this...

hmmm.

Thats a bad news!

Why is this synonym having so much problem?

I hope Microsoft will have some solution for this.

Anybody else in the same boat as us here?

Great! working, never knew that was so easy. Thanks all!

Back ups are done thru some other third party tool. I am not actually responsible for that. But from our side of the team, we just want to have the...

Sorry, maybe I asked you the wrong way.

I know that it is in the management studio and maintenance plan task and all that. But I have those files in my...

Well, sorry for that. Did not notice it since it was all the way on top. Anyway, what SQL Server edition? (Enterprise? Standard?)

Also, when I said RAM, how much is...

Did you configure your memory properly during installation of SQL 2005?

1. How much RAM do you have in that server?

2. What is your server specification?

3. Also what is your SQL...

Hi there talentguy, I hope you have resolved your problem with the tempdb growth. I have had the similar problem last weekend and I executed some update statistics statement against...

WOW, HOW DO YOU THAT?

sp_lock does not give me what I want. I need lock level(page level, role level, table level) of all the databases with their tables

That's a very sweet alternative. It just works fine and with no large logs anymore. I am sure I am okay right now. Thanks for giving me all the thoughts.:)

Damn!! Thanks for that.

Well, i guess I have to stick with the old plan where I have Full Backup and full recovery. But I am definately taking the transactional log...

Thanks for all these answers above. Not only I have made myself clear, but I have reconfigured the way my database was set to now. I do have a full...

Well, this question regarding Reindex has struck something important for to reconsider about my databases. I am taking a fullbackup no matter what. I do have full recovery mode. But,...

Sorry. My recovery model is FullRecovery mode. Got distracted by another thread.

So, am I still safe with the current plan?