This is asked by an interviewer

Hi buvensh,

Thank for your reply............iam clear about with your reply....

Koteswar rao

Hi,

thanks a lot..........for your explanation...........iam clear about it.

Koteswarrao.y

Hi,

thanks alot for your reply...........

koteswarrao

Hi

We are using 32bit sqlserver

Hi,

We are using 32bit sqlserver

Hi

can we use the stored procedure sp_who2 by viewing the column 'blkby' to find the blocking issues?

Koteswar

Hi,

thanks for your response............. i have done like that and it was clear.........

thank you very much

Koteswarrao

Hi,

thanks for your suggestions...i able to restore further txn logs after stopat as per your suggestions , but my purpose was not met...

From the restore Txnlog_2 with stopat i able...

Hi,

Iam getting the following error

Msg 4305, Level 16, State 1, Line 1

The log in this backup set begins at LSN 20000000003300001, which is too recent to apply to the database....

i want get aware to trouble shoot the database if it is suspect mode...........to bring the normal mode.........

for this iam trying to bring the suspect mode and do trouble shoot...

Iam trying to bring the database into suspect mode? but it not happne even thought the external dirver is removed from the system of which the one of the data...

hi,

thanks for your resolution steps it was resloved..............................

how to list all views from each databases in sql server. Can you help me this out?

catalogviews

compatability views

dynamic management views

and etc.,

Thanks

i executed the dbcc opentran(),there were no transactions.............

even i have taken the full database backup & transaction log backup............i tried the shirnk the log file......

after doing above work process............when trying...

Hi,

This is artice is very good and usefull in solving .............thanks

Koteswar Rao