I should have put the solution up some months ago but forgot - sorry!

For Information, I did manage to get this working.

In the 'conditions' I created a target called 'Only SA Login'.

This condition uses a facet of 'Login' and, using the standard pull-downs...

Has anyone had any experience with PBM that might be able to advise on this one?

Hi,

Did you manage to check the SQL Server max memory parameter in both instances?

Were they different?

If so, were you able to make the parameters the same and re-test?

Do both instances of SQL Server have the same memory allocation?

In SSMS

- Right-click on the server name and select 'Properties'

- Select the 'Memory' option.

- There is a 'Maximum server memory...

Hi,

Thanks for the reply - I will read through the article.

One thing that I failed to mention in my original post is that the queries I need to monitor will...

Hi,

These messages have been going on for many months, since before I was at the company, and I don't know what application is causing them.

Thanks for the reply, but I have already checked that.

The radio buttons are set to :

Permission to connect to database engine - Grant

Login - Enabled.

Does anyone have any suggestions...

According to the Application Event Viewer and SQL Profiler it is trying to access master, and that is the default database for NT AUTHORITY\SYSTEM.

Thanks for the reply Paul.

I have been Googling this scenario for a while now, and I'm surprised that no-one else has mentioned coming across this issue in the past.

By taking part of Ninja's_RGR'us code I have managed to get the data inserted into my table - thanks.

Everything works fine when the destination table is on the same server...

Yes I backup my DBs daily.

How does having a backup solve my problem?

I want to be able to run the SQL script, mentioned earlier, on a weekly basis, and for...

Hi,

Thanks for the replies, but I'm not sure the SQL does what I am after (although I am not an SQL expert).

I have created a new table with the following...

Hi,

Can I ask another question on this.

Now I have the data that I want, how can I get the rows inserted into a table that I have created, so that...

That was fantastic.

Thanks for the prompt reply.