Viewing 15 posts - 76 through 90 (of 161 total)
If there is only 1 front end application doing all of the inserts and deletes, there is no reason to force FK type constraints.
Actually, I'll disagree with you on this....
November 21, 2007 at 11:36 pm
Actually, I am finding something interesting about this whole discussion: the apparently large number of people who take my attitude of "appropriate" foreign keys to mean "no" foreign keys. ("screaming...
November 21, 2007 at 6:42 pm
The user gets an error message and has to deal with that when all he wants to do is enter the %^&! information so he can get his job done!...
November 20, 2007 at 12:40 pm
'm not disputing the identity management problem. What I'm saying is you have tools to attack one side of it, which is duplicate data that truly is duplicate.
Very true -...
November 20, 2007 at 9:30 am
And one place it can be helpful is if you have a system where you enter in an address. The system auto looks up using Full Text or some type...
November 19, 2007 at 1:32 pm
I respectfully disagree. (et. al.)
Y'all are certainly welcome to. And, as long as you're working in a nice, sterile environment, you'll have a lot of success. But, let's take a...
November 16, 2007 at 4:29 pm
I'll have to disagree here. I think that database design is black and white. There is an correct way to design proper, normalized relational data structures. You may at some...
November 16, 2007 at 1:01 pm
Personally I prefer to script these sorts of commands, because I keep the scripts as a log of the changes I've made to the database. Do it through the GUI...
October 23, 2007 at 1:34 pm
First, I'd recommend not doing this if you are worried about access by individuals that, while technically are "authorized", but actually have no business in the database. Given that you...
September 25, 2007 at 3:19 pm
Have you looked into security issues? Running it "outside of your program" it may work because you're running it "as yourself" - while inside the program you may actually be...
September 25, 2007 at 3:08 pm
I think everyone here is using the term "snapshot" in the colloquial sense (that is a backup of production) rather than anything else.
Steve G.
September 17, 2007 at 1:39 pm
Re-read what Jeff M. said: Make a snapshot of production and turn that over to the developers. This should give them a good platform for debugging / seeing how things...
September 14, 2007 at 3:07 pm
Check out "sp_change_users_login" (at least, that's what it was called in SQL2K - it probably has the same name in SQL2005). What's happening is that both the master database and...
September 13, 2007 at 11:46 am
Does the userid 'malinowm2' have database owner permissions on the database? This could be automatically mapping you to 'dbo'.
Steve G.
September 4, 2007 at 2:24 pm
It looks like you're trying to use a standard (uid & password) rather than a trusted connection to access the database. Try using this pattern for your connection string:
Driver={SQL Native...
September 4, 2007 at 2:11 pm
Viewing 15 posts - 76 through 90 (of 161 total)