durai nagarajan (6/21/2012)

---

Schadenfreude-Mei (6/21/2012)

---

What was the fill-factor before you stared? I'm guessing 90%.

Youu could try (on a seperate server with a database copy), rerunning your maint plan but changing the...

What was the fill-factor before you stared? I'm guessing 90%.

Youu could try (on a seperate server with a database copy), rerunning your maint plan but changing the per-page fill-factor to...

Thanks Lowell.

For the interest of anybody, we have decided to go with the below: Origenal code pilfered from here.

/****** Object: DdlTrigger [Logon_Trigger_Monitor_Excel] Script Date: 06/13/2012 16:32:40...

Lowell (6/13/2012)

---

another possibility, but where you would have to grant execute permissions to Everyone ON xp_logininfo (or the trigger has to Execute AS a power user's context) so they...

Hey All,

I have moved along with this and now have the below which i have been testing on my ss2k5 local instance.

/****** Object: DdlTrigger [Logon_Trigger_Monitor_Excel] Script...

All,

Thanks for the speedy responses. Lowell, that quite a good idea but I think Andrew's query is more what I'm looking for, needing no additional rights or tables.

Thanks again.

A.

Thanks all for your responses. This has now been resolved.

I stopped both endpoints (principle and mirror) and restarted and the unsent log now goes down to 0KB.

The article I...

Can nobody help?

Have always thought Unforgiven was a bit weak. And Unforgiven II......... Dont get me started.

oh well.

Sandman and Of Wolf and Man must have been good.

prettsons (5/30/2012)

---

The I/O error (torn page) error occurs when SQL Server tried to access a page that had previously not been written to disk correctly. This can be happen due...

Koen Verbeeck (5/30/2012)

---

I'm alive

Metallica was great, although...

Eugene Elutin (5/28/2012)

---

Schadenfreude-Mei (5/28/2012)

---

pdanes (5/28/2012)

---

Eugene Elutin (5/24/2012)

---

P.S. There is an universal solution to stop queries running forever:

Ask electrician to connect your server room power supply via your floor light...

Do you know how the log was deleted? It shouldnt have...

It could likely be that your 'user/login' just requires dbo rights to a database. You will probably find that as a domain admin or local admin under to ss2005, you...