Drop Table

[IPconfig]

hey guys....

got a slight problem here on my sql server, i am trying to drop a table but my server just freezes, this also happens when i try to delete from table, my table is about 85912 rows and 32 columns, i have tried using the enterprise manager and command line but all isnt working ..i tried to truncate the table but i still get the same count when i issue a select count(*) statement. I have also failed to rename the table, all the permissions are fine but the table has failed to get deleted. All i want to do is just remove the table from the system...i have duplicated the table but that Application i am running cant look at the new created table unless i rename it to match the old table.
anyone got any clues/tricks of how i can sort this out.

cheers

IP

 

[QatQat]

I had the same problem once and it was the fixed size I set for the main log file. check if your log file can grow with norestrictions.

I hope it helps


Bye


Qatqat

 

[JamesLean]

You could also check there are no views that use the table that were created with the WITH SCHEMABINDING option.
Also are there other tables that have foreign key references to this table?

I would imagine you would get specific error messages if either of these were the case but may be worth checking anyway.

 

[IPconfig]

question-1: how can i check if my log can grown with norestrictions???

question-2: what would cause the table not to be able to be renamed, i made sure i stopped all the services that where using the application.

am not really a hardcore ms-sql guy ..use alot of Unix stuff..so i will need some verbose explanations to a couple of these issues...all help highly appreciated..!!

cheers

IP

 

[QatQat]

1) To check if your log con grow open eneterprise manager, go on your database properties and click on the transaction log tab. The maximum size option should be set to 'unrestricted'.
CHeck also your recovery level on the option tab. If set to full then even when you rename a table it should log any effect on teh rest of the database. This should answer your second question


Bye


Qatqat