Wow, lots of replies and quick on this one. Thanks.

In our case the drive space is definately not an issue adn when I make this change I will leave...

divyanth (3/26/2010)

---

I looked at the example you referenced and downloaded the sample file the author provided but its still not clear. What I rally need is an on line...

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...