Lowell (12/3/2012)

---

the event data is going to have the new database name...it's already been changed by thetime you get to the ddl trigger, unless you force a rollback.

you could rollback...

This is my new ALTER_DATABASE trigger:

CREATE TRIGGER [DDLTriggerRenameDatabaseBackupSchedule]

ON ALL SERVER

FOR ALTER_DATABASE

AS

DECLARE @data XML

DECLARE @NewDBName VARCHAR(256)

...

Thanks arunyadav007, I understand this part but I'm not really sure how to actually implement the ALTER_DATABASE trigger.

When the new trigger fires, how do I access the old database name...

I've installed SQL Server 2008 R2 with SP2 now I want to install the latest Cumulative updates which I also downloaded from http://support.microsoft.com/kb/2754552#appliesto and this is what happened:

I ran the...

Thanks Tony.

Forget sp_who & sp_who2

You want sp_whoisactive

http://sqlblog.com/blogs/adam_machanic/archive/tags/sp_5F00_whoisactive/default.aspx

trowsell (11/22/2012)

---

Hi, hopefully a bit of an obvious question, but I need to run the following on a daily basis to insert data older than 1 month from today into...

The answer depends on what you're trying to accomplish with the query.

a LEFT join merely tells SQL server to return ALL record from the table that's on the left side...

anthony.green (11/20/2012)

---

Also can you explain your reasonings behind putting a SQL server in the DMZ? Typically you would want your databases to be on the secure LAN protected by...

Thanks Tony.

I have more questions sorry! if anyone can point me in the right direction I'd be eternally grateful!

1) The new box will not have any locally installed application that...

If you can secure the SQL role that'd be great.

I'd skip the digitalisation technologist Job WTF?! to be honest.

Good luck!

Thanks Vegard. I now understand your point. I think my confusion is because I didn't see a SQL Admin group when I view the users/groups in computer management. I assume...

Vegard Hagen (11/19/2012)

---

I agree with SpaghettigDBA regarding disk config for tempdb: While it is nice to have a dedicated tempdb drive on large production servers, you don't need to split...

Vegard Hagen (11/19/2012)

---

I agree with SpaghettigDBA regarding disk config for tempdb: While it is nice to have a dedicated tempdb drive on large production servers, you don't need to split...

Ah but this is only valid for a server that's in the domain which mine isn't. Have...