When I first went from EM to SSMS a few years ago, I absolutely HATED SSMS ... couldn't stand it. Yet after about 6 months or so, I refused to...

Unfortunately no, you can not rename an instance. You'd have to tear down and rebuild. I've heard it can be done, but is not advisable ... due to all the...

simon phoenix (9/26/2008)

adam

I tried the test mail it worked just fine, just one mail at a time. It seems like exchange problem as you mentioned but do you know forum...

SELECT SERVERPROPERTY('Edition')

Are you running on enterprise? If so, you can rebuild online.

kumaripaleti (9/26/2008)

could you please let me know how to change the log file path in the registry. I changed the path and I am getting the same error after I...

That sounds like an exchange issue then?

To verify, can you just send an email without your logic as a...

Very odd ...

SELECT * FROM msdb.dbo.sysmail_allitems

You see your entries in there twice with the same time stamp?

Not sure I can buy that Simon ... I've never heard of such a thing and I use database mail very heavily. Not to say it isn't possible ...

Can you...

Just a couple I currently use that work pretty well ...

I display everything in reporting services with graphs (managers love the graphs):

- DDL Changes

- Job Activity Monitor (History, Trending)

- Backup...

Idera has a pretty nice admin tool kit for a few hundred bucks that should be right up your alley.

http://www.idera.com/Products/SQLadmintoolset/%5B/url%5D

Depending on exactly what you're looking to do though, all...

You shouldn't be using DBCC commands for index operations in 2005.

As for the question at hand, what are you going for here? What is the best way to rebuild...

I think you need to focus on exactly what you're going for first ... all of this data and more is available in DMV's/WMI counters. It's all easily accessible ...

Sounds like a problem in the procedure. Feel free to post it here and I'm sure we can be of more help.

Perfect, thanks Gila.