User profile for Neil Davidson

Keith, I apologise for the time it's taken to sort this out. We're going to work on a patch to add an 'Ignore users' option so we can get this working. This will take a few days. In the short term, there are a couple of options: 1) You could set the options to ignore all permissions 2) You could remove the ASPNET and KBARROWS users' permissions and set up an ASP and MYUSERS groups, add the users to those groups, and then set the permissions for those groups. You will still need to edit the script, but only 1 line. The second option is probably the best - it will make it a lot easier in the future for you. - Neil / comments

Keith, I apologise for the time it's taken to sort this out. We're going to work on a patch to add an 'Ignore users' option so we can get this working. This will take a few days. In the short term,...

0 votes

We're hoping for some time next week or so. Out of interest, where did you read that DBCC TRACEON(3604) causes problems? It should only change an informational setting for the current connection. It shouldn't cause performance issues / crash the server. / comments

We're hoping for some time next week or so. Out of interest, where did you read that DBCC TRACEON(3604) causes problems? It should only change an informational setting for the current connection. I...

0 votes

Toby, It could well be sysdepends - it's notoriously unreliable. I'm not sure of any utilities to rebuild it - maybe try google groups? Is the foreign key error the first error that occurs when you run the scripts, or are there errors previous to that? - Neil "Toby Harman" <toby.harman@morningstar.com.au> wrote in message news:hkv3aA$SDHA.2424@server53... > Hi Neil > > Yes - The whole database is selected. and Yes, using the ! button to create > the script. > > The problem may be more in the area of the sysdepends table. I am not > convinced that this is adequately maintained. Are you aware of any utilities > to rebuild sysdepends? > > Also - The script will run if I partition it up I am not sure if the problem > is related to the script of a server setting on SQL which is not committing > the transactions as it should. > > Toby > > "Neil Davidson" <neil.davidson@red-gate.com> wrote in message > news:shj91UJRDHA.1456@server53... > > Toby, > > > > Are you generating the scripts from the ! toolbar icon? Also, have you > tried > > selecting the table that the foreign key references to include that in the > > script as well? > > > > Yours, > > > > Neil Davidson > > "Toby Harman" <toby.harman@morningstar.com.au> wrote in message > > news:rCPumucQDHA.1908@server53... > > > Forgot to mention - Red-Gate SQL-Compare 2.03 - Trial Version! > > > > > > "Toby Harman" <toby.harman@morningstar.com.au> wrote in message > > > news:qe9M53QQDHA.1156@server53... > > > > Hi All > > > > > > > > First - Congrats to Red-Gate and the developers for developing a > > seriously > > > > useful tool. > > > > > > > > Now - I have a small problem! > > > > > > > > It would appear that the script (which I accept will only be 95% > > > successful) > > > > has a small problem. > > > > > > > > If there are two databases which contain the same table and a new > column > > > is > > > > added to a table in one database it doesn't handle Foreign Keys very > > well. > > > > They don't appear to be dropped before the new table is created, and > > thus > > > > the old table cannot be dropped and the new table cannot be renamed > into > > > > place. > > > > > > > > Is this a known bug or am I doing something wrong? > > > > > > > > Thanks > > > > > > > > Toby > > > > > > > > > > > > > > > > > > > > / comments

Toby, It could well be sysdepends - it's notoriously unreliable. I'm not sure of any utilities to rebuild it - maybe try google groups? Is the foreign key error the first error that occurs when you...

0 votes

Can you confirm that the tables have a primary key / unique index on them? SQL Data Compare requires one of these to work. - Neil / comments

Can you confirm that the tables have a primary key / unique index on them? SQL Data Compare requires one of these to work. - Neil

0 votes

Vince, I have e-mailed you separately about this. - Neil / comments

Vince, I have e-mailed you separately about this. - Neil

0 votes

Can you specify a DEFAULT value for those columns? / comments

Can you specify a DEFAULT value for those columns?

0 votes

Sorry, I'm not aware of any product for Access. / comments

Sorry, I'm not aware of any product for Access.