SQL Server, disable

microsoft.public.sqlserver.server - Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.


SQL Server >> disable

by Bill » Thu, 16 Sep 2004 04:26:58 GMT

Is there a way to disable/enable all the indexes in a
database? Thanks.

Top

SQL Server >> disable

by David Portas » Thu, 16 Sep 2004 04:53:01 GMT


Please tell us what you want to achieve and explain just what you mean by
"disable".

You can force a table scan or clustered index scan in queries using the
index hint: WITH (INDEX(0))

--
David Portas
SQL Server MVP



Top

SQL Server >> disable

by Hari Prasad » Thu, 16 Sep 2004 12:26:39 GMT

Hi,

Probably , you can script the indexes and drop the indexes

Thanks
Hari
MCDBA







Top
Similar Threads

1. Disable "disabled" field formatting 

I have a form where I have three currency fields - Price, discount, and net.

There's really no need to hold the "net" data on a table since that's easily 
calculated.

So... I have created the "net" field to be calculated on my form.  Since it 
only gets derived from the other two, I have it "disabled".  However, I want 
people to be able to read it as well as anything else, so the "graying" 
effect that shows the field is not enabled is NOT what I want.

Short of enabling the field, is there any way to turn that automatic 
formatting off?

2. How to disable startup forms when code have access window disabled - Access Forms

3. disabled radio button labels don't look disabled (grey)

4. Disable control on exit - Can't disable control that has focus - Access Forms Programming

5. Disabling Parent window without disabling child window. 

Hi Sir,

          How to Disable the Parent window without disabling child
window(modal Dialog) other than EnableWindow() function.


Thanking You..

Regards,
Ravikiran P S

6. Disable a button in Javascript disables server-side code - ASP.NET Web Controls

7. Disable page caching without disabling caching of jpegs and stylesheets etc 

Hi,

We have a data based web app that basically must not cache any of the
pages as they contain real time data.

I am currently using the following line in the page template on the
PreInit event:
Response.Cache.SetCacheability(HttpCacheability.NoCache)

Will this prevent things like Jpegs and CSS stylesheets from being
cached as well?

If so is there another way of doing this?

Cheers,

James

8. Disable taskbar without disabling record button