Thank you for your idea.

in that case then i need strip out chars from data

(i mean w,d,h) and convert them into seconds and then

run ur query .

is that what u...

Dear Phill Carter

you are 100% right.yes i am using it in stored proc.

I'll implement your suggestion.

Thank you so much

hi Phill Carter

it worked like a charm 

but how can use it in my dynamic query

some times there may be [ char in my...

i tried again like following but still did not work

select * from tab1where fld1 like 'Ph[(L' escape '['

select * from tab1where fld1 like  like '[Ph[(L]'

i found following books online

If the LIKE '5%' symbol is specified, SQL Server searches for the number 5 followed by any string of zero or more characters.

For example,...

Thanks guys i'm trying..

Yes,i did still it does not work.

with out % 1st query runs but why not 2nd one?

u can use profiler to trace every event.otherwise

u need to write a trigger on the table you want to know changes which sends you an email(you can use xp_sendmail ).

cheers

actually we did not design our application initially keeping replication in our mind.

we needed it now bcoz

my boss who travels extensively and always uses this application.

ofcourse he could connect to...

our frontend application accessing sql server database not vfp tables.

we r using vfp just as frontend .

thank for ur reply thomas.

in my case our frontend application programmed to interact with sql server only

not .dbf files.

seems like correct me if i am wrong,

if i were 2 follow...

Hi brian

if i can ask another question on replication.

we have an application in our office MSDE8 as backend and visual foxpro as frontend.now

we want to enable replication.i mean users can...

sorry Brian it's sql server login.

anyway i changed our server audit level to success.seems like i need 2 restart our server.i'll restart our server when there r no logged in...

hi brian

i checked my server properties unde security tab but unfortunately the audit level is none.

thanks friends

how do i know SQL Server is configured to audit successful logins?

if so how can i read application log.

thanks for ur help