This post has been removed from the sqlservercentral , now its available at below -

https://www.programmersought.com/article/63971536090/

https://blog.katastros.com/a?ID=01150-3120dc42-b713-4c82-ae8c-39c5fcb504bf

My apologies, typo error... it should be "Yes"

Buddy,

your answer is wrong.. it should be NO only.

Even last 2 statements in the question is quite different..!! 😉

Hi Kin,

Thanks for the reading.

The time we spent for taking a database backup will probably equal to detaching a database and copying their files to the destination server. Here we...

Hi Jinx,

Could you please send the exact error that you are receiving?

Thanks,

Dathuraj.

Thanks for the replay.

But I could not see that in SSMS 2000.

However what is way to enable it? I am having a prod sql server 2000 with SP4.

Thanks,

DR

Hi,

Instead of using CASE within the where clause, you can use CASE first and then put where clause.

As,

syntax

CASE

WHEN Boolean_expression THEN result_expression

...

Thanks Bhose... Is there any way to find a particular element value. lets say i have a country elements in an xml doc.

ex:

India

Australia

...........

Can you suggest........ actually i want to...

Yes, you are right.

But not only that, as we know ldf maintains LSN's and will get truncate once it is committed to mdf agin its depends on the recovery which...