@ED

friend, if some problem may occur after installation so, we may try google it 🙂 but its giving absurd information

like " isnt valid login while i didnt enter it...

anyone with any clue what could cause this error !!

can you please put some light, what function i can use to make a lookup or find the closest match for lat, long to my reference table.

my production database...

thanks for the post

upgrade assistance may help us in choosing right configuration for upgrade.

but i m more concerned with my current databases, logins and sql jobs.

if i upgrade to...

@dilip : if you are going for separate db just only to avoid lengty backup time.

so, you may try FileGroups, you can keep different data in different filegroups.

so,...

I believe using different schema in same db will give you benefit.

since, you can easily fetch and join tables and using schema you alredy put different data in different box....

Thank you very much to both of you:-)

thanks to both of ou for replying on the post.

Yes i do agree, there is improvement with Separate physical hard drives

but my concern was what in case of SINGLE...

humm understand

thanks

well lat,long is important too.

reason i want to filter on status is this, i am receiving data too frequently and it isnt useful for client.

it is just making report...

yes thanks , understand

it will resolve some of my problem but what in this case

ARQ 8369.23028E+1171.57336734.01695Ignition Off12/1/2010 13:00

ARQ 8369.23028E+1171.57336734.01695Ignition Off12/1/2010 13:00

ARQ 8369.23028E+1171.57336734.01695Ignition Off12/1/2010 13:00

ARQ 8369.23028E+1171.57336734.01695Ignition Off12/1/2010 13:01

ARQ 8369.23028E+1171.57336734.01695Ignition...

No, i just sent you piece of my result set.

i retrive this from a query...

select p.id as 'CarID',p.cellnumber as 'Reporting SIM',p.Longitude,p.Latitude,p.statustext as 'Status',

p.assembled as 'Sent Time',p.received as 'Received Time',p.Distance,p.Direction,p.place...

yes avoid depricated stuff...

poster is really nice.

thanks

i will try this out...