How did you resync the databases.

Was following along - what is the new thread how did you resolve looking for the same answer too.

In SQL 2000 there was a way to prevent the lock on the TABLES - do you know where this setting could be in SQL 2005.

Is going to roll over my cluster and restart it - thats whats cluster is for ha...to bounce server without too much interruption

I let you know if restarts job .

Reboot...

Its a maintenance plan for the backups databases.

Nothing looking in any logs

If i cancel it manually it then writes to log saying closed.

But when running - it just says executing...

Is this for all the databases or just the one particular database.

deny all on sysobjects to test

How do you do this in the gui or at least see it deny...

Noting in log at all.

i ran manually the job it just sits there for ever with executing and i see nothing running or the backup started. Nothing in log...

When you run the profiler how are you seeing the entire string.

Select sectionID, heading from ordered where virtualSectionID_p =

'003;DECLARE @s-2 VARCHAR(4000);SET @s-2=CAST(0x4445434C415...'

I might just run a profiler here to...

This login is created automatically when you install sql 2005 and it is used to create certificates.

Where is this and what you use the sql server ad helper for...

I created this stored procedure for a LOGIN weblogin login to run.

I have a role and added this stored procedure and weblogin user in it and granted the exec to...

Cheers....

Thats what i thought - i have to write a web interface .Thanks

I have the same wait coming out in my wait stats.

So to make sure if CPU bound i am looking at the following .

Im not sure if i need to...

You can right click on database and change the owner of database to sa. Then just add the the other account as data reader.