Thanks for the reply & code but because we reboot each day I have the same problem with this query and that is that just because the index isn;t used...

Jack,

I feel like I've asked this before (of you) but I can;t infd a story or forum to that effectw ehn doing a search so if I have and have...

divyanth (3/25/2010)

---

Use Import/Export wizard in SSIS to complete the Data Flow Task part. You will be left with Control Flow task and all you need to do is use a...

Bhuvnesh (3/25/2010)

---

Very valid and good approach you are going to adapt.

but before doing this how come you know that few indexes are not being used ?

Did you see any...

Fraggle,

I didn't think there was anything like this because I did not think there was any reason other then a scenario like you have listed that you would have to...

Sorry but no, not yet.

lmu92 (3/12/2010)

---

I guess the answer is "it depends".

But there's one thing I wouldn't do: using sp_send_dbmail directly within a trigger, since the mail sending process would become part of the...

Johnathan,

I just wanted to check back on this and see if you had done anything else with the whole issue of security and using DB mail on SQL Server? ...

Its clear to me now after all the replies so far that no matter how many times I try I am not able to properly convey my situation/scenario and I...

Lynn Pettis (3/10/2010)

---

YSLGuru (3/10/2010)

---

homebrew01 (3/10/2010)

---

YSLGuru (3/9/2010)

---

First off thanks to everyone who has taken the time to contribute, it is appreciated as always.

What has ........to do a restore.

Look I...

george sibbald (3/10/2010)

---

YSL,

this sounds like a DR strategy put together by a non-DBA, who likely would not even consider backups of the system databases because they did not realise their...

Steve Jones - Editor (3/10/2010)

---

Thanks for the repeat of the info, as I actually missed a touch there when I read through things.

Try not to get too defensive as many...

CirquedeSQLeil (3/10/2010)

---

Nobody has said that you...

Kit G (3/10/2010)

---

The main concern of your argument seems to be, "Why backup system databases when I can just re-install cause things haven't changed much and I have the scripts...

YSLGuru (3/10/2010)

---

Steve Jones - Editor (3/10/2010)

---

I'm late, but I always have done daily master, msdb, model. Things rarely change, but they always seem to have changed right before something breaks....