Viewing 15 posts - 36,871 through 36,885 (of 39,535 total)
It is possible. I'd use a .cmd file and make a shortcut to that. Also, better (IMHO) to use Windows Auth with this.
Steve Jones
September 19, 2002 at 11:02 am
Run some performance monitoring as well.
Steve Jones
September 19, 2002 at 10:56 am
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
Viewing 15 posts - 36,871 through 36,885 (of 39,535 total)