Thanks mate, that was a great help. I am pretty clear with the backup concepts now. Is there a way to read the log files. I mean if i just...

Why do you need to do a NOT EXIST or Join queries.

I too have a similar situation where we create labels file for our subscribers every month and if we...

That was really a good explanation. I also have scheduled a daily backup at midnight. When you say taking log backups every 4 hrs. Do you overwrite the same log...

the server boots up everyday atleast once as it has wingate running on it and it keeps on hanging.

What is a full recovery mode?

And how does the transaction log help?

Sorry for my ignorance but i really think there this is something important that i am missing.

We have...

So the statement should basically be like

Begin Transaction

update users set job_title="Manager" where job_title like "%Mgr.%"

update orders set job_title="Manager" where job_title like "%Mgr.%"

And after doing all such updates i issue...

-

Thanks, this was simply a perfect solution. I never knew we can use a case statement within select.

Hey i would like to know more about such functions that can be...

No I tried that earlier but it doesn't work. It still gives a empty field instead of showing 'None'