Viewing 15 posts - 37,351 through 37,365 (of 39,456 total)
Also, there are a few good articles on this site. Click "search" and enter encryption.
Steve Jones
June 19, 2002 at 5:24 pm
There is a check box on th Tranform Data Task (Assuming you used this) that specifies the load size of the transaction. Set it to 1 and see if this...
June 19, 2002 at 5:07 pm
Good advice from Antares. My personal list:
At least 3 physical Arrays (not drives)
: RAID 1 - OS and SQL
: RAID 1 - Logs
...
June 19, 2002 at 4:53 pm
Books On Line has some good information on each of these. I'd read about it there.
Steve Jones
June 19, 2002 at 4:48 pm
You are welcome. Glad it helped and it's the simplest way to do this. You can even use the Dynamic Properties task to "change" the statement based on some other...
June 19, 2002 at 4:47 pm
You would need to build your own algorithm to encrypt/decrypt. I would store the key in a table (lock this down) and use a UDF to perform the encryption.
Steve Jones
June 19, 2002 at 4:45 pm
Is it a large result set? If so, the rendering may be longer in ASP. Also, did you run your VB app from the web server?
Steve Jones
June 19, 2002 at 3:05 pm
I would use the ExecuteSQL task, but if you use Active X, you would essentially use an ADODB Command object and a RECORDSet object and submit the SQL needed. You...
June 19, 2002 at 3:03 pm
Is this 2000 or 7? Any other issues? Also, what version of client tools to you have?
Steve Jones
June 19, 2002 at 11:51 am
You can do this, but the information has potentially been comprimised by transitting the wire unencrypted.
You would set the trigger to update the column with the envrypted value using some...
June 19, 2002 at 11:50 am
Agree with Antares. The server load will vary and it is possible this report is right near the timeout window. No load may run ( or if data cached) and...
June 18, 2002 at 4:41 pm
Extents are fixed sizes. The data gets fragmented when the extents used for a table are not physically near each other. Rebuilding the clsutered index will reorganize these.
Steve Jones
June 18, 2002 at 2:50 pm
Extents are fixed sizes. The data gets fragmented when the extents used for a table are not physically near each other. Rebuilding the clsutered index will reorganize these.
Steve Jones
June 18, 2002 at 2:50 pm
June 18, 2002 at 2:49 pm
Agree with above. Best to try and "rethink" the problem as a positive rather than a negative.
Steve Jones
June 18, 2002 at 1:26 pm
Viewing 15 posts - 37,351 through 37,365 (of 39,456 total)