you would want to take a look at the action tab on the chart properties

http://msdn.microsoft.com/en-us/library/aa964128%28v=sql.90%29.aspx

Around half way down is this sub heading "7. Add a drill-through action on the sales...

Has DBMail been configured, SQL Agent Alert system set to use a mail profile and SQL Agent been restarted to take the changes into account?

Perry Whittle (3/12/2012)

---

anthony.green (3/12/2012)

---

I dont believe this is true anymore, as you can install LiteSpeed in restore only mode which doesnt ask for a licence key as your not using...

MysteryJimbo (3/12/2012)

---

Assuming you fulfill licence requirements for source and destination, you can use litespeed for logshipping.

If you dont you can still logship but you will need to either perform a...

a typical day is start at 08:00 finish at 16:30, but then i'm on call 24/7/365 so technically i could work every hour of every day all year if there...

run a profile trace on the server/instance in question

select the blank template from the templates section on the first screen, then select all the events for the audit login failure...

there is a tool called RSScriptor which I've used in the past, start putting in a change versioning / source control mechanisum where you store the solutions and rdl files...

Thanks Markus, I will take a look at them.

the only freeware tools I have found are Quests discovery manager so I can see who is installing SQL out on the network without us knowing and PowerGui for developing...

Sorry, I was focused on the Server 2008 and SQL 2008R2 line at the top.

Perry, while I totally agree with you with migrating should be a full redeployment from the base solutions again or by using tools to script out and redeploy from an...

one thing i would say as well is with the move from 2000 to 2008 I would only copy the user databases not the system databases, dont restore them over...

Sorry Ravi, it seems like I have lost the ebook and I cant find it on Amazon. Sure the title was something along the lines of designing business dashboard...

if you send me a private message i will send on the completed scripts (minus a few things) and a sample of a few reports as a starting block

i will...

@chris-2

The metrics I have so far are

free drive space, db size and free space, job failures, memory usage,a few metrics from sys.dm_os_perf_counters, DDL changes, sys.configuration changes, permission changes, CPU usage,...