Viewing 15 posts - 38,071 through 38,085 (of 39,490 total)
Antares686 has a good suggestion, but you can just apply multiple UPDATE clauses using the WHERE clause for each case. This might help.
Alternatively, you can use a second column that...
February 12, 2002 at 10:07 am
It's not a total waste, and I agree with Andy. Obfuscation does help. Lots of people are lazy and won't keep trying if the easy thing doesn't work.
However, keep in...
February 12, 2002 at 10:03 am
Is this a production site or dev site? If it's production and the db changes, why not get some log backups? Even in Dev, we've started some log backups. Once...
February 12, 2002 at 10:00 am
good advice above. One side note, I had a freind that had some issues when fully populating a motherboard with an AMD processor. Probably not applicable to this site as...
February 12, 2002 at 9:55 am
No, you just choose a group instead of a person when adding an NT Auth login.
Steve Jones
February 12, 2002 at 9:37 am
February 11, 2002 at 5:40 pm
That's a great technique. I did something similar years back with VFP for states and countries (which rarely change). I like flat files for lots of things because there isn't...
February 8, 2002 at 4:53 pm
create trigger MyTrigger for update
as
insert into historytable (fieldA, fieldB)
select FieldA, FieldB
from inserted
return
Steve Jones
February 8, 2002 at 4:42 pm
There are any number of ways to do this, but the bottom line is that there are numerous ways to decrypt stored procedures. A quick search on google will have...
February 8, 2002 at 3:17 pm
February 8, 2002 at 11:06 am
There are some good points of view on Slashdot this week. and one from Bill Joy as well as some discussion from the guy who is porting to Linux.
Steve Jones
February 8, 2002 at 11:02 am
clarification:
How to Buy
Multiple Instances
Licensing SQL Server 2000 Enterprise Edition enables customers to run multiple instances on a single server or processor and only...
February 8, 2002 at 11:01 am
Isn't app center supposed to replicate the info from one server to another? Not sure if this handles the stateless/stateful thing, but it adds overhead. I am for using either...
February 8, 2002 at 10:58 am
February 8, 2002 at 10:57 am
Viewing 15 posts - 38,071 through 38,085 (of 39,490 total)