It's to do with permissions. Your SQL service account if you lock things down may only have permissions on the specific directories that were created as part of the install....

If your tempDB is on the same disk as your user db you will have the same issue of running out of disk space so take this into consideration

It is not an option for alter index. You will need to do an alter database. Either BOL or MSDN will give you the syntax to create the new file...

Vinod,

Unless you have another drive available on the server to create a new file group on you will not get any benefit.

If you are not able to have some...

What version and edition are you using ? Are you doing an online rebuild ? Indexes do consume disk space as the indexes unless you specify where they built they...

Also to help you discover where most of the recessing time is being undertaken you could do the following in SSMS :

Set statistics io on

Set statistics time on

Run query

Set...

SSMS can be a little finicky and does not automatically refresh. You can select any part of the tree nodes and refresh at the highest level or by selecting something...

A SQL Server account is exactly that. It only has permissions inside the instance of SQL Server. The account may be given permissions to perform backing up a database. As...

I have been struggling with another issue which i have not been sure if it is related or not.

having just recently migrated from 2000 to 2005 i have hit an...

Paul thx for that. That gives me a good starting point. I will have to go and have a look at each of the DB's inidividually as well to check...

If running the sp_helpdb in master it is fine. If running it in the user DB then i get the same error.

I have run the suggested query from earlier but...