No, Its a simple user who is part of a AD group.

The user is a member of an AD group which has access to SQl. They have been removed and the added back to this group with no success.

Do all the disk sizes need to be the same.

Eg E:\ Mdf files xGB

F:\ LDF files yGB

On all servers used in the Always on Availability Group.

Is the C:\ included in...

Thanks, do you mind if a bug you a little more on this one. There is very little on the NET that is useful in this area. Not specific enough.

I'm...

Is it best to have 2 queues one for the initiator and one for the target ?

Of course Service Broker is always ASYNC. It wouldn't be a queueing system if it wasn't. That little fact did slip me. Thanks

Thanks, that will save me hours sitting at my desk looking totallyt p*ssed off.

At last there is light at the end of the tunnel.

Thanks again.

The first paragraph was a comment online to resolving a fire and forget setup. What I’m trying to do is setup a SYNCHRONOUS process and change it from an ASYNCHRONOUS...

Thanks Gail.

Thanks Steve, but what I'm trying to find out is what problems occur with it in SQL 2008 SP1.

How do you write an asynchronous SB. So that it doesn't fill up tempdb.

Don’t see what you are trying to achieve, are you low on disk space.

If the db is read only. Then set it has read only. If you are low...

The auto grow setting on the db has been triggered at some point and the file/s have been extended. Allowing data to be written into the free space. If you...

Are you talking about a production db. I would not shrink a production db POINT BLANK.

Still if you select the columns you need my query will do it for you.