Viewing 15 posts - 38,296 through 38,310 (of 39,720 total)
February 12, 2002 at 10:47 am
Can you post more information. This doesn't really make sense. Version of SQL, what tasks? code for the tasks? etc.
Steve Jones
February 12, 2002 at 10:42 am
Not sure what you mean. What is a connectoid? Where is the data? In SQL Server?
Also, what version of SQL are you using?
Steve Jones
February 12, 2002 at 10:33 am
Haven't really developed any as of yet. Be interested to see what you come up with.
Steve Jones
February 12, 2002 at 10:31 am
You can also query information_schema.tables.
Ref:http://www.sqlservercentral.com/columnists/rsharma/informationschema.asp
Steve Jones
February 12, 2002 at 10:11 am
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
Viewing 15 posts - 38,296 through 38,310 (of 39,720 total)