Thank you very much .This is what i was looking for.Thank you for your help

Oops wrong date

SELECT t1.*,t2.dueDate

FROM Table1 t1

LEFT JOIN Table2 t2 ON t1.ID = t2.ID

WHERE t2.dueDate='2014-01-02'

GO

Thank you Gila.I thought if user has a permission on folder it applies to files inside that folder too. I gave a permission on file and it worked.Thx...

auto update is ON

index is enabled.

last Update:(never)

probably when it is "never" or other than date then NULL

It is NULL when Statistics never been updated

I ran the script and got Statistics Date=NULL where table has data.

name Index NameStatistics Dateauto_createdno_recomputeuser_createdrow_count

......

CLIENTPK_CLIENT NULL ...

I mean other than creating new table with new column and dropping the old one(page,index...)

Thank you Grant. Actually I was looking for you or Steve:-)

thx

Thank You.

How does Subscriber synchronizes with the Publisher (Merge replication) if it is not using trn log?

I used Appdev DVD's when i stared 6 years ago.Paid $1200 for 7 DVD 's.very helpful.

http://www.learnnowonline.com/appdev.Check them out

thank you for replay.How about differential backup chain?.

It WORKED!!!

Thank you very very much.

675169113071298

6934392315846

131730384862427

122277722123238

It's a same query

Can i see it ?