Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Alter / Change Column Data Type

    Alter table tableA Alter Column ColA

    integer NULL

  • RE: Stored Procedure Technical Spec recommendations

    I agree with a graphical representation - A picture is worth few thousand words.

    Also, try using bullets and points.

    Maybe you can put it in a table of some kind.

  • RE: timeout expired

    Try using commandtimeout on your command object instead

      Dim objConn As SqlConnection = New SqlConnection(strConn)

      Dim objCmd As SqlCommand = New SqlCommand(strSQL, objConn)

      objCmd.CommandTimeout = 0

    Set it to "0" for infinite.  Now...

  • RE: DTS Problem

    Try using an ActiveX script for the transformations on date columns.  The VB scripting in ActiveX script will almost let you do anything you want.

Viewing 4 posts - 1 through 4 (of 4 total)