Installation and deployment
Version 7.x > Installation and deployment > Cannot install the database on application deployed on Windows Azure View modes: 
User avatar
Member
Member
Pavel.Zazula-soft-fx - 3/6/2013 7:40:40 AM
   
Cannot install the database on application deployed on Windows Azure
ERROR: An error occurred: [DataConnection.HandleError]: Query: CREATE TABLE [CMS_Avatar] ( [AvatarID] [int] IDENTITY(1, 1) NOT NULL, [AvatarName] [nvarchar](200) NULL, [AvatarFileName] [nvarchar](200) NOT NULL, [AvatarFileExtension] [nvarchar](10) NOT NULL, [AvatarBinary] [varbinary](max) NULL, [AvatarType] [nvarchar](50) NOT NULL, [AvatarIsCustom] [bit] NOT NULL, [AvatarGUID] [uniqueidentifier] NOT NULL, [AvatarLastModified] [datetime] NOT NULL, [AvatarMimeType] [nvarchar](100) NOT NULL, [AvatarFileSize] [int] NOT NULL, [AvatarImageHeight] [int] NULL, [AvatarImageWidth] [int] NULL, [DefaultMaleUserAvatar] [bit] NULL, [DefaultFemaleUserAvatar] [bit] NULL, [DefaultGroupAvatar] [bit] NULL, [DefaultUserAvatar] [bit] NULL ) ALTER TABLE [CMS_Avatar] ADD CONSTRAINT [PK_CMS_Avatar] PRIMARY KEY NONCLUSTERED ([AvatarID]) WITH FILLFACTOR=80 ALTER TABLE [CMS_Avatar] ADD CONSTRAINT [DEFAULT_CMS_Avatar_DefaultFemaleUserAvatar] DEFAULT ((0)) FOR [DefaultFemaleUserAvatar] ALTER TABLE [CMS_Avatar] ADD CONSTRAINT [DEFAULT_CMS_Avatar_DefaultGroupAvatar] DEFAULT ((0)) FOR [DefaultGroupAvatar] ALTER TABLE [CMS_Avatar] ADD CONSTRAINT [DEFAULT_CMS_Avatar_DefaultMaleUserAvatar] DEFAULT ((0)) FOR [DefaultMaleUserAvatar] ALTER TABLE [CMS_Avatar] ADD CONSTRAINT [DEFAULT_CMS_Avatar_DefaultUserAvatar] DEFAULT ((0)) FOR [DefaultUserAvatar] CREATE NONCLUSTERED INDEX [IX_CMS_Avatar_AvatarGUID] ON [CMS_Avatar] ([AvatarGUID]) WITH ( FILLFACTOR = 80) CREATE CLUSTERED INDEX [IX_CMS_Avatar_AvatarName] ON [CMS_Avatar] ([AvatarName]) WITH ( FILLFACTOR = 80) CREATE NONCLUSTERED INDEX [IX_CMS_Avatar_AvatarType_AvatarIsCustom] ON [CMS_Avatar] ([AvatarType], [AvatarIsCustom]) WITH ( FILLFACTOR = 80) : caused exception: Keyword or statement option 'fillfactor' is not supported in this version of SQL Server.

User avatar
Kentico Customer Success
Kentico Customer Success
kentico_martind2 - 3/12/2013 5:50:50 AM
   
RE:Cannot install the database on application deployed on Windows Azure
Update:

A whole issue was around SQL Server 2012 on the pay-as-you-go cloud hosting. It doesn't support all command from SQL script.