Forum Replies Created

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

  • RE: Using Pull Down menu to Populate the page from DB

    Yes there is an onChange event in java Script. Just add the event handler to the tag. <SELECT name="dropDown" onChange="dropDownChanged()"> Then add the function dropDownChanged() in a...

  • RE: Using global variable in DTS

    When you tried: select * from Oracle_table where activity_date >?

    Did you get the same error message or a different one. I can not try to recreate your...

  • RE: ASP and ADO Gotcha - Duplicate Field Names in a Query

    quote:


    Is this article for real? You must be very new to ADO programming to just be hitting this.


    August 11, 2001 at 9:35 pm

    #417569

  • RE: Auto restart SQL Server Agent

    I pulled the following from MSDN:

    SQL Server Agent monitors itself and the Microsoft® SQL Server™ service.

    Self-Monitoring

    SQL Server Agent starts the xp_sqlagent_monitor extended stored procedure (SQL Server Agent Monitor) to monitor...

  • RE: accessing output values from a SP

    What does returning a recordset have to do with retreiving the output parameters? You do not access the output parameters via a recordset you access them as Chris as...

  • RE: Auto restart SQL Server Agent

    SqlAgent runs as a NT service so the operating system is responsible for restarting the agent if it fails. In fact if you go to Administrative Tools --->Services --->...

  • RE: Auto restart SQL Server Agent

    I did exactly what you tried and it worked fine for me. Could not kill sqlagent.exe from task manager though had to use the kill command but it came...

  • RE: Views vs Temp Tables in Queries

    Generally speaking no but With SQL2K you can have indexes on views so if you're running sql2K its the way to go. Here is some info on indexed views...

  • RE: Using Left Function in a JOIN

    For your situation I think the function is fine. Maybe it would be diferent if you had 130000 diferent values for LEFT(T1.FIELD1,3). With only 12 values in 130000...

  • RE: Query Analyzer overlapping/garbled result text

    Be sure to let us know the results.

    Thanks

  • RE: CHECK CONSTRAINTS

    I pulled this from T-SQL help file:

    . Use @@ERROR to detect a specific error

    This example uses @@ERROR to check for a check constraint violation (error #547) in an UPDATE statement.

    USE...

  • RE: Query Analyzer overlapping/garbled result text

    I had similar problems with a Dell PC that had an Intel 810 graphic controler. Updated the video driver and everything was great. Did you get this before...

  • RE: Linked Server View

    I am guessing that Microsoft Transactin Server is getting involved here and maybe your Sybase ODBC drivers do not support this. Check out this link you may find some...

  • RE: query problem...

    SELECT a.f1, a.f2, temp1.detail, temp2.detail

    FROM (a LEFT JOIN b AS temp1 ON a.f1 = temp1.id) LEFT JOIN b AS temp2 ON a.f2 = temp2.id;

  • RE: SQL Server Renamed >> Error

    Im not an expert on DTS so I can't say if there is some kind of configuration you can do or something but a hack at this would be to...

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