hi friend

I think i did it.

i selected publisher folder and in the context menu there is an option disable current server as

distributor.i removed...

Thanks for ur reply friend

But i dont see any option to disable the database.

cheers

rajani

Thanks for ur reply.

actually i dont remember the sequence

but i still see the Hand icon on database name which i used for replication.

-----------------------------

What makes you thnk that this has anyting to do with Replication?

-------------------------------

bcoz from profiler i found that connection related to replication.it executes following proc all the time

EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters

and shows...

Thank you very much David

I'll try Idea 🙂

Thank you very much Russel Loski

I changed my query like following and its working

greatly

DECLARE @X VARCHAR(100),@Y nVARCHAR(1000)

SET @Y=''

SET @X='''!2OiC'',''!3zje'''

SET @Y='SELECT * FROM...

Thank you very much Guys.

I just created a new job which stops my worktimes automatically.

all working fine

Thank you so much guys for your replies.

If someone wants to work overtime no problem

they click start btn again .My job is to stop

worktime only once.if someone starts intentionally

after office...

Thanks chris

I found very useful website with connection strings

http://www.connectionstrings.com

its very useful

Thanks for ur response.

cheers

Rajani

I just tried your solution.what can i say

it worked like a charm.good thing is it was so

easy to implement your idea.

Thank you...

cool my friend

Yes i use sql 2000.I'll try your Idea.

Thank you so much.

Thank you very much Kevin

It worked beautifully 

now i have to implement it in my actual query.

thanks for your valuable time.

cheers

rajani

Hi friend

Thanks for your link.

i wrote a query like following

select taskid, date,[staff]=staffname+','+staffname

from task,taskgroup

where task.taskid=taskgroup.fk_taskid

group by taskid,entrydt,staffname

but it gives wrong data like

taskid   date   staffnames

-----   ------   ---------

1      12/1/01   ben,ben

1     ...

Cheers

I'll try that.Thank you very much

Dear Phill Carter

i implemented it and its working fine .

Thank you very much