hi Manu-j,

I did not try your solution because as you said it is not recommented to change the system tables. If I do not have any other choice then I...

that is for both, sql 2005 and 2000?

I have just tried it on SQL Server 2005. It generate nice query

alter login [sa] with password = <hashed password> hashed --Login...

Hi,

I have such a problem: In the dbo_SSIS_ServerList I have 236 servers.

Most of the server will through the errors - I know that and I want that, the expected problem...

looks like both topics that I posted today are connected...

the biggest table in msdb database is sysmaintplan_logdetail and it has 1023312 KB

mdf is 1117568 KB

ldf is 136064 KB

Thank you for both replies 🙂

the version is 9.00.3042.00

ok, found solution:

alter DATABASE MSDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

ALTER database msdb set ENABLE_BROKER

go

alter DATABASE MSDB SET MULTI_USER WITH ROLLBACK IMMEDIATE

GO

http://www.learnsqlserver.com/Blogs/SqlServerBlog/2007/05/quick-tip-what-to-do-if-this-statement.html

Thank you very much all of you for tips. I am now implimenting the alerts and job with failover.

Can you tell how long should last query?

ALTER DATABASE msdb SET...

mode: automatic failover, synchronous. The same for all databases

Can you give me more details how to set it up?

Hi

Thank you for reply. I want to rectify that I am talking about one database.

Hi

At the beginning I would like to say that it is not that I did not google before I wrote the post 🙂 I did only with different sentence. I...

Thank you 🙂

That was very helpfull! Thank you :hehe:

Thank you for your reply.

That script will be for sure useful. However I need a bit different information. The reason why I need info about store of security login permissions...

Hi

Now I have opposite problem. I have overwritten the database on the production server with the one from development. The one from development environment had different login (for example...