Nope. Policies just can't be read correctly from a shared location.

Set-Location "\\pathToPolicyfiles"
get-item "policy.xml" | Invoke-PolicyEvaluation -TargetServer "servername"
ERROR: does not have a valid XML format that can...

frederico_fonseca, thanks for the suggestion.

In my PowerShell, I went with mapping a local drive to a shared location and referencing the policy...

I've resolved this by editing the create replication script to use destination tables names for the proc.

Issue resolved through the use of a custom item level role.

rambilla4, it was a while ago now, but if I remember correctly, we had timeouts from a single user running the report.

The previous post to use Snapshots could be...

jswong05, I never recommended this solution to anyone and any SQL Server DBA will know the potential issues with making configuration changes to system databases/objects.

No-one could help me with my...

jswong05, that is only one isolation level.

Search the web or Books Online for READ_COMMITTED_SNAPSHOT.

PG

Thanks for the reply and info Gift.

That's all I needed to know.

Paul

I have now resolved this issue.

From everything I have found and read, the blocking behaviour by Reporting Services appeared to be normal for large reports.

This wasn't acceptable for us...

MANU,

Thanks that's fixed it.

Paul.

Steve, The database is about 5GB in size and sits on a 100GB drive. It can use all of the drive and so the data file is about 6% full....

I have now solved this problem. I used FOR instead of AFTER in the CREATE TRIGGER statement.

Inserts working correctly now.

Adrian,

That is exactly what I have just thought of.

I tested it and it works perfectly fine.

Thanks for your help.

Paul

Adrian,

Thanks for that. I have searched for a while and could not find any reference to UPDATETEXT and remote servers.

I am basically using a trigger to replicate a change in...

OK, problem solved.

I looked into some of the DTS steps. The developer was displaying a message box which was embedded deep down in a VB function. I couldn't find it...