Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: eichmat
  • Order by date
  1. eichmat

    VB.NET: Screen scrap issue

    Ok--I've got a VS-2003 VB.NET-based service that scrapes data from an external web site. The site uses a two-step process of showing the query response--in response to the POST request, it returns an HTML doucment containing only a javascript "document.location" redirect which browsers handle...
  2. eichmat

    sp_repldropcolumn: Generates Error 4932

    Found the answer to my own problem: orphaned article The sysarticles table had entries for an publication that no longer existed. Removing the orphaned entries allowed the drop-column SP to run fine (I have an idea of how the orphans got there and it was due to other issues we had...
  3. eichmat

    Concatenation

    select cast(year(productiondate as varchar)) & cast(month(productiondate as varchar)) from table1 First, forgot the close-parenthesis after "productiondate" in the YEAR and MONTH function calls and second follow sean4e's advice about the "+" instead of "&" (which is used to do a logical order...
  4. eichmat

    sp_repldropcolumn: Generates Error 4932

    Table currently replicated from SQL 2000 server to another (with the second also as the distributor). Using sp_repldropcolumn to drop a column without needing to re-snapshot. When we make the call on the publisher, we get this error: Server: Msg 4932, Level 16, State 1, Line 1 ALTER TABLE...
  5. eichmat

    Replciation Error: Subscription "expired" and does not exist

    Only once the Srv-B was replaced with a new machine after a hardware failure... Never knew the root cause of the problem.
  6. eichmat

    SQL 2K (SP3): Server Performance Condition Alerts

    Ok--I want to setup an alert to let me know when blocking is going on. I've found referneces to selecting "SQL Server Performance Condition Alert" on the "New Alert" form in Enterprise Manager... But, unfortunatley, when I go in there, I only have "SQL Server event alert"... So, how do I get...
  7. eichmat

    Select from "inserted: very Slow

    Oh, I understand that--but I have a feeling that the ability to pick large orders in under a minute instead of the 10-minutes it takes now may take priority over some slower reporting... Thanks again.
  8. eichmat

    Select from "inserted: very Slow

    Ooo... by golly there is a clustered index on a non-key field (part number)... Most likely put on sometime ago for some type of reporting. I'll have to have that changed to non-clustered over the weekend (the database is also replicated and I've got to halt replication before changing the...
  9. eichmat

    Query using LIKE

    You need to include the percent signs before and after the text to locate. It should be: SELECT * from table where column LIKE '%"+variable+"%'
  10. eichmat

    Select from "inserted: very Slow

    I know row-by-row isn't the best, but this is a process that I inherited that I cannot change in the near-term. The process itself is such: when picking an order, for each item in the order, the warehouse location to be used is determined based on some business rules, a call is made to the...
  11. eichmat

    Select from "inserted: very Slow

    I've got some triggers that fire on insert that is used to push a copy of each inserted record into an audit database. Lately, inserts into a particular table have started to bog down considerably (~7 seconds per row!). Data is inserted into the table row-by-row (order picking detail records...
  12. eichmat

    DTC Problems

    As a follow-up. We've also found these entries in the SQL Server Log on Server-A (target server) whenever attempting to execute the linked server command: [COLOR=red]Resource Manager Creation Failed: XACT_E_CONNECTION_DOWN[/color red] Searches of the MS-KB only report issues addressed in...
  13. eichmat

    DTC Problems

    Ok--here's the scenario I've got: 1) Server-A: Windows NT-4 (SP6), SQL 2000 (no SPs) 2) Server-B: Windows 2003 Server, SQL 2000 (SP3) 2) Server-C: Windows 2000 Server, SQL 2000 (SP2) Up until this past weekend, when Server-A was rebooted, I've had a few scheduled jobs on Server-B that did...
  14. eichmat

    Get the .Name of a Menu Item

    Ok--in VB6, to support on-the-fly language changes for our users, we applied a method of loading a list of control translations from a SQL table into a dictionary. Then, for each control in the form.controls collection, based on the control's .Name property (e.g.--mnuFileExit), looked up the...
  15. eichmat

    Scrape HTML

    Thanks! That was perfect! It even handled the re-direct I had to detail with by making striping out the redirect info then making a second web-call... Thanks again!
  16. eichmat

    Scrape HTML

    Ok--I've got a project where I've got to load the HTML response form a URL into a string, then strip out key parts of the page. In VB 6.0 I used an object called ASPTear which took a URL and returned the HTML as a string. I figuired that .NET might have such an item built in, but looking...
  17. eichmat

    DELETE doesn't remove all records

    Sorry--forgot to mention those: Only one FK back to the Orders table on Site and Order_Num.
  18. eichmat

    DELETE doesn't remove all records

    I have a stored procedure that is to delete all records for an order. The delete statement does not fail, but doesn't remove all of the records I expect it to remove. The statement in the SP is literally: DELETE FROM Order_Picked_Items WHERE (Site = @m_site) AND...
  19. eichmat

    Replciation Error: Subscription "expired" and does not exist

    Getting the above error setting up a subscription using transactional replcation. Both servers are SQL-2k boxes in different domains. Topology: Srv-A (Publisher: SQL-2K [no SP]) Srv-B (Dist/Sub : SQL-2K [SP2]) Trusted connections have been established between the domains. I am able to...
  20. eichmat

    Replication: Log Reader Agent Fails

    Situation: SERVER-1 (SQL 2000 [no SPs]): Distributor and Subscriber (in US) SERVER-2 (SQL 2000 [no SPs]): Publisher (in US) SERVER-3 (SQL 2000 SP 1) : Publisher (in UK) SERVER-3 (SQL 2000 [no SPs]): Publisher (in CH) We are using Transactional Replication with continuous update from two...

Part and Inventory Search

Back
Top