TSD7025: Unable to identify the schema type contained in the .sql file. A schema type of 'Certi

I have a file ending in cert.sql and it contains a valid CREATE CERTIFICATE statement:

CREATECERTIFICATE [xxxx]
AUTHORIZATION[dbo]
WITHSUBJECT =xxxx,
START_DATE =
'2007-01-01T00:00:00',
EXPIRY_DATE =
'2020-01-01T00:00:00'
ACTIVEFORBEGIN_DIALOG =ON

Even though, I get the following error during build:

Error 1 TSD7025: Unable to identify the schema type contained in the .sql file. A schema type of 'Certificate' was expected, based on the name of the .sql file. ....WZBLMessenger.Client.Service.Cert.sql

Can someone tell me what kind of schema/statement is expected?

[1394 byte] By [TilfriedWeissenberger] at [2007-12-29]
# 1
Ok, it looks like in a previous CTP Certificates were supported as objects, this is no longer the case. In order to get your certificate into the build script you should add it to your pre-deployment scripts. There is a specific pre-deployment script in there for Certificates, EncryptionKeysAndCertificates.sql. Now, If you didnt import your schema from an existing Database, the include for the EncryptionKeysAndCertificates.sql file wont be in the Script.PreDeployment.sql script, so just add :r .\EncryptionKeysAndCertificates.sql to Script.PreDeployment.sql. and you should be good. Also note that your subject value needs single quotes around it.
# 2

thanks!

that's the way I'm doing it now. I was just stunned that BUILD actually recognized the .cert.sql extension. The subject did have single-quotes around it, I just forgot them on replacing with xxx.

TilfriedWeissenberger at 2007-9-4 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...

Visual Studio Team System

Site Classified