Hi, Since your coloumn is of data type varchar you don't ave a problem. SQL server has a function NewGUID() that generates a new and unique New Gloabally Unique...

Hi, deleting a row in User Table will leave any row using that UserID in organization_User Orphan ,you are violating Referential Integrity.The only way to avoid the error is to...

Hi, honestly speaking, I would rather like to have more expereince than fighting for the certificate.You don't need the certificate to do be a good DBA but then without the...

Using an Application role might be the best option, create an Application role for your custom application next let the role be dbo and then let your users access your...