Cannot delete table

hi, i'm trying to delete a table (suspected to be corrupted or with errors)
into my database using Sybase Central but then it just hung.

while trying to view the corresponding columns of the said table, again my
server just hung and remains to be idle.

my .db is in Sybase ASE 11.9.2 running in Window NT 4.0

kindly help. thanks.

�������������������������
Rodelio R. Ampon
Management Advisory Service
DEPT. OF HEALTH
rra@doh.gov.ph
�������������������������


0
Bong
11/10/1999 3:58:01 AM
sybase.sqlserver.admin 2338 articles. 0 followers. Follow

0 Replies
394 Views

Similar Articles

[PageSpeed] 23

Reply:

Similar Artilces:

Deleting the master table withour deleting the child tables
Hi i have to delete the master table data without deleting the child table records,is there any solution for this,  parent table has relation with the child table. regards vinod.t.vSoftware EngineerUshustechTechnoparkTrivandrum India You need to temporarily disable constraints on the table. Disable constraints: ALTER TABLE MyTable NOCHECK CONSTRAINT ALL Enable constraints: ALTER TABLE MyTable CHECK CONSTRAINT ALL    If this post was useful to you, please mark it as answer. Thank you! Thanks johram i can try this solution, this is usefullSoftware Enginee...

How to delete duplicate row from table in sqlserver ?
Hi, any one can tell me how can I delete duplicate rows from my table, I don't want to delete all records from my original table, just I want to delete duplicate.  select distinct * into t1 from MyTable delete from MyTable insert into mytable select * from t1 drop table t1   Please  have look on following link   http://www.dotnetspider.com/forum/155999-how-delete-duplicate-rows-my-table.aspx  Hi,sumaiya U can delete duplicate records Ya Try This Example    In this Below Row 3  and 6 are duplicate entries   create table T...

how to delete tables from database(sqlserver 2000)
Hi all, I have a data base in Sqlserver 2000, while creating it it was created with some systen tables. Now i am going to launch my website, so i would like to delete those tables from the database, b'coz i have my own tables that i use with the website. My question is can i delete that tables from the database or not, if i delete them are they going to effect my database in any way. r these tables required to work with my database. Do i have to copulsarly keep those tables. There r some tables with a huge records in it. I dont want to waste my space for these tables, the webhoster i...

Problem with Entity Model after deleteing table: cannot delete in Store, there can't add same table again
Moved by moderator XIII: This question's more related to the designer of Visual Studio 2008. Questions about Entity Framework itself should be posted into the Data Access forum:  Hi,  I am having a problem creating an Entity Data Model using Visual Studio 2008. To reproduce... Create a new data model. Added some tables by selecting Update Model from Database. Look in the Model Browser, tables are added under Entity Types. Delete one of the tables, the table is gone from Entity Types but is still in the Model Store under Tables/Views Now, when I select Update Mo...

Delete row and delete from table
Hi I need, after delete a grid row, execute a delete statmentProtected Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView1.RowCommand Dim advogado As StringIf (e.CommandName = "Apagar") Thenadvogado = RTrim(e.CommandArgument.ToString)Apaga_Processos(advogado)End Ifend subPrivate Sub Apaga_Processos(ByVal advogado As String)Dim conn As SqlConnectionDim comm As SqlCommandDim connectionString As String = ConfigurationManager.ConnectionStrings("mssql2.tuganet.com").ConnectionStringconn = New Sql...

How to detect that a sqlserver table row has foreign keys and cannot be deleted?
What is the best way to detect that a sqlserver table row has foreign keys and cannot be deleted?Thanks,Keith sp_table_constraints_rowset 'yourTableName'***********************Dinakar NethiLife is short. Enjoy it.***********************...

how to delete from Table A based on Table B
lets say i have 100 employees on Table A and I have 10 employees on Table B. I want to delete all the employees in Table A that are in Table B. Delete From TableA Where EmpNum = (Select EmpNum From TableB)The above SQL wont work but i am looking for something similar. any ideas? You should use IN as your subquery is returning multiple records.Delete From TableA Where EmpNum IN (Select EmpNum From TableB)***********************Dinakar NethiLife is short. Enjoy it.***********************...

Showing table columns from multiple tables in Formview, but insert/update/delete rows of Master table
I have a page on which I have GridView and FomView control. On selection of a row in GridView the row gets displayed in the Item template of the FormVIew. The values are the result of inner join from multiple tables i.e. table Stock,Product and Workshop.  Please let me know how I could insert/update/delete data for the base table i.e. Stock table, but be able to see the column values from the associated tables on the Itemtemplate,Edittemplate and Inserttemplate of the FormView. Thanks,Anita Hi:   Take a look at this tutorial. It's for DetailsView and same ...

LINQ: How to delete automatically on delete from association table
Hi, I'll try to explain my problem with an example:  In DB(ms swl server 2005) I've 2 tables:A(ID, SomeAText)B(AID, SomeBText) In LINQ TO SQL (in mdbd file) I've association:A.ID --- Association ---> B.AIDIn Table B we can have many rows is same AID valueAlso, I've GridView which represents all rows from A table with LinqDataSource.Is there way how to set in LINQ that when delete a row from A table,AUTOMATICALLY all rows from B with AID(which points to ID of the deleting row from A) to bedeleted too ? Thanks in advance! asp.netWHAT ARE YOU CODING RIGHT NOW?G...

