Activity overview
Latest activity by ooasidnfoisnf
@Alex B -- drop database foo create database foo go use foo -- link to source control create table dbo.users ( username varchar(200) , mytext varchar(max), age int, primary key(username) ) create view userview as select username, mytext, age from users create fulltext catalog userfulltextcatalog -- commit alter view userview with schemabinding as select username, mytext, age from dbo.users CREATE UNIQUE CLUSTERED INDEX uniq_userview ON userview(username) create fulltext index on userview (mytext) key index uniq_userview on userfulltextcatalog --- commit drop fulltext index on userview -- commit -- goes in to strange state here this results in to state where on commit tab it still shows there being fulltext index on the view in the version control / comments
@Alex B -- drop database foocreate database foogouse foo-- link to source controlcreate table dbo.users ( username varchar(200) , mytext varchar(max), age int, primary key(username))create view use...
Yes, committed everything redgate thought was uncommitted every time. Including the fulltext catalog. / comments
Yes, committed everything redgate thought was uncommitted every time. Including the fulltext catalog.
@Alex B tfs in azure dev ops each developer with his own database instance database default collation is Finnish_Swedish_CI_AS if it has any difference. I could maybe share the test directory i created with above steps? / comments
@Alex B tfs in azure dev opseach developer with his own database instancedatabase default collation is Finnish_Swedish_CI_AS if it has any difference. I could maybe share the test directory i crea...
Well, I got quite different kind of error this time. Created a simple table with two columns... Created a new view through sql server management studio. Committed these to source control modified view through alter script to include 'with schemabinding' committed to source control added unique index on view added full text index on the view committed to source control now through sql managet studio removed full text index from view through right click context menu Committed. Somehow it didn't throw error, however, attached file shows the state. It didn't actually manage remove the fulltext index. Next commit attempt will throw following error: CheckIn returned with ChangeSet ID=0, nothing to Check in? Didn't expect 0 actual 0 / comments
Well, I got quite different kind of error this time. Created a simple table with two columns...Created a new view through sql server management studio.Committed these to source controlmodified view...
Thanks for the reply, We have sql server 2016 64bit, version 13.0.5026.0 specifically SQL source control 7.0.31.9527 I'll try test if this issue replicates easily from empty database first. / comments
Thanks for the reply,We have sql server 2016 64bit, version 13.0.5026.0 specificallySQL source control 7.0.31.9527I'll try test if this issue replicates easily from empty database first.
Removing schemabound views with fulltext indexes
We have a view with schemabind and a fulltext index over this view committed. It has proven to be a bit flunky with redgate overall, but especially now when we are trying to remove it from from sou...