It happens sometimes and its indeed great for apology.

Simple example..

SELECT SCHEMA_NAME(schema_id) ,

name ,

ROW_NUMBER()...

Thank u all, I appreciate every one here for the solution.

Finally, i found my own one.

Oh yes, Take a variable and compare it with your condition. U can also make it to your parameter so u can pass while executing SP.

Yes, thank you.

U can create staging database with latest backup made it to appropriate and using switch database, u can switch to your original database. If your dayabase has large size and...

If you enalbe xp_cmdshell option in configuration, it does not give effect immediately for current session. U have to use Reconfigure command to give immediate effect.

I insist to ignore top clause as there are around 60 million records. when u perform top it default sorts data. I insist use between clause that on your identity...

Take latest backup at appropriate location and restore it.

Either Create new blank database and restore on it.

Jeff sounds interesting, u should do instead.

Great DBAs do always learning.

The alternate is u should keep two columns, u have to tell developers to use FutureDate column while for other database, it should CurrentDate.

The second option is u should create...

Create table #temp

(

ID int identity(1,1),

ActivityName varchar(max),

ActivityDate DATETIME2 ,

LoginActivity int

)

Insert into #temp

Values

('Successfully Login into ABC','2013-05-20 13:22:21',1),

('Logout Successfully from ABC','2013-05-21 18:20:07',2),

('Successfully Login into SAMl Application','2013-05-21 15:28:08',1),

('Logout Successfully from SAMl Application','2013-05-21 15:28:08',2)

Create table...

If u'r facing problem with insertion see below demo.

DROP TABLE #temp

Create table #temp

(

ID int identity(1,1),

ActivityName varchar(max),

ApplicationName varchar(100),

ActivityDate datetime2

)

Insert into #temp

Values

('Successfully Login into Dynamic Portal Application','Login',CAST('2013-05-20 13:22:21.000' AS DATETIME2))

It is not clearly understandable what u need.

Please brief of what u need and what problem u'r facing right now.

U CAN VALIDATE BY JOINING SAME TABLE FOR ALL REFERENCES.

EG. SELECT C.INTERMEDIARYNAME,C.INTERMEDIARYID, P.INTERMEDIARYNAME

FROM TABLE1 C LEFT JOIN TABLE1 P WHERE C.INTERMEDIARYPK = P.PARENTINTERMEDIARYID

WHERE C IS CHILD TABLE AND P IS...