Hi,

If SQL Server supports up to 2,147,483,647 bytes for image data.

It doesn't use 2,147,483,647 bytes for the pointer.

Then only for storing address why they have located 2gb of space.

only...

Hi Gila,

Thanks for the reply.

I removed the below line but i got the same result.

AND PS.page_count > 8 --- ignore tables less tha 64K

Then i make some changes in...

what sp_update_job will do............ i m very new in sql dba please help me.... for the same.