I just created a script today since I could not find it anywhere.. it would be gr8 if any of you would go through this and let me know...

To detach, you will surely need to take the db offline. The easiest way is right click on the db and click take offline(make sure there are no important users...

The following are the reasons for high Virtual memory usage:

There are a large number of databases on the system (for example, more than 500).

Most of the databases are updated (for...

SQL Express holds all necessary stored procedures, service broker queues, etc... for proper mail handling.

However when you try to send an email the processing of queued mails fails with because...

This error is occurring because the database LOG file is either too large for what has been allocated or the SQL server disk is full. Here are some important things...

Thanks a lot.. that was really informative.. 🙂

Hey thanks a lot... 🙂 .. that was Gr8

I do not get the corect nos.. can u pls let me know which are the fields , and do I need to do any conversions, like conversion from extents...

Hey..thank u so much.. I really did not notice the comments 🙂

That exactly is the issue, but that proc source code is not there in that link as well.

Replying to being this post on top, so that I have a better chance of getting a response

Can someone please give a similiar suggestion for SQL 2000.

Thanks you so much for the reply :-).

More suggestions are welcome 🙂

The issue is I need to setup a job, which scripts out the indexes of a few tables. What I am looking for is a script or a hint...

could it be probably that there is more activity on the itanium one, that it requires the max allocated memory