Viewing 15 posts - 37,156 through 37,170 (of 39,818 total)
Unfortunately, I haven't been able to get the extended properties in a query. The query above will give some stuff, but I think you will need a cursor and loop...
September 19, 2002 at 10:50 am
DST might be the easiest. Or use multiple steps. One to run the sproc. You might need to use xp_cmdshell running isql to create the ouptu file.
For the zipping, use...
September 18, 2002 at 2:43 pm
September 18, 2002 at 2:40 pm
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
Viewing 15 posts - 37,156 through 37,170 (of 39,818 total)