Thanks for your replies guys.

@Grant - what I basically meant with by 'during the time period of a query' is that if a query has run for say 10mins and...

Am i right in answering your question as the first login that takes 50ms - As this will be present in the dmvs because it doesn't disconnect.

So are you suggesting...

When i look at the results from whoisactive I cant really see any queries that look that intensive as regards burning cpu. I can however see a lot of logins...

Ive just had a thought.....would this have anything to do with the matser database holding the incorrect info ? When i did the restore from Live to Test I didn't...

Using the results of that query I can see that when i open Local user and groups\Users - I can indeed verify that the logins exist.

What next ?

I fixed this by dropping all subscriptions, publications AND dropped and recreated the Publisher/Distributor (both where on the same server).

Just dropping the subscriptions and publications did not fix it -...

Yep I have checked what you have said and sure enough it is enabled - all makes sense now. This must be the default setting then as i do not...

thank you very much for this. I will have to read up about powershell as i know little about it. I will have to understand the script fully before i...

Hi

Thanks for the link first of all.

I am not sure I fully understand reading through the script though as I have never used powershell.

I am just trying to copy a...

Do you have the link to the required article ?

Many thanks

hI everyone thanks for the replies. I'm still a little unsure about some of your replies as I have added new columns on our dev environment and the replication picks...

Are you sure that it also mapped the users database access and permissions ? When i run the stored procedure in that...

No i have created a new database. I looking for a...

Ok Guys thanks for all your input.

Going back to Grants original response - I think I have found the query which is running for a long time and causing the...

Indeed it was. I wasn't sure of the methodology though so I found that post. Thanks for putting me on track. Would the seeding values just go to default values?