Viewing 15 posts - 37,111 through 37,125 (of 39,769 total)
not really. Can you post some DDL and sample data?
Steve Jones
September 18, 2002 at 2:38 pm
You can limit profiler to queries with some long time (> 2 minutes or something) which will make it easier to track them down.
Steve Jones
September 18, 2002 at 2:34 pm
The code is more a client issue. Add a binary column to the table and insert the word document into that. Sending it to the stored procedure will take a...
September 18, 2002 at 1:28 pm
Not sure BCP is much faster or it's worth testing. If are are archiving, this is a one time event, correct? Does the time matter that much?
Steve Jones
September 18, 2002 at 1:21 pm
Haven't quanitified it. Not sure it is significant, but I could be wrong.
Steve Jones
September 18, 2002 at 1:14 pm
Nothing easier. Need to include the columns.
Steve Jones
September 17, 2002 at 2:35 pm
What is the package? Haven't heard of anything like this.
Steve Jones
September 17, 2002 at 2:34 pm
create trigger mytrigger for update on Mytable as
if update (columnA)
begin
update TableB
set x = y
...
September 17, 2002 at 2:24 pm
Yes there are one way hashes. MD5 is well known and here are some implementaitons. No SQL yet
http://userpages.umbc.edu/~mabzug1/cs/md5/md5.html
Steve Jones
September 17, 2002 at 2:20 pm
Haven't seen this.
Have had some issues with BMC Patrol and it reporting sysadmin problems when the account is a system admin. No resolution as of yet.
Steve Jones
September 17, 2002 at 2:18 pm
Also check the Event Viewer for the server.
Steve Jones
September 17, 2002 at 2:16 pm
What type of information do you need? Usually diagrams are better for showing relationships.
With Visio you can reverse engineer and then add labels. Helps to have a plotter to use.
Steve...
September 17, 2002 at 2:13 pm
don't have a solution here. You could implement it using any algorithm, but the key management will be the weak link. You'd have to store it somewhere.
Check Google, or...
September 17, 2002 at 8:42 am
Viewing 15 posts - 37,111 through 37,125 (of 39,769 total)