whateveragain
Programmer
What reasons are there for a table not being dropped? I tried the following 3 ways and none of them work. If I run the SP outside the app, it works. The SP is being called and run because I created a junk table within the SP to see if it were being entered. None of these tables are being used in an ASP.net form.
1. DROP Table Mytbl1
2. IF EXISTS (SELECT * from sysobjects
WHERE id = object_id(N'[yeldata].[dbo].[Mytbl]') AND
OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP Table [yeldata].[dbo].[Mytbl1]
3. IF EXISTS (SELECT * from sysobjects
WHERE id = object_id(N'[yeldata].[dbo].[Mytbl1]') AND
OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP Table Mytbl1
1. DROP Table Mytbl1
2. IF EXISTS (SELECT * from sysobjects
WHERE id = object_id(N'[yeldata].[dbo].[Mytbl]') AND
OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP Table [yeldata].[dbo].[Mytbl1]
3. IF EXISTS (SELECT * from sysobjects
WHERE id = object_id(N'[yeldata].[dbo].[Mytbl1]') AND
OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP Table Mytbl1