Delete admin User / Change admin password
Hey, Is it possible to change the password for admin or delete admin and make anonther admin user?? > Is it possible to change the password for admin or delete admin and > make anonther admin user?? Yes, but PLEASE make another user a supervisor of the root (inheritable) prior to deleting the admin user. Many people rename the admin as well. -- Timothy Leerhoff Novell Support Forum Sysop "I have the body of a god, unfortunately it's Buddah" - T-shirt quote On Sun, 02 Oct 2005 02:41:51 +0000, jwt.fsd wrote: > Is it possible to change the p...

And the hits w.3.0.13 keep coming. Added Portal Alias records in Admin. Now cannot reach my site...on localhost.. Deleted all records from PortalAlias table *except* localhost. No good. Site not
Man o man: Ok.  I go into Admin->Settings->AdvancedSettings and add some portal aliases.  I figure, well nothing's screwed up in at *least* an hour or so, maybe I'll get lucky!  Not.  So I have a bunch of aliases, that when I export the site when a stable version of DNN comes out I'll be all ready to go, right?  I specifically *keep* the localhost/DNNeWriters at the top, since I'd been burned w/that already.  So I add like 12 portal aliases (I have a number of domains that will be redirecting to www.ewriters.org if the miracle happens I ever get...

Deleting a table
I 'm using ASA 7.03.2046 and I have dropped all publications and I went to drop a table but I keep getting a message stating that this table has publications. There are NO publications in this database. Is there something I'm missing here. Thanks, Kevin Please Ignore this posting , I deleted ALL publications for SQL Remote but there was a Mobilink template that had the table in it that I was trying to drop. "Kevin C. Dunn" <no_spam_kevin.dunn@spsinc.com> wrote in message news:GfAGjg5QCHA.245@forums.sybase.com... > I 'm using ASA 7.03.2046 and I...

All tables where deleted
I have been setting up DNN portals on my companys server.  I had a company site and a local boy scouts site. I had worked on these site for the last week, did not do a backup yet.  I am running DNN 3.1.1.Saturday I added SimpleChat_V3 and Gallery modules.  The DNN Gallery beta did not install.  I add SimpleChat to my contacts page. Played with different page positions. This was going good then I got 'page cannot be displayed'.  Monday morning I am looking at my DotNetNuke database and I only see system tables. All dnn user tables have been dropped! I can se...

deleting table?
I have a dw, if i destruct this while start retrieving rows, will it delete the table or affect it somehow?? thnaks in advance The actual data is in no way affected until dw.Update() is called. The only way I know of to delete is a table is to issue Drop Table, which can't be done via dw.Update() "ajay" <ajayvarier@yahoo.com> wrote in message news:wFq7GmBkCHA.198@forums.sybase.com... > I have a dw, if i destruct this while start retrieving rows, will it delete > the table or affect it somehow?? > thnaks in advance > > >>The a...

Web resources about - Cannot delete table - sybase.sqlserver.admin

Donald Trump adds a new target: Ted Cruz
DES MOINES, Iowa (AP) — Republican presidential candidate Donald Trump has finally unleashed a verbal assault on the one rival he has so far ...

‘Star Wars’ Empire to Strike Back at Disney’s Mega Premiere
As befits a movie gunning to be the Biggest Ever, Monday’s Hollywood premiere of “Star Wars: The Force Awakens” is shaping up to be bigger than ...

Google for iOS updated with 3D Touch, iPad multitasking and more
Google has just updated its flaghip Web search app for iOS with several improvements, including ones that take advantage of Apples latest technologies ...

What Your Favorite Cities Could Look Like as a Result of Climate Change
London, after 4 degrees Celsius of warming Today is the final day of the international climate change conference in Paris, where experts and ...

Pandora claims that Steve Jobs 'eviscerated the music industry'
Pandora has recently taken to blaming Spotify for the downfall of the music industry, but on Thursday its leadership picked a new target: Steve ...

DraftKings and FanDuel allowed to continue operating in New York
As daily fantasy sports websites DraftKings and FanDuel enter a protracted battle with the New York Attorney General regarding whether their ...

FBI pulls items from lake in San Bernardino terrorism investigation, source says
Los Angeles Times FBI pulls items from lake in San Bernardino terrorism investigation, source says Los Angeles Times FBI dive team search ...

Bryan Singer Breaks Down the ‘X-Men: Apocalypse’ Trailer
The X-Men: Apocalypse trailer hit the web today, and based on the 200 comments left on that post , it’s fair to say the response has been mixed ...

Dow, DuPont Deal Cements Activists' Rise
Wall Street Journal Dow, DuPont Deal Cements Activists' Rise Wall Street Journal Dow Chemical Co. DOW -2.80 % and DuPont Co. DD -5.51 % announced ...

Microsoft (Sort Of) Backtracks On Its Recent OneDrive Storage Changes
Last month Microsoft announced that due to abuse by certain users of their unlimited OneDrive storage plans, they will be axing that plan and ...

Resources last updated: 12/12/2015 3:38:58 AM