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.
| Author |
Topic |
|
mani_1234
Starting Member
24 Posts |
 Posted - 2012-09-18 : 00:43:26
|
| hi all .i want to know is there any condition when index creation fails on table ? though i have taken into consideration that no index created before on it ,data types are supportable for creating index . i read in internet that when we have read only table u cnt create index on it bt its not true .. share some other reason |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-09-18 : 01:03:50
|
syntax error ? invalid column name ? access rights ? creating unique index on non-unique data etc ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
mani_1234
Starting Member
24 Posts |
Posted - 2012-09-18 : 01:19:36
|
| thanx for your reply ..is there any internal property that lead to the failure of creation of index?all the syntz error ,invalid column name are fine ..what access rights are required for creating it ..please explain more |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-18 : 01:30:10
|
| Are you receiving an error? Can you post it?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
mani_1234
Starting Member
24 Posts |
Posted - 2012-09-18 : 01:38:27
|
| no i m not gettng any error for same ..its a kind of R&D that i was given ...bt from yesterday i was not able to find out the reason for it |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
|
|
|
|
|
guidance