Ch 19 Deploying

AlanWheeler · February 27th, 2014, 02:21 PM

Hi Imar,

I am having success deploying databases, but I keep getting a string of errors from the remote SQL server when I run my SQL scripts. The tables are created and the data loads, but I don't like seeing an error listing. Here is the list of errors I get:

Code:

Msg 15247, Level 16, State 1, Line 1
User does not have permission to perform this action.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 15247, Level 16, State 11, Line 1
User does not have permission to perform this action.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 15247, Level 16, State 1, Line 1
User does not have permission to perform this action.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

It seems like this error list is telling me that all the errors are associated with the first command, so I removed that line and it's associated Go command, but then I get another set of errors that say the same thing.

It keeps saying Line 1, but then it gives the same errors 3 times all against Line 1. I would have thought there would be an error listed for each line that is not accepted so one could examine all lines to remove.

I did edit out the CREATE DATABASE line because with my hosting service I create the database through their front end. Again, when I run the script against that database everything turns out OK. I just don't like the errors. Do we just ignore errors in SQL? It seems to me that ignoring error reports is at one's own peril.

I wondered if could comment on this.

Best Regards,
Alan

Imar · February 27th, 2014, 03:57 PM

Ignoring errors is a bad idea as your database may be in an unknown state.

What code is causing the errors?

Imar

AlanWheeler · February 27th, 2014, 04:18 PM

These are the first few lines of the SQL script file that caused the errors listed above:

Code:

ALTER DATABASE [Canvas] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [Canvas] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [Canvas] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [Canvas] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [Canvas] SET ARITHABORT OFF 
GO

The following lines are lines that I deleted before using the script that starts above:

Code:

CREATE DATABASE [C:\BEGASPNET\CANVASPROJECT1\APP_DATA\CANVAS1.MDF]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'Canvas1', FILENAME = N'C:\BegASPNET\CanvasProject1\App_Data\Canvas1.mdf' , SIZE = 4096KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'Canvas1_log', FILENAME = N'C:\BegASPNET\CanvasProject1\App_Data\Canvas1_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [C:\BEGASPNET\CANVASPROJECT1\APP_DATA\CANVAS1.MDF] SET COMPATIBILITY_LEVEL = 110
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [C:\BEGASPNET\CANVASPROJECT1\APP_DATA\CANVAS1.MDF].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO

Best Regards,
Alan

Imar · March 5th, 2014, 06:59 AM

You don't need all this. This sets some defaults for the newly created database, but your host typically has done that already, and doesn't allow you to change it.

Cheers,

Imar