You can get the informations about blocking time by using

sys.sysprocesses

e.g. select waittime from sys.sysprocesses

can you please elaborate it for my better understanding.

guys, if everything gets logged in log file in Simple and Bulk Logged recovery then why we are not able to restore point in time recovery.

Hi Rjohal

Thanks for your reply I try to do the things you provided.

Thanks

means if i create default instance it is Active\Passive cluster and if i go for named instance it is Active\Active cluster ?

Thanks guys for your all valuable replies. 🙂

Hi Alen,

Can you make me understand in detail ?

ok, thanks guys for providing the solutions.

Thanks for the reply.. 🙂

I dont want to rename my server name, the question was how to edit the registration information like at the time of installation SQL Server ask for name and company...

I think we can change it by using serverproperty but I dont know how to use that statement.

Hi

Can anybody understand me the architecture of tempdb in sql server 2005 ?

Thanks in advance.

Its an interview question.

Actually it was interview question.

Actually it was interview question.