title: How can I continue past an error in a SQL script to execute other statements in the batch?
body: <p>I am using the New Query window in Visual Studio 2012 Server Explorer. Here
  is the script I am trying to execute:</p>
  
  <pre><code>ALTER TABLE [dbo].[webpages_UsersInRoles] DROP CONSTRAINT fk_UserId;
  ALTER TABLE [dbo].[webpages_UsersInRoles] DROP CONSTRAINT fk_RoleId;
  
  DROP TABLE [dbo].[ExtraUserInformation];
  DROP TABLE [dbo].[UserProfile];
  DROP TABLE [dbo].[webpages_Membership];
  DROP TABLE [dbo].[webpages_OAuthMembership];
  DROP TABLE [dbo].[webpages_Roles];
  DROP TABLE [dbo].[webpages_UsersInRoles];
  
  CREATE TABLE [dbo].[ExtraUserInformation] (
      [Id]       INT            IDENTITY (1, 1) NOT NULL,
      [UserId]   INT            NOT NULL,
      [FullName] NVARCHAR (MAX) NULL,
      [Link]     NVARCHAR (MAX) NULL,
      [Verified] BIT            NULL,
      CONSTRAINT [PK_dbo.ExtraUserInformation] PRIMARY KEY CLUSTERED ([Id] ASC)
  );
  </code></pre>
  
  <p>There is currently no webpages_UsersInRoles table and it gives me an error
  message saying:</p>
  
  <pre><code>Msg 4902, Level 16, State 1, Line 5
  Cannot find the object "dbo.webpages_UsersInRoles" because it does not exist or you do not have permissions.
  </code></pre>
  
  <p>After this message the script seems to stop and it fails to create the other tables after this. Is there away that I can make the script continue after it passed the expected error?</p>