It returns NONCLUSTERED .

Is there any other way other than dropping the primary key and the foreign keys.

How...

what did you get when you gave

select * from sysservers

Give .csv extension instead of .txt

sorry had given then wrong script

Have edited the 1st post.

Can you please help me with this.

Checkout:

http://support.microsoft.com/kb/263556

http://blogs.techrepublic.com.com/datacenter/?p=363

See if xp_cmdshell is enabled or not

you can find that in surface area config,

Using xp_cmdshell you can only run one command at a time unless you give "&" between the...

SQL Server Standard edition includes the core database engine, along with the stand-alone services. It differs from Enterprise edition in that it supports fewer active instances (number of nodes in...

What is the table structure and also give the query you are using to get the output.

What about in 2000.

My server has both 2000 and 2005 databases.

hi_abhay78 (6/22/2009)

---

generally as a rule of thumb we rebuild indexes having fragmentation more than 30% and and reorganize if the fragmentation is below 30% .

to find the fragmentation > 30%...

No

GilaMonster (6/19/2009)

---

Without seeing the procedure all I can suggest is to try and replace the cursor...

Can you please help me with how to about optimizing stored procedures containing cursors.

What is the difference between clustered index seek and scan.

how to reduce cost %.

.

:unsure: