Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Creating index

Author  Topic 

balakrishnachow
Starting Member

24 Posts

Posted - 2010-11-28 : 07:21:44
hi,
can any body help us,

we have 80gb table in one of the database and it is in enterprise edition 2005,when we are creating clustered index on that table it is showing memory insufficient error.we have disk space is 30 free and we enabeld awe options also up 10 gb and we have 30 gb ram more over in that server we have 4 instance.why we got this error and we are unable to create the index as well

can you help us asap

thanks
balakrishna

good

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2010-11-28 : 07:44:36
What is the exact error message?





Poor planning on your part does not constitute an emergency on my part.

Go to Top of Page
   

- Advertisement -