I restarted my workstation and it's gone.I just wonder what does this query do?

Thank You Very much.

Thank you Grant for reply.They are separate processes,i just listed together. 
Session 1: Update table1 set date='20170101' where item_id=10
Session 2: Select t2.Item_ID,t2.Col1,t2.Col2 from table2 t2,table1 t1 where t2.Item_ID=t1.Item_ID and t1.date>'20170401' and...

Installed SSMS 2014 and it works just fine.
Thank you very much

Thanks for reply.
"SSMS version on your workstation is pre-2012 is my guess. "    Yes.Is that a cause of the problem?

And this
http://info.tricoresolutions.com/blog/understanding-backups-with-sql-server-alwayson-high-availability-mirrors

Found nice article 

https://blogs.msdn.microsoft.com/alwaysonpro/2013/09/27/performing-transaction-log-backups-using-alwayson-availability-group-read-only-secondary-replicas-part-1/

Got it.

Thank You

I have 2 databases in my production server(Server A):Production and copy of Production database(Prd_Copy.).Every day i am restoring previous day's full backup of production database into Prd_Copy..bak file resides in...

Thank you guys.And differently i'll use Tsql .

No.I am trying to configure Database Mirroring(SQL Server 2014)

Sorry for inconvenience.next time i'll make sure to post sample data.And thank you for your replies

I have a task similar to this one.

i have client table which has client_id Eff_from and Eff_to columns.Eff_from and Eff_to are the dates that client is eligible for service.I need...

Thank You all

tnx for reply.lets say i have 5 columns and col1 is clustered(not identity).I insert values 10,x,x,x,x .How do i get cluster index key value ?

My assumption was that it is...

i got it.Just added COUNT(*) to Luis's script.Thank you guys