Thanks again.

Thanks a lot!

And there is no direct way to find table size (Mb) besides manual calculation using rows number I've got?

Thanks. Actually you answered already my second question  I was about to ask regarding temporary table related permissions.

And just to clarify regarding standard tables- “EXEC” permission allows User...

Thanks

Regarding sysprocesses table- could you, please, explain what status "runnable" means (not "running")? For example, I just came to my office and found that: 1)CPU usage is almost 100% (checked-...

Thanks, hope I got you.

Thanks, guys. But, CPU will give you an idea how long this thread (process id) is running and can't confirm that it is a real current CPU usage issue (probably...

Thank you for your response. Unfortunately, this period of 100% CPU usage lasts some hours and 1-2 times a month. So I need to be prepared for the next time...

Thanks a lot. I thought the same way that it’s probably dealing with DB restoring.

Thank you for your answer, but I am afraid I can't agree with you that <None> login means User name = Login name (it's very easy to check- majority of...

Enterprise manager=> Right-click Databases, and select All Tasks/Attach Database.

Good luck

Sorry, didn't get the point and relationship to my question. Thanks

Agree, it's cool. Shane, sorry, but when I tryed your syntax got back file with '[STRTDT]' in name, not it's replacement. What I am doing wrong? Thanks 

Thank you, guys. But the core of my question was not how to create scheduled log backup (I used maintenance  plan wizard too) but to...

Thank you!