Thanks...Manytimes u got in the book is easy than to search on Internet...:-)

Thanks Gail...u really caring for sql guys...

May I know what other internals tasks of query optimizer...

The out put I am Getting is

First LSN :19000000043500037

Last LSN :19000000045300001 ...

When I was reading this link :http://msdn.microsoft.com/en-us/library/ms191459.aspx

Then this below command I have seen:

RESTORE LOG AdventureWorks2008R2 FROM DISK = 'c:\adventureworks2008R2_log.bak'

WITH STOPATMARK = 'lsn:15000000040000037'

GO

Therefore I have asked How to get Recovery...

The point in time restore or Restore database is depepnd on recovery point.

select Name from sys.syslogins where sysadmin=1;

I dont know How to give sysadmin rights to users.

The value of Out parameter is not coming.

Thanks...

But I want to just confirm that will Mirroring be OK or Not?

How Do I check this? If I create database snapshot of Mirror datasbase but I dont know...

Dear Harsha,

I am not getting OBJECTPROPERTY(object_id,'TableHasClustIndex') column when I checked only SELECT * FROM sys.tables.

How Where condition is not giving error or to which table OBJECTPROPERTY column is belonging.:-)

This is the production server I cant run it,First I have to detect the reason why error has started.Earlier it was not coming.

send the error Number also...

Your name should be Gila Answer...Thanks

Can u give sql server Log and Transaction Log of that time...

I want to only know if I want the feature of Copy_Only without using Copy_only...