August 22, 2005 at 2:06 am
Hi,
As testing on testing server i deleted a record from sysobjects.
I can see that table.
When sql server object table dont have record then how it is working.
Pls help in this regard.
From
Killer
August 22, 2005 at 2:10 am
Have you refreshed?
August 22, 2005 at 6:33 am
1 - Make sure you restart the server so that it can update itself.
2 - You just lost all support from Microsoft on that server.
3 - Make sure you have backups of all dbs!!!!!!!!
August 22, 2005 at 8:44 pm
Hi Remi,
Why to refresh or restart.As i know i had delated the record from the sysobject and when we execute anl dml command regarding table then it checks in the sysobjects.
It should give error when execute the select statement.
I refreshed the tables.
I know i will lost support from Microsoft Sql server that is why i am doing on testing server.
no backing of database on testing server.
from
killer
August 22, 2005 at 11:19 pm
"It should give error when execute the select statement."
What statement is that??
August 27, 2005 at 12:21 am
Hi Remi,
It does not show any error but the query keep onn execution .
I have to manually stop the process and it shows odbc error.
From
Killer
August 27, 2005 at 5:39 am
What statement are you executing????????????
August 27, 2005 at 3:17 pm
raj - you didn't delete one of the system tables, did you ?!
I just "experimented" by deleting a user table directly in sysobjects and it worked just fine!
as remi said - it would be interesting to see what statement you executed - pl. note that BOL has warnings everywhere about direct updates on system tables...
BOL:
"Updating, deleting, or inserting data in a system table can cause unpredictable effects in a SQL Server system. Such updates are not supported by Microsoft."
"Because system tables are critical to the operation of SQL Server, enable allow updates only in tightly controlled situations."
**ASCII stupid question, get a stupid ANSI !!!**
September 1, 2005 at 10:01 am
Hi Sushila,
I did not exceuted any megical statement just select * from tablename.
But still it did not get error my query just keep on executing.
from
killer
September 1, 2005 at 10:08 am
If the server is trying to select from a missing table that he thinks should be there >> that might cause some problems.
September 1, 2005 at 10:20 am
remi - that's the part i can't figure out...why the server still "thinks" that the table is there...i deleted & selected from sysobject w/out any problems...that's why i wanted to know if one of the system tables was deleted or whether it was an user table ?!?!
**ASCII stupid question, get a stupid ANSI !!!**
September 1, 2005 at 11:32 am
The server use cached data too. If you simply delete the tablename, the data may remain in ram and god knows in how many global variables to the server/em/qa. You want to drop a table >> DROP TABLE Tablename, that'll delete from sysobjects and everywhere else needed.
September 6, 2005 at 1:04 am
Hi Sushila ,
If u read my question then u will not find anything that i had written that i had deleted a system table.
Why u want to give another turn to the question.
Thanx Rgr'us u are right as i restarted the server it gave me error that table does not exists.
than
from
killer
September 6, 2005 at 6:07 am
Raj - nothing in the posts say that you did not delete a system table...I was not giving any other turn to your question except trying to get some information...
however, I do apologise for trying to respond to this post and you have my assurance that from now on I'll make sure our paths do not cross again!
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply