I tried with global temp table still error, actually it has no issue with ssrs, it throw an error in management studio as well only when i select all the...

Thanks for ther reply Gift Peddie, that could be the reason, i know there is lots of local temp table, and is there number of limitation that i can have...

thanks, for the reply i am not sure if that is from the report there is no temp table but there are like few table functions inside views which...

Also another thing... by rebuilding i did not see defrag down to 0... some of them stay fragment of 60% is that because of small no of data pages what...

thank you very much that work for me.

sagar

Hi,

I am getting error while executing the online index rebuild

error:

Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'User'.

Msg 319, Level 15, State 1, Line 1

Incorrect syntax...

any idea on this process if any body has some suggestion that would be great.

thanks

sagar

thanks for the reply...

so basically if i need to schedule this task during online through job i can exclude those table by filtering data type..so can u correct me if...

Thanks,

ya i wanted to log those changes. i am doing with trigger right now trigger and it will disable after execution complete. Is there any other option with out...

I really need help on this or any information.

thanks

Thanks for the help..

I have Question on using same package. while runing package during update... there is several email sent out via automation if users are left to another department...

Thanks Gary. That would definitely help me lot... i never debug stored proc in visual studio.. so do i just execute as i do in management studio or any other...

do i have to re-config the package.. any suggestion?

i have tried this which delete the row that matches with duplicate from tblprojectmember did like this

delete t1

from tblprojectmemberdetails t1

inner join (

select projectmemberID

from tblfiltereddata)t2

on t1.projectmemberID=t2.projectmemberID

then i was able to...

when i try to delete it gets error

like this

Msg 547, Level 16, State 0, Line 1

The DELETE statement conflicted with the REFERENCE constraint "FK_tblProjectMemberDetails_tblProjectMembers_ProjectMemberId". The conflict occurred in database...