...And keep browsing this site as well...That's wot I did and now I have cleared my MCTS exam...preparing for the next one now.

I selected the options 1 & 4 and lost it.

I thought the below one is wrong.

"With an exclusive lock, no other transactions can modify data (except for operations with NOLOCK...

Very good question. I gave a wrong answer. This question made me realise that, I need to focus more on this topic.

Some problem at client place. Not able to get remote connection. Will check once it's connected. Wel, Wot if we dont get any records from the query you provided ..?...

It's a very good question. Realy useful.

No.. We can customise it. We have the licence for that.

We can do anything we want in database (apart from some base tables). I have analysed the trace in DTA....

Yes. Infact none is doing deliberately as such.

almost 100 people using an application (MS Navision). Processes are killed by application itself I think.

Now how to go about it.?

I have read...

Thanks for the reply. It's SQL Server 2005.

Infact we had even restarted the server, but still it's not appearing. Will let you know if I get any solution.

Please let us know what exactly you want to do. So that we will be able to help you out.

When you restore db or log, you can see First LSN and Last LSN columns. Am not sure if you are asking about the same or not. You can also...

Thanks alot to all for the guidance.

Will try and revert back.

Simon Liddle (2/3/2010)

---

Joy Smith San (2/3/2010)

---

Wel, Usualy I answer the question by reading it on the screen itself. I never copy and paste it in query analyzer.Had I copied it...

Ninja's_RGR'us (2/3/2010)

---

Joy Smith San (2/3/2010)

---

Wel, Usualy I answer the question by reading it on the screen itself. I never copy and paste it in query analyzer.Had I copied it in...

Wel, Usualy I answer the question by reading it on the screen itself. I never copy and paste it in query analyzer.Had I copied it in query analyzer and read...

Hi,

Problem is not yet solved. But we came to know that the service provider (Vodafone) has to enable port 1433 at their end. Probably client will have to pay for...