Thanks, thats not ideal. I think most people will use the replica for SSRS. Big flaw in the design then.

If I want to tweak the index for reports they need...

I have been using msdb.dbo.sysmail_delete_mailitems_sp

Wasn't aware of the other one. Will do. Thanks

Normal backup works fine for me.

With COPY is prefered by MS but not essential. It's not a show stopper.

Not sure?

As long as you are a local windows admin you can break into SQL via a back door. It requires a SQL service restart and is pretty simple. If you...

Thanks thought so. as the file could be copied, but no harm in being cautious around a production server.

View definition is all that is needed THANKS.

Will that not give them access to run and alter any sproc on LIVE. This is what I'm trying to avoid. I just want to grant them the option to...

Worked a treat. Nice one

Thanks it looks good.

Again I'll give it a try tomorrow. I see the logic more clearly. Makes perfect sense. Just couldn't figure it out.

I'll give that a bash tomorrow, if this works you are the man!!!!

Thanks.

transmission queue is empty

Coverting to Nvarchar resolved the issue.

The surname column is varbinary(200) in the table.

Long story, thanks fior the response.