SQL Server :: How To Remove Referential Integrity Rules
Oct 5, 2010
I am making a form that reads/writes to a table called Contract. Contract has a field called BuyerID, which is used to store the PK of a record in the Organization table, OrganizationID. When I first tried saving my form, I got the following exception:
The record can't be added or changed. Referential integrity rules require a related record in table 'Organization'. The transaction ended in the trigger. The batch has been aborted.
When I choose a value for the field that gets assigned to BuyerID, I don't get an exception. I don't want this field to be required, so I need to remove the referential integrity rule. I thought there must be a foreign key constraint specifying that BuyerID points to Organization.OrganizationID. However, running
[Code]....
shows that the only constraint for BuyerID is a default value of 0. how to remove the referential integrity rule?
I have checked Enforce Referential Integrity in my relationship section in my access database.By this way Can I delete child records when I delete the perent record?
I have a WCF service. For security reasons, I need to ensure that all 3 goals of security are attained (Privacy, Integrity and Authentication). We are planning to use x.509 certificate. My question is, Does just using x.509 certificate for message security ensure me of all 3 goals?
I am planning to set up the x.509 certificates as mentioned in following article
I'm getting the following error in my event log appears many times each hour, if somebody could shed some light it would be very nice... Also I am running server 2008 web server, this is NOT a webfarm.
I have a MVC project wich uses LINQ to SQL as a data layer.
For example, I have a tables ProductGroups and Products. Product is a child of ProductGroup, so to get name of ProductGroup, in aspx-page I use constuction like Model.ProductGroup.Name.
But when I delete a ProductGroup there is appear a NullReference Exception in presentation page.
While I was using just DataSet and manual SQL-queries, the rows, there was not every joined-element present, simple were not put in query result.
I know that before delete Parent row I have to delete all children rows, it's correct way.
1. Is there a way to ignore rows which has null-elements without manual checking through "IF"?
2. Is there simple way to delete all dependencies without manual enumerating every related tables?
I encrypt and decrypt a string with a private key and following functions. so I encrypt a string with Encrypt function and decrypt the encrypted string with decrypt function. If someone can change the encrypted string and then it decrypts with decrypt function, the decrypted string isn't equal to plain text before encrypting. I want to know how can I check is decrypted string equals to plain text before encrypting?
For the ASP.NET Menu Server Control whose RenderMode is set to "List", there is an "Orientation" property which decides whether the menu would render as a horizontal or a vertical menu. I have compared the two HTML source code and was unable to find out which part of the HTML/CSS code set the orientation of the menu(unordered list).
I'm using UrlRewriter.net, mentioned on ScottGu's Blog. I've built a site around this and now I'm having problems with subdirectories. The problem is, I want to exclude a directory and all subdirectories/files within it from rewriting. The rules I have are:
The problem is, although I can access files in the uploads directory (/Uploads/myfile.ext) and see the directory lists for direct subdirectories (/Uploads/mySubdirectory/), anything in /Uploads/mySubdirectory/, eg: /Uploads/mySubdirectory/myfile.ext returns a 404, because the UrlRewriter is messing with the Urls. I've tried these rules in different orders to no avail.Has anyone used this before? There must be a way to get it to work.
I have the following authorization rules in my web.config:
[code]....
Except for the path attribute these two rules are the same. Is there a way to combine these two rules into one like path = Register.aspx, ForgotCredentials.aspx.
To test I have been using "Administrators" which is a valid role so should allow me access and "TEST" which isnt. This works fine when using the above attribute however when I comment that out and use this in my Web.Config file:
I'm creating an ASP.NET control that outputs <object> and <embed> tags. I want the control to have "Height" and "Width" properties, since both of those tags require them. I was also thinking of validating the height and width at runtime. I'm wondering exactly what the valid ranges are so I can be sure I have valid sizes.
These are the types of height and width settings I've seen before. Are these all valid? Where could I find all the accepted formats? Are there any values that are considered invalid, but are used as tricks for cross-browser compatibility?
1px 10% 99.99% 100
I may just go the route of letting the user input whatever they want in these fields, but now I'm curious.
Experimenting with URL rewrites using this module, however I'm getting the following error when attempting to hit the URL. Looked online for answers, but not sure what the best way to get around this is...
HTTP Error 500.52 - URL Rewrite Module Error. Outbound rewrite rules cannot be applied when the content of the HTTP response is encoded ("gzip"). IIS received the request; however, an internal error occurred during the processing of the request. The root cause of this error depends on which module handles the request and what was happening in the worker process when this error occurred. IIS was not able to access the web.config file for the Web site or application. This can occur if the NTFS permissions are set incorrectly. IIS was not able to process configuration for the Web site or application. The authenticated user does not have permission to use this DLL. The request is mapped to a managed handler but the .NET Extensibility Feature is not installed.
I'm curious about the extent to which I should go to enforce business rules. I have validators on my pages and business rules in the middle tier. Should I also enforce business rules on the back end
I have a .net 4.0 web application hosted on IIS7 server.
After reading this: [URL] about serving static content from another server, so that cookies aren't sent with every request for a static file, i tried it out but without much success.
With this rule defined, every link to a file in the images folder should be rewriten into the static-server URL. But this doesn't work at all, now every image that is in the images folder returns a 404 not found. what could be causing this behavior or a different solution on how to serve files from a specific folder from a different server without having to go trough tons of code and change all the links to link to the static server?
I did also try using the Redirect action type instead of the Rewrite action, which actually worked, but it defies the reason why i'm trying to serve the files on a different server (this way the request is sent to my dynamic content server with all the required cookies and is redirected to the static-server which is actually worse than serving the images from the dynamic content server).
I can't for the life in me work out how to get the outbound rules to work. All my inbound are spot on (not included). I have dynamic and statis compression disabled, I moved the module up in the modules list just incase.The server is Windows 2008 R2 x64 if that makes a difference. Also not that the 'Content' pages get rewritten perfectly. I don't get it.
You can view the live site here: http://www.ink4u.co.uk
I have a column that i am wondering if there are some special rules enforced onit.. as soon as i send in a variable as an answer for the parameter in a stored procedure then my stored proc starts to filter an extra field....how can this be happening if the only difference is that i am passing in a parameter...(I am not even using this parameter!).
See below code "ViewEntry.aspx" in web config file i am using to display post of my blog in the same way i want to use one more page to display categories of my blog.
How to use multiple url in web config file inside the rewriter tag?
I Have many entries that have this 'HK' as a kind of prefix. in SQL Server table while i have nothing against HK, the sales person would like this HK removed. the name of this column is categoryname
i published my site to server and login users with session but this session remove after 30 seconds !!! and user page send error i used this code in web.config buy session remove again
