the problem lies in the details... your default constraint for the usermodif is trying to insert the sid of the execute as user but is failiing cause the column length...

From the first look at it i would say the reorganize task is waiting for the completion of the notify operator task and the rebuild which will not happen.

local system cant access network shares if the file is located there?

thats a typical permission problem read the security considerations on this site

http://msdn.microsoft.com/en-us/library/ms141766.aspx

To run a package in 32-bit mode from a 64-bit version of SQL Server Agent, select Use 32 bit runtime on the Execution options tab of the New Job Step...

Because acct_id is the first column in the index it is ordered by the acct_id and can do a seek on it. If you want a seek instead of a...

The group by has to read all the values in the specified columns so it’s doing a scan over the index while your second select is looking up a single...

Unfortunately the only way to backup a single table from a backup is if you had it put on a separate filegroup and restore that

in the sqlserver log/error file

so true 😀

you can look it up on technet here:

We mainly have .net code and are using the native client where you can configure the mirror server native client will then handle the failover on the client side automatically....

for upgrade reasons you can mirror from 2005 to 2008 but you can not failback

i am using alter database xx set partner failover to manually failover mirroring and test the behavior on the client side

i am using alter database xx set partner failover to manually failover mirroring and test the behavior on the client side