Hi There,

You can try adding the sql agent account as "Lock Pages in memory" in Group Policy editor. Once done that, restart the node and try enabling Agent Xps after...

Hi Dude,

If you've lost 'sa' password and you're not the sysadmin on the SQL Server, there's a way to RESET the password.

if you're sysadmin on the server, you...

Thanks Sergiy for your response, but the question here is I need the result in the following format:

Desired Result

col1 col2(varchar)

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

1 Red | Blue

2 Green | Yellow | Red

Where as col1...

am facing the same issue except any object created via QA, shows as User but can't create SP from Enterprise manager. Gives error, Owner name is not specified.

Hi Shawn, I believe you can use Merge replication using which, you can update the data at any end and replicate it to other server. It works fine as long...

Why do you require the triggers to be turned on at the subscriber's end? you can simply turn off the triggers at subscriber's end and have this issue resolved or

As...

Is there any composite key involved in the filtering criteria?

Cheers,

Puneet