RSS feed

Unable to Create Index for a Table in SQL Server Management Studio 2005

Published by: Guest (9/27/2008 11:12:52 AM)

SEP 27 2008

I used sql server management studio to import data from xl sheet and create some indexes. I could only create a primary key and failed to create any other indexes. I got this error while trying to create an index: ’table (dbo)’ table
- Unable to create index ’IX_table’.
There is insufficient system memory to run this query.
The statement has been terminated.


Unable to modify table. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column >>

<< what is the command to list all tables in a database in SQL Server



You can use HTML tags here.
*Code: Please enter the sum of 5+2