Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-08 : 08:47:22
|
| Mariana Luna writes "I can delete the record in a database then that is causing problems becasue I try to delete this table and I can do that,What can I do?, Because I can make the close day in accounting." |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-07-08 : 09:14:00
|
| We're all happy for you Mariana. The fact that someone reveils this highly secret function of SQL server is woth an answer.You managed to delete a record and so solving the problem.Some people should really read other books than BOL.Have a nice day! |
 |
|
|
MakeYourDaddyProud
184 Posts |
Posted - 2002-07-08 : 10:25:45
|
| Way to go Mariana!Daniel Small MIAPwww.danielsmall.com IT Factoring |
|
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-07-08 : 12:39:24
|
| Mariana, while I doubt I will be able to provide a response as constructive as rihardh I'll give it a shot...Your exact problem is hard to ascertain from your post. What exactly are you trying to do, drop (delete) a table from the database or just a specific row?Is there a specific error message you are getting? This will go a long way in helping us help you.If you are having problems deleting a table due to a record then it sounds like you have declarative referential integrity (DRI) enabled. DRI would prevent you from deleting a table so you do not end up with orphan records in a related table. Does this sound like your situation?Without knowing specifics we are going to need more info to help you out.Justin |
|
|
|
|
|
|
I can delete a record