OK.

Thanks alot.

disk alignment.

just wondered if had to be the actual 64K starting or if it could be evenly divisible.

yes, but no luck. had a lot of varbinary in there from attachments.

OK, that is what I did. The row is not hidden and repeats for each group line.

I do not see the "Inside Group Below" option. If I select the group the and insert row below it still shows up before I click the drill down.

OK, thanks alot.

so I would change #tmp to tembDB.dbo.#tmp ?

if (something)

begin

select a

into #temp1

from realtable

select b

from realtable2 r2, #temp1 t

where r2.b = t.a --fails here

this is also inside an if else statement.

end

else

begin

......

end

if i execute it and set the include actual execution plan, it works from client. I just cant post it because of confidentiality agreement with large vendor.

2005 standard sp2 on server

xp sp3 client on workstation using advisor

can't generate one.

get :

Msg 208, Level 16, State 0, Procedure d_scroll_assignments_sp, Line 1129

Invalid object name '#tmp4'.

Thanks for the help. You answered my question.

So it will ignore the LSNs previous to the full backup when restoring the tran log?

Will sql ignore the data changes prior to the full backup after the previous log backup, that were since the last truncation, and only restore those from the full...

My concern is with restoring the 11pm log backup after the full backup at 9pm. If would contain log data prior to the 9pm full backup.