Forum Replies Created

Viewing 15 posts - 91 through 105 (of 252 total)

  • RE: Plz tell me how can i get Row Count

    On a whim I thought I would try something, and lo and behold it worked! The key was to do a UNION ALL on the below query.


    Tim C //Will code for food

  • RE: Blade Servers

    We were planning on using the blades for web servers, and com+ application

    servers, with sql server on the back end.

    Load balancing :

    *1st tier - Web servers (A...


    Tim C //Will code for food

  • RE: Access Restrictation with IP address

    quote:


    I'm not worthy!, I'm not worthy!


    Seriously, good point Brian, and Antares, I stand rebutted.

    Tim C.

    //Will...


    Tim C //Will code for food

  • RE: Trigg db-action when files are added to directory

    The ReadDirectoryChanges API lets you know of changes. This API is a beast in VB

    to implement as it requires multi threading. Their are 3rd party controls that

    let you...


    Tim C //Will code for food

  • RE: Can't insert into table from OPENDATASOURCE

    Ok, how are you executing this query? and does it ever work? From your post it sounds like it works for a bit, then stops, and you reinstall, repeat process.......


    Tim C //Will code for food

  • RE: Access Restrictation with IP address

    But the net sends are multicast are they not? So that would prevent them from going across the subnet boundary unless you could configure your router to pass the udp...


    Tim C //Will code for food

  • RE: Access Restrictation with IP address

    AFAIK Andy a drawback to your suggestion is that broadcast traffic (UDP) does not cross subnet boundaries, so the net send alerts would not reach the other subnet.

    Tim C.

    //Will write...


    Tim C //Will code for food

  • RE: Access Restrictation with IP address

    Another alternative to the above perfectly fine suggestions is to use a local SW firewall on the OS. I am unsure of whether Chris meant to use a HW or...


    Tim C //Will code for food

  • RE: Can't insert into table from OPENDATASOURCE

    please don't tell me that is your REAL sa password in that post. You might want to remove that, or obscure it.

    Tim C.

    //Will write code for food


    Tim C //Will code for food

  • RE: Best Practice - Dynamic Query in Sproc

    I anyone wishes email me, and I will email them that combo. It alos will construct a normal where clause for you.

    Tim C.

    //Will write code for food


    Tim C //Will code for food

  • RE: Best Practice - Dynamic Query in Sproc

    I often use boolean logic and short circuirting to write one proc so that I RARELY, and I mean RARELY ever write dynamic sql. I also make use of this...


    Tim C //Will code for food

  • RE: Best Practice - Dynamic Query in Sproc

    I usually do somethign like this, if i want them to be able to pass in an optional parameter to a query :

     
    
    CREATE PROC...


    Tim C //Will code for food

  • RE: DTS job

    quote:


    dts


    quote:


    ... is fun



    Tim C //Will code for food

  • RE: sql server data on a file server

    Are talking a NAS or SAN solution? Or a RAID fibre channel?

    Tim C.

    //Will write code for food


    Tim C //Will code for food

  • RE: Favourite Tools?

    I used to be a big fan of Erwin, and Embarcadero, but here lately I have been using the Visio that comes with VS.Net architect edition, since I buy Visual...


    Tim C //Will code for food

  • Viewing 15 posts - 91 through 105 (of 252 total)