Hi Satnam,

Thanks for your reply and help.

Could you post your script that you've tested?

I'd like to test it on my environment and hopefully it's not giving problem.

- Peter

Hi Satnam,

Thanks for your reply and help.

I've came accross that article earlier and it does not really work.

- Peter

Hi MyDoggieJessie,

Any idea how to fix the problem?

Appreciate for your help.

- Peter

Hi MyDoggieJessie,

Thanks for your reply.

Both secondary db's are using the same MSSQL version which is: SQL Server 2008 R2.

I've double checked the version again to confirm, but for some...

Hi MyDoggieJessie,

Thanks for your reply.

Yes, correct. I've used your script and able to run in on my secondary db. No problem, it works 🙂

However, I've stated earlier, I've another...

Hi MyDoggieJessie,

Thank you for your reply and help.

I've tried to change the data type as suggested, but ended up with some more errors.

If it's not too much to ask for,...

Hi lmarkum,

Thanks for your reply and help.

It's very useful and that's what I've been looking for 🙂

- Peter

Hi MyDoggieJessie,

Could you help on below errors?

Msg 245, Level 16, State 1, Line 127 Conversion failed when converting the nvarchar value 'DBCLUSTER' to data type bit.

Thanks.

- Peter

Anybody can help to fix this error?

Thanks.

- Peter

Hi MyDoggieJessie,

Thanks for your reply.

Yes, I've just checked and it's confirmed that I'm running the script from the secondary db.

Is there any SQL query to verify and confirm it? I...

Hi,

Could you help to fix this problem?

Perhaps need to convert this...

Hi,

Thanks for your updates. Appreciate it.

Regarding below errors, yes, I've run the same script on a seconday database and I've checked the database is currently on standby mode (restoring...

Hi,

When I tried to run the same script on my other database, it's throwing below errors. The same exact script, no change at all.

Msg 245, Level 16, State 1, Line...

Hi,

Have some queries:

- How to add date and timestamp to the message?

- What does it mean when the status is showing GOOD or otherwise?

- Should the script be run in...

Hi,

Thanks for the update.

I've tried the updated codes and it still produces the same output, everything still in 1 line, no line break.

However, I've tried to add a line break...