One another option is CDC (Change Data Capture).

Another option is

1) Don't give delete permission to normal users

2) Allow delete only from the stored procedure. In the stored procedure, save the required information.

1) Yes

2) Yes

You need to insert the missing rows in the subscriber manually.

NO

Try http://personal:8080/reportserver

It will take couple of minutes to load the page. So have patience.

Make sure that Reporting Services is running.

Check the Reporting Services Configuration Manager. It clearly shows the...

I added a SUM in the second line and corrected the wrongly placed brackets.

select sum(signal_wait_time_ms) as signal_waits_time_ms

,CAST(100* (sum(signal_wait_time_ms)/sum(wait_time_ms)) as numeric(20,2)) as [%signal_cpu_waits]

,sum(wait_time_ms-signal_wait_time_ms) as [resource_wait_time_ms]

,cast(100*(sum(wait_time_ms-signal_wait_time_ms)/sum(wait_time_ms)) as numeric(20,2)) as ['%resource waits']

from sys.dm_os_wait_stats

Yes. DBCC CLEANTABLE works...

Try

DBCC CLEANTABLEHope this helps you.

hany_amien (11/24/2010)

---

i followed the steps shown in how to resolve it :

1- recored the SID

2- drop the logins, got error "server: Msg 15175, Login 'sysadmin' is aliased or mapped...

Sam -480699 (11/24/2010)

---

It's my understanding that you can have 2005 SQL as a witness, as far as I know it shouldn't be a problem? I did try...

Yours principal and mirror server are SQL 2008 version. Witness is 2005.

Also Witness IP (10.0.*.*) is different from others.

Do you have databases with auto-close, auto-shrink on. That may be causing disk activity...

Thanks Drake.

The information you provided helped me.