In South Africa December is summer and therefore lots of companies close then. We close for three weeks and sometimes two. Three weeks is my holiday leave for the year...

Abu Dina (6/19/2013)

---

CREATE TRIGGER [DDLTriggerLimitNumberOfDBs]

ON ALL SERVER

FOR CREATE_DATABASE

AS

SET NOCOUNT ON

DECLARE @MSG VARCHAR(500)

...

Perry, I hope we are at peace now. I have a feeling I can still learn a lot from you.:-)

Perry,

Thank you I actually did go and read your article and actually have learnt something new. I also saw another article[/url] that clearly explained the disadvantages of detach/attach.

I must honestly...

Perry Whittle (6/11/2013)

---

Manie Verster (6/10/2013)

---

You have chosen to link a rather ancient article that covers SQL Server 7.0, 2000, 2005 which is no longer relevant. Under SQL Server 2000 you...

I think it is very important to TEST all scripts gotten from...

Jeff Moden (6/10/2013)

---

Nice article, Mannie. Yes... I absolutely agree. Reading the comments is important. That's why most of the scripts I post on the forums say "Details...

I remember that thing. The first two instructions indicated that you were to put your name and date on the test (different spots, depending on the test) and that was...

You have chosen to link a rather ancient article that covers SQL Server 7.0, 2000, 2005 which is no longer relevant. Under SQL Server 2000 you had to detach a...

The point of this article is not whether it is the best way of doing it but to READ the whole article and/or comments BEFORE you start because you could...

Actually my SSL is checked and I also found out that gmail...

Unfortunately, I think, you will have to import each file manually using the wizard. Sql Server express does not leave you with a lot of options. Somebody correct me if...

Thanks for the script. I just need you to please post me the script for sp_getDDL then I can fully test this solution and see if it will work for...

Yes! I know but how and to what? I don't have a cooking clue. Can you help maybe, Perry?

anthony.green (6/6/2012)

---

Manie Verster (6/1/2012)

---

anthony.green (6/1/2012)

---

I might be wrong, but I thought that option was for SQL Mail and not DB Mail so therefore shouldn't be in 2012 as SQL Mail...