Reply to your first que to find out unused index.

found from Technet library

you can try this

SELECT SCH.name + '.' + OBJ.name AS ObjectName

...

Thanks Dev i was thinking same . let me work out on what you said .

perfect thanks for your information.I will try that way and let you know how it works.

Have a good day

Hi ,

So there is one operator for your DBA distribution list am i right?

Does this distribution list works in sql notification?

I have created group sql notification with 3 diff users and i want to notify the job status to all when it finish...

I also like to know how you script out sql agent job , operators,Maintenance plans , all users mapping .If some body has script or the way to do it...

Thanks a lot for kind reply and help for everyone i got my database back in normal.

I just did restore process again and worked nicely.

Also got to know about "Restart"...

Is there any other way rather than to DROP?

Thanks for kind Info very useful thank you

trying to find out to minimize the batchrequest/sec .Some times it goes very high.

thanks for reply ,Yes we have reporting enviornment and lots of reports runnning all the time .

so how we can chane that report to run only 1-2 queries...

try this

1.

Start Business Intelligence Development Studio, click Help, and then click About Visual Studio.

2.

In the list of installed products, click Reporting Services. The version information appears in the product...

I prefer SQL Agent more Secure and best way. I am using SQL Agent to run batch File also.

Hi Marvin.

Your Stored Procedure looks great but when i am trying to run i didn't see anything happening so if you explain detail where to make changes and which...

can you explain me how to run this SP .

I am trying to run but nothing is happeing even though saying execute successfully .