We use maintenance plans. I like them and hate them. I use them almost on all servers to run optimization and Integrity checks. Use on some other servers for log...

That will do. Thanks, Allen.

Does it have to be regarding Backup/Restore only?

Yes, You should be able to restore MSDB over the current database. Make sure SQL agent is turned off and all the connection to MSDB are closed.

You will learn...

What kind of errors do you see? I haven't seen this error before but I think it might be causing this because of what's running in your job. i.e. If...

Hello again,

There is a small problem with this turning off ALL Level in this dimension. When we browse the cube through cube browser All the dimension is listed on the ,...

I also downloaded a trail of this product and wasn't impressed at all. It reports very basic information that's not that much useful. Development work and interface of this product...

Thanks rockmoose.

That worked just great. I Changed "All  Level" Property from yes to No and it's working just the way I wanted. Thanks a lot for your help.

Jamie,

I am not...

You can try this..

From command prompt run this..

unlodctr mssqlserver

This will uninstall sql server performance monitor counters.

From Command prompt again run this..

lodctr \\sqlserver path\binn\sqlctr.ini

Close and re-openPerformance monitor.You should see the...

Thanks, Steve.

I think I found an answer to this. Both of this jobs were pulling data from remote server. On Remote server Bunch of processes were getting blocked becuase of...

Hello cmille,

Thanks for the details about some aspects of this product that I didn't clarify. When I wrote most of the review, my trial version had already expired and our  budget...

Venkata,

Thanks for reading this article.

Yes, you have to install an agent on the server. As far as I know it's very low overhead. Also there is a client componenet so...

I know that there are few scripts on this board that were pulling job history for all the jobs on one server. Search Scripts on this site and you are...

What do you get when you run

sp_helprotect null,'usertobedenied/Roletobedenied', null,o

If you create a database with 2 data files- Both in PRIMARY file Group and if you drop the 1 that's listed first( IN EM- that's primary File- not FG)...