Thanks @Phil

I've just looked and foreign keys are set to TRUE which is odd.

I'll keep an eye on it and see if it happens again.

I'll also go through the other...

I've only seen it when using the designer.

Can you point in the direction of the specific (if there is one) default that needs changing to stop this happening?

I've had a...

On a slightly different (but possibly connected) note.  When I use Table Designer in SSMS, why do I appear to lose foreign key references?

We've got some code that flags any...

Well folks, I didn't expect this one to get as much attention as it did.

I'm now thinking reorganising the columns is going to e bad idea (as far as the...

Thanks for that.   We use synonyms to refer to other databases so hopefully that shouldn't cause too many issues.

I'll give it a go with a test database and see how...

@Phil - we haven't yet but we're working on that bit.  It would still be painful, but not as bad as creating all the tables by hand, etc

Thanks @ant-green - looks like that's not happening then (can't justify the time to get it done).

@ant-green - it was a request from the customer (to make the fields easier to find).  If it was simple, then I'd go ahead and do it.

If it's going to...

Thanks Grant - I'll have a look at those.

We currently use SQL Clone to create our development databases so was just wondering if I could get the branch to point...

Thanks Steve - that worked (I was initialising the repo when I didn't need to)

Another (hopefully easy) question, is it possible to have the branch point the database to a...

@steve-2 - When I do the initial bits to get the stored procedures, etc into VS, there is no git subfolder in the project folder.  It appears to...

• This reply was modified 1 year, 4 months ago by  richardmgreen1. Reason: Spelling/typos

Hi both

Thanks for the responses.

@winston - I've attached the screenshot as requested

@both - I don't get the option to do a pull first (unless I'm doing something wrong).

I'm following the...

• This reply was modified 1 year, 4 months ago by  richardmgreen1. Reason: Spelling

Hi @phil - We can ucomments in the code but users won't be able to see that bit.

When you use a built-in function, you get that little yellow popup box...

Thanks Grant

Just as an update.....

On a whim (and because it's a database I don't care about) I did a PULL/APPLY CHANGES request in SSMS to get the changes from Branch1...

Steps taken so far:-

Create brand new database RG_Test

Create new project in Azure (also called RG_Test)

Use Git Bash to clone project repository (Azure) to local repository

Connect RG_Test to local repository and...