Thankyou, but help me to find out the summary line for each publication. like this:

publication1 Running ...

Thanks.. I reinstalled with all tools not only the basic tools. and it worked.

Thanks again.

Noman

yes ofcourse agent service is running and i can see jobs in object explorer and i can run it from there. but why not activity monitor can open. Still is...

Many reboots buut No Effect...

Thanks to everyone for sharing your valuable thoughts.

It really helpful to me.

Thanks,

Noman

So, If i say it like that, we dont need to add FKs if we have no problem with data integrity because our application flow will handle this.

Is a...

I didnt experience such, but just make it sure that your network is going well, linked server is accessible of that user that is mentioned in linked server. you can...

it seems the permission issues on ur folders, make service account as a local admin if it is not.

you said you installed another instance on that machine, please let me...

yes it sounds like very simple but still facing login problem when i applied this trigger.

i am creating a trigger like this:

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

create TRIGGER test

ON ALL SERVER

FOR LOGON

AS

BEGIN

if (original_login() =...

Thanks Gail,

Actually i have two servers one is production and other is backup. and all our application are using production db with a specific user e.g., 'AppUser', if production db...

Thanks, Actually i know this is not a good approach but it was interesting that how i can pull my control back from this situation. Although i am also trying...

Thanks for prompt response..

Its not like Unique Constraint...

i want there is only one row with the Type = 3 and can not insert again with type = 3, but...

Thankyou Atif,

Need recommendations please??

which approach is the better in this case.

--Noman

Thanks for your reply, Actually its an archived table so no direct insert and updates on it all the time. we use it for searching only.

but in where clause we...

Thanks, have another problem im facing now..

i want add Primary Key on table which is the part of Replication. if i add, will there any effect on merge replication??? only...