1) When I restored to different server the owner of the db is showing my name. Is there any way to change this automatically without running manual script -- you...

Hello -

Check out this thread, it is the same thing: http://www.sqlservercentral.com/Forums/Topic1554224-150-1.aspx

Basically set the Visibility using an expression that uses the parameter values.

Jesse

Agreed with the above comments but here is what Luis is talking about in a query. I am not sure if this works for your data but it might...

I agree with GilaMonster ... DateValue >= @StartDate and DateValue < dateadd(Day,1,@EndDate). If @startDate = '07/01/2015' and @endDate = '07/30/2015' you get all of the end date, including time:...