Forum Replies Created

Viewing 15 posts - 61 through 75 (of 252 total)

  • RE: Changing length of User-Defined Datatype

    Heres what I think you could do (kinda like musical chairs):

    Scenraio A (want to keep the UDT name the same)

    1) Create a new temp type that is the same...


    Tim C //Will code for food

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

    The above code is VBScript. It is designed to run in WSH, so just copy it into a VBscript file, and change the path ensuring you keep the \\\\ four...


    Tim C //Will code for food

  • RE: SQLXML and sorting

    What I would suggest is writing an XSLT that does an xsl:sort and use a xsl parameter for the sort. You can then pass the users parameter on to the...


    Tim C //Will code for food

  • RE: Log IP address of remote login attempts

    Sorry, should have mentioned that I will post example VB6 code to do DNS lookups if anyone wishes.

    Tim C.

    //Will write code for food


    Tim C //Will code for food

  • RE: Log IP address of remote login attempts

    You could also do a DNS lookup through the API. That is if they ar enot putting spoofing their hostname like Chris said.

    Tim C.

    //Will write code for food


    Tim C //Will code for food

  • RE: Inserting multiple rows

    You can use OPENXML for adding multiple rows. It is extremely fast. I can post an example tomorrow if you wish.

    Tim C.

    //Will write code for food


    Tim C //Will code for food

  • RE: Create an array in SQL Server

    Not only are you still thinking like a developer, but you are ignoring some very

    sound advice from some knowledgeable people. At least about sql server anyway,

    they may not...


    Tim C //Will code for food

  • RE: Log IP address of remote login attempts

    Are they hitting the DB directly? I use soap services to expose our com+ objects, and internally inside the com+ object when I obtain ObjectContext I also get a reference...


    Tim C //Will code for food

  • RE: Calling a T-SQL script from within a T-SQL script

    eugene I think he was referring to being able to call .sql file(s) from within T-SQL file if I am not mistaken. Which is better left to batch files or...


    Tim C //Will code for food

  • RE: Run-time error 75

    I actually like your code Phil. It is simple to the point of being elegant.

    Tim C.

    //Will write code for food


    Tim C //Will code for food

  • RE: SQL and Xml

    Paul watch out for putting spaces in your alias'es for your table and or column names. SQL Xml will convert them to the encoded version. AFAIK (I am not at...


    Tim C //Will code for food

  • RE: finding unused variables in Stored Procedures

    The only thing I can think of is writing a RegEx to run against the script. Would be beyond my regex capability, but I am sure it could be done....


    Tim C //Will code for food

  • RE: WMI

    I am not sure that WMI will become the end all management tool for everything. I

    have used : ADSI / WMI / DMO in projects I have done before,...


    Tim C //Will code for food

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

    This script will let you know when files are created It is a straight copy and paste from the Windows 2000 Scripting Guide Book, and I have tested it out...


    Tim C //Will code for food

  • RE: Stored Procedure Question

    Like Gary said it is not nice, but here ya go : http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B180368 I have done this before, and IMHO that when I am storing this much text in SQL...


    Tim C //Will code for food

Viewing 15 posts - 61 through 75 (of 252 total)