Viewing 15 posts - 3,421 through 3,435 (of 6,216 total)
Might be, I just don't know how. Possibly there is some event you could trap. Unless you do find one all purpose terrific step execute event, you'll have to add...
August 21, 2002 at 5:16 pm
Upgrade to Enterprise if you need native log shipping or want to use more than 3g of memory. On the timeouts, have to see why before you can decide what...
August 21, 2002 at 5:13 pm
Change your settings in QA to display more than 255. And could you not post example strings that are so long? I agree it should wrap, just doesnt. Thanks.
Andy
August 21, 2002 at 5:11 pm
I think you'd have to pull the text out of syscomments and parse it. An alternative might be to leverage an ado command object, use the parameters.refresh method, see if...
August 21, 2002 at 5:09 pm
Im still using Query Analyzer, reasonably decent and the price is right!
Andy
August 21, 2002 at 11:57 am
You can. Lot of work. If you're not modifying schema, you can just stop the replication jobs if you just want to pause the changes being pushed to the subscriber....
August 21, 2002 at 11:56 am
Totally agree. Separating picklist from resulting pick is only way to go.
Andy
August 21, 2002 at 8:06 am
Not sure I agree about the normalization part. The alternative is to keep adding tables every time you need a new list. I've got one app that uses 40 distinct...
August 21, 2002 at 6:24 am
I dont know how to directly, though that doesnt mean anything. You could set a global variable in each step, easy enough to do that way.
Andy
August 21, 2002 at 6:21 am
August 21, 2002 at 6:21 am
I've tried most of them, none seemed quite what I wanted, but all have good points. Suggest starting with the built in stuff, get a feel for what it can/cant...
August 21, 2002 at 6:19 am
Memory usage isn't a big deal unless you're paging because you don't have enough. Even 50% cpu utilization isn't cause for alarm, when you're 75% or higher consistently or seeing...
August 20, 2002 at 4:01 pm
Just because Im endlessly curious, can you tell me why you are so concerned about avoiding locks?
Andy
August 20, 2002 at 2:22 pm
Yeah, but isnt it great to have a problem to figure out?
Do you have any subscribers that aren't connecting? Distribution agent is definitely running? Depending on the size of the...
August 20, 2002 at 12:52 pm
Cant detach while replication is live. Maybe start by updating statistics and space usage, then seeing which tables are using all the space?
Andy
August 20, 2002 at 12:17 pm
Viewing 15 posts - 3,421 through 3,435 (of 6,216 total)