if your on a 64 bit system, and 64-bit SQL, you don't need to worry about any of this AWE, "lock pages in memory" stuff. 64-bit is made to...

If you are getting this error because of sticky points due to replication run this:

sp_dropdistpublisher 'bad server name'

that should clear up the name mismatch on replication and allow you...

I appreciate the help but I guess my question is more general than asking you to help debug the fine points of my problem.

The basic question is: should...

I am assuming you are trying to enable this because your wanting to use AWE on a 32-bit system. If not you can ignore this one.

To check who has...

The error:

An error occurred during recovery, preventing the database 'msdb' (database ID 4) from restarting. Daignose teh recovery errors and fix them, or restore from a known good backup....

I am getting the same error but I think my cause is self induced. I was attempting to use a database copy scenario for DR solution. As opposed...

Previous versions of cluster services were very particular about the installation process. So much so that in the event of an error sometimes it was easier to start over...

these are the execute grants I ran. I can now execute sp_help_job on a sql 2000 db but it doesn't return any data. Do we need to address...

these are the execute grants I ran. I can now execute sp_help_job on a sql 2000 db but it doesn't return any data. Do we need to address...

sorry, dup

are you asking for a Microsoft Product called MOM by chance? I am looking for the same reason as I don't want to give blanket SysAdmin access to MOM...

Good Article.

I posted this here as this is a question on this same topic. I know it is documented by MSFT that these roles are set in...

I'd also love to know a way to do this.  please help if you know a way to do this.