SQL SERVER 2000
System let's you alter the system tables and add indexes. However, it won't
let you drop the index afterward.
Anybody know how to drop an index on a system table?
Thanks,
Kevin 4 2322
"Kevin Haugen" <kh*****@pacbel l.net> wrote in message
news:3s******** *******@newssvr 29.news.prodigy .com... SQL SERVER 2000
System let's you alter the system tables and add indexes. However, it won't let you drop the index afterward.
Anybody know how to drop an index on a system table?
Thanks,
Kevin
You don't say which table or what error you get, but in any case Microsoft
does not support any modifications to system tables, so the best option is
probably to restore from a backup. If you can post more detailed
information, then someone may have a better suggestion, but in general you
shouldn't touch system tables at all.
Simon
"Simon Hayes" <sq*@hayes.ch > wrote in message
news:41******** **@news.bluewin .ch... "Kevin Haugen" <kh*****@pacbel l.net> wrote in message news:3s******** *******@newssvr 29.news.prodigy .com... SQL SERVER 2000
System let's you alter the system tables and add indexes. However, it won't let you drop the index afterward.
Anybody know how to drop an index on a system table?
Thanks,
Kevin
You don't say which table or what error you get, but in any case Microsoft does not support any modifications to system tables, so the best option is probably to restore from a backup. If you can post more detailed information, then someone may have a better suggestion, but in general you shouldn't touch system tables at all.
And further more, with some of the tables, it may appear you've succeeded,
but in reality nothing has changed, or upon a restart things were the way
they started. sysjobs I believe is one such derived table. Simon
"Simon Hayes" <sq*@hayes.ch > wrote in message
news:41******** **@news.bluewin .ch... "Kevin Haugen" <kh*****@pacbel l.net> wrote in message news:3s******** *******@newssvr 29.news.prodigy .com... SQL SERVER 2000
System let's you alter the system tables and add indexes. However, it won't let you drop the index afterward.
Anybody know how to drop an index on a system table?
Thanks,
Kevin
You don't say which table or what error you get, but in any case Microsoft does not support any modifications to system tables, so the best option is probably to restore from a backup. If you can post more detailed information, then someone may have a better suggestion, but in general you shouldn't touch system tables at all.
Simon
I have an ERP application which constantly scans the sysobjects table for
xtype ''U'. I was attempting to speed up this particular SELECT statement
by adding an index to the xtype column (which seemed like a good idea at the
time). I ran a DBCC CHECKDB and it threw msg's 8951 and 8955. I actually
came across the problem when I tried to apply the script referenced in KB
293177 when it failed to complete.
I'm currently working on restoring the database into a new schema to resolve
the issue.
Kevin
Kevin Haugen (kh*****@pacbel l.net) writes: I have an ERP application which constantly scans the sysobjects table for xtype ''U'. I was attempting to speed up this particular SELECT statement by adding an index to the xtype column (which seemed like a good idea at the time). I ran a DBCC CHECKDB and it threw msg's 8951 and 8955.
It is dubious that even if sysobjects would be a normal table that this
would be a good thing to do. The column may not be selective enough.
In any case, in the next version of SQL Server, SQL 2005 which currently
is in beta, there is no longer any sysobjects table. There is a sysobjects
view which is built on top of the new catalog views, which in their turn
are built on tables that are not exposed at all.
I actually came across the problem when I tried to apply the script referenced in KB 293177 when it failed to complete.
I have no tried that script, but it may be that you should throw in an
INSENSITIVE before CURSOR.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Sabrina |
last post by:
Hi everybody,
I need some help in SQL Server. I am looking for a command that will "Drop
all user table" in a
user database.
Can anyone help me?
Thank you very much
Sabrina
|
by: BuddhaBuddy |
last post by:
Platform is DB2/NT 7.2.9
The table was created like this:
CREATE TABLE MYTEST (
MYTESTOID bigint not null primary key,
FK_OTHEROID bigint not null references other,
FK_ANOTHEROID bigint not null references another,
FK_LASTLYOID bigint not null references lastly,
unique (FK_OTHEROID,FK_ANOTHEROID))
|
by: SamSpade |
last post by:
There seems to be two ways to put things on the clipboard ( I don't mean
different formats): SetClipboardData and OleSetClipboard
If I want to get data off the clipboard do I care how it was put there?
What about Drag/Drop; is there more than one way for the source to make data
available
Is it always OLE?
|
by: Ajay Krishnan Thampi |
last post by:
I have a slight problem implementing 'drag and drop' from a datagrid
to a tree-view. I have pasted my code below. Someone please advice me
on what to do...pretty blur right now.
==code==
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
|
by: Vigneshwar Pilli via DotNetMonster.com |
last post by:
string connectionString1 = "server=(local); user=sa;password=sa;
database=sonic";
System.Data.SqlClient.SqlConnection dbConnection1 = new
System.Data.SqlClient.SqlConnection(connectionString1);
System.Data.SqlClient.SqlCommand dbCommand1 = new
System.Data.SqlClient.SqlCommand();
| |
by: VB Programmer |
last post by:
In VB.NET 2005 (winform) any sample code to drag & drop items between 2
listboxes? Thanks!
|
by: rcamarda |
last post by:
Hi,
I found this SQL in the news group to drop indexs in a table. I need a
script that will drop all indexes in all user tables of a given
database:
DECLARE @indexName NVARCHAR(128)
DECLARE @dropIndexSql NVARCHAR(4000)
DECLARE tableIndexes CURSOR FOR
SELECT name FROM sysindexes
|
by: Romulo NF |
last post by:
Greetings,
I´m back here to show the new version of the drag & drop table columns (original script ). I´ve found some issues with the old script, specially when trying to use 2 tables with drag&drop on the same page (which was not possible). Now i´ve a new concept of the script, more object oriented.
I´ve also commented the whole code so you guys can easier understand it engine.
What exactly we need when trying to make a column drag &...
|
by: dsdevonsomer |
last post by:
Hello all,
I am new to managing indexes on large tables and need some help.
Hopefully, I am not repeating question here. I searched as much as I
can, but not finding relatively best answer..
Here is my scenario.
I have 2 tables with more than 4 mil rows (1 - 2.8 Mil, 2 2.1 mil). Of
these tables, there are about 25 ( select ) queries run to help
generate reports every week.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |