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 Rhinorhino 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: Dimm
  • Content: Threads
  • Order by date
  1. Dimm

    SBS2003 lan loses internet when vpn client remote desktops

    We have recently introduced a cisco 2800 router onto a small network with an out of the box SBS 2003 with pretty standard configurations for DC DNS DHCP RA. The Cisco router is now handling DHCP for VPN and Lan clients. It has a pointer to the SBS DNS Server and to the ISP DNS. The router has 2...
  2. Dimm

    Can I return data from this xp_cmdshell function?

    I'm trying to perform an NSlookup in a xp_cmdshell The following returns the required result DECLARE @Cmd varchar(8000) DECLARE @Ip varchar(8000) SET @Ip = '82.44.127.12' SET @Cmd = 'NSLOOKUP ' + @Ip EXEC master.dbo.xp_cmdshell @Cmd But can this be done in a function? I tried but I cant seem...
  3. Dimm

    Select from a Union Query - Can this be improved?

    I have a function GetBestPrice that returns a table of values that are pulled from a union select query on 15+ Tables I then call the function to get SELECT * FROM GetBestPrice() WHERE Price IN ( SELECT Min(Price) FROM GetBestPrice() WHERE STOCK > 0 ) This does work, but I have a strong...
  4. Dimm

    MDI - Accessing control on one of many instances of same child form

    Hi, I have an MDI form that can be opened many times in its parent as tabbed forms. I have a seperate form that loads as a dialog and need to access a control on the active MDI child form. I press a button on the dialog and need to pass a datarow to a grid control on the active MDI child...
  5. Dimm

    DragDrop ImportRow and Duplicate Key

    I have two datagrids, both draw some of thier data from the same SQL table, and the rest from several others. I need to drag data from one grid to the other, in doing so, all I need to do is change a few fields in the row. the primary key in the shared table is unchanged. In the dragdrop when...
  6. Dimm

    DTS File Reference Runnig from VB

    I have a DTS package that imports data from an Excel Spreadsheet, the file is located on the SQL Server and has a path D:\file\filename.xls The DTS works fine when run on the server. I am now trying to execute the DTS from vb. The DTS runs ok, but I get an error Additional information...
  7. Dimm

    Field size limit for export to csv in DTS?

    Hi there, I am trying to output a table with two nvarchar fields (500) and about 25 other fields, using a DTS transform. I am unable to load the output fields in the data transform without enteprise manager closing after pressing exec. It works when I export to an access type. Question: is...
  8. Dimm

    Joining Table output into one field

    I have an sp that gets product information from a table. I need to join all the results into one string Example Name Value Units Width 35.0 cm Depth 50.1 cm Weight 0.75 kg Height 0.7 cm Into Width 35.0 cm | depth 50.1 cm | Weight 0.75 KG | Height 0.7 cm I guess there is an easy way, but it...

Part and Inventory Search

Back
Top