Viewing 15 posts - 31 through 45 (of 619 total)
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...
June 14, 2012 at 9:33 am
Lowell (6/13/2012)
June 13, 2012 at 8:31 am
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...
June 13, 2012 at 8:18 am
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.
June 13, 2012 at 5:36 am
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...
June 6, 2012 at 3:22 am
Koen Verbeeck (5/30/2012)
Enter Sandman, Sad but true and Unforgiven were pretty awesome 🙂
Have always thought Unforgiven was a bit weak. And Unforgiven II......... Dont get me started.
May 30, 2012 at 3:49 am
oh well.
Sandman and Of Wolf and Man must have been good.
May 30, 2012 at 3:39 am
prettsons (5/30/2012)
May 30, 2012 at 3:08 am
Koen Verbeeck (5/30/2012)
anthony.green (5/28/2012)
So I wonder if Koen is still alive or if he got taken to hospital with burst ear drums over the weekend
I'm alive 😀
Metallica was great, although...
May 30, 2012 at 3:00 am
Eugene Elutin (5/28/2012)
Schadenfreude-Mei (5/28/2012)
pdanes (5/28/2012)
Eugene Elutin (5/24/2012)
Ask electrician to connect your server room power supply via your floor light...
May 29, 2012 at 5:54 am
venkatb.dba (5/28/2012)
Hi,Thanks for your reply!!!
The database is in simple recovery model. and i have no backups available for the database.
Regards,
Venkat
Do you know how the log was deleted? It shouldnt have...
May 28, 2012 at 8:47 am
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...
May 28, 2012 at 8:33 am
pdanes (5/28/2012)
Eugene Elutin (5/24/2012)
Ask electrician to connect your server room power supply via your floor light switch, so when...
May 28, 2012 at 8:17 am
Eugene Elutin (5/28/2012)
Ian Scarlett (5/28/2012)
Hmmm... I wonder if the OP will start going for interviews as a plasterer with all this knowledge being imparted. 😛
I can say (reading detailed DIY...
May 28, 2012 at 7:55 am
Viewing 15 posts - 31 through 45 (of 619 total)