User profile for eaguilar106

BTW, I'm using SQL Server 2012 Enterprise / comments

BTW, I'm using SQL Server 2012 Enterprise

0 votes

Sure! See below... /* First make sure FileStream is enabled on the server instance. You do this through SQL Server Configuration Manager - see books online. Not hard. Next, create a new directory 'C:\FileTablesDemo' for the database filesExecute this script a section at a time, do not just run it. */ use master EXEC sp_configure filestream_access_level, 2 RECONFIGURE Go -- if you get an error then FileStream is not enabled. See first note. 　 CREATE DATABASE RedGateFS ON PRIMARY (NAME = RedGateFS_data, FILENAME = 'C:\FileTablesDemo\RedGateFS.mdf'), FILEGROUP RedGateFSFSGroup CONTAINS FILESTREAM (NAME = RedGateFS_FS, FILENAME = 'C:\FileTablesDemo\RedGateFSFileStream') LOG ON (NAME = 'RedGateFS_log', FILENAME = 'C:\FileTablesDemo\RedGateFS_log.ldf'); GO ALTER DATABASE RedGateFS SET FILESTREAM (NON_TRANSACTED_ACCESS = FULL, DIRECTORY_NAME = N'RedGateFSDataFS') Use RedGateFS Go CREATE TABLE Docs AS FileTable GO --Create Full-Text Catalog Create FullText Catalog RGFullTextCatalog as Default GO -- get the PK DECLARE PK VARCHAR(50) SET PK = ( SELECT OBJECT_NAME(object_id) AS constraints FROM sys.filetable_system_defined_objects WHERE OBJECT_NAME(object_id) like ('PK%')); SELECT PK -- copy this, should look similar to PK__Docs__5A5B77D59C913F2B, paste in next section --Create FullText Index Create FullText Index on dbo.Docs (name Language 1033, File_stream type column file_type Language 1033) key Index PK__Docs__5A5B77D5D74C9885 -- REPLACE THIS WITH THE ONE YOU JUST COPIED on RGFullTextCatalog with Change_Tracking Auto, StopList=system Go /* Now, add this database to source control, in my case TFS on VSTS (devops) Link - no problem, there should be two objects - Docs and the RGFullTextCatalog Commit - looks ok until the end, then you should get the error... "Fulltext index references unknown key index PK__Docs__5A5B77D5D74C9885." Your PK in the error will be different than mine but notice its the same PK that you copied, so it exists. Thanks for you attention to this, let me know if I can provide any other info. */ / comments

Sure! See below.../* First make sure FileStream is enabled on the server instance. You do this through SQL Server Configuration Manager - see books online. Not hard. Next, create a new directory 'C...

0 votes

Yes, I have unlinked and relinked several times trying different options to no avail. I also created a new database with a single filetable with a full text index and NOTHING else and tried linking to a new azure devops account with TFS as the source control and I get the same error. I don't think redgate likes filetables. Any help or workaround would be greatly appreciated. Thank you. / comments

Yes, I have unlinked and relinked several times trying different options to no avail. I also created a new database with a single filetable with a full text index and NOTHING else and tried linking...

0 votes

How can we help you today?

eaguilar106

Comments