Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
Trying to export a database as a Data-Tier Application with SEO Checker installed (1.6.1) results in the following error message. Problem stems from SEOChecker_Robots not having a clustered index (possibly other tables as well):
TITLE: Microsoft SQL Server Management Studio------------------------------
One or more unsupported elements were found in the schema used as part of a data package.Error SQL71564: Table Table: [dbo].[SEOChecker_Robots] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server. (Microsoft.SqlServer.Dac)
They didn't teach me anything about Clusterd Indexes at DBA School ;-) Is it a Azure special thing?
This is just on local SQL2012 server - although I will eventually be exporting this to Data-Tier with the aim of importing it to Azure...
The table in question has no indexes whatsoever - are the NodeId and UserAgent fields unique in each record?
Will add it to the list of things to fix
excellent... If you want to provide an sql patch script I volunteer to test it for you :)
Cool, first need to know what is exactly wrong since scripts got generated from sql server criate table dialog...
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted