SQL Server 2005 Dependancy question...


Author
Message
StarkMike
StarkMike
Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)
Group: Forum Members
Posts: 436, Visits: 944
I'm trying to delete a table in sql server and it tells me that there are stored procedures and views that depend on this table and therefore i cannot delete it. I've looked into a few of these stored procedures and its not using the table. So why does it keep telling me there is a dependency?



Any adivce?



Thanks.
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
More than likely there is still something that is referencing the table.  This message is accurate as I have run into it myself many times Smile.  The one things SQL Server Management Studio (and SQL Server at large for that matter) does is require the contraints and dependencies to be addressed before removing an element.  Have you verified that there is not a view that uses this table?  Are you possibly overlooking a stored proc?
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search