Msg 3726, Level 16, State 1, Line 3
Could not drop object 'dbo.tblMemberMain' because it is referenced by a FOREIGN KEY constraint.
There is a foreign key referenced to this table, so check the dependencies and drop the foreign key before droppping the table. In your script I have not seen you dropping the foregin key for this.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'tblMemberMain' in the database.
obviously because of the above error.
Cannot find the object "dbo.tblMembershipOrders" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Are you sure that you have this object?
SELECT * FROM sys.objects
WHERE name ='dbo.tblMembershipOrders'
Cannot find the object "dbo.tblTpsSites" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "dbo.tblVisaTask" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "dbo.tblVisaTask" because it does not exist or you do not have permissions.
Msg 3726, Level 16, State 1, Line 3
Same with these ones? Can you cross check them. In your
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblMembershipOrders]') AND type in (N'U'))
DROP TABLE [dbo].[tblMembershipOrders]
GO
You are trying to drop an object that does not exist. Level 16 message, that's what it means. Can you exclude this and try to create it may be?
If my user has sysadmin privileges, do I need to specify myself as dbowner for that database? I had assumed not.
By default sysdmin is considered to be a dbo.