thanks...It is very nice article.

If you have any script related to this please give me.I have urgent requirement.

Thanks for reply.

I want to use some inbuilt SQL features.

Even though I add new connection but it is still not working. How can I change the default connection?

Thanks for reply.

I have done it by creating group email id of all ten people.

Thanks for reply.

We can do this by making one group email id for all ten peoples but i don't want to use this option.I want to do it from SQL...

Thank you for reply.

It is helpful for me.I have registered for Microsoft Download Notifications.If you have any more information regarding this post please share with me.

Thanks for reply.

but actually i want mail or alert when microsoft release new version of SQL and service pack.

If any boday has idea please revert.

I got below mentioned query which will give list of unused table since the SQL services started.It is for MSSQL 2005. Is there any way to get list of unused...

Thanks for reply.

I don't want to use profiler and create job for getting list of unused tables and stored

procedures.

Is there any other way to get list of...

Thanks for your reply.

Your reply was very helpful for me to understand the concept of dbcc checkdb command.

Now i want to corrupt the table in database to test...

Thanks for your reply.

So what I have to refer dump file which is created in the SQL server Log directory or sql error log from enterprise manager/management studio?

After the dbcc...

Thanks for reply.

It is useful for me at some extent. If you have any more idea regarding this please share with me.

On checking evenviewer on one of problem desktop following error is shown in application log:-

EventView is showing errro : Faulting application profiler90.exe, version 2005.90.1399.0, stamp 434f613c, faulting module kernel32.dll, version...

thanks for reply.

Anything else without creating trace. I don't want to use trace.