Forum Replies Created

Viewing 15 posts - 1 through 15 (of 335 total)

  • RE: xp_smtp_sendmail error

    If it didn't give you an error on "dir c:\..." just file not found, then the file isnt there or it is hidden.  The path is there.

    Make sure what server...

  • RE: xp_smtp_sendmail error

    just to be certain try

    master..xp_cmdshell "dir c:\test2.txt"

    to see if your sqlserver session really does see/have permissions to the directory.

    If it does... Idunno. It's a 3rd party thing... mayby try full UNC...

  • RE: How to remove a device from a sybase database?

    You have me confused. 

    Perhaps you are trying to do what MSSQL allows you to do: detach and attach.  If that is the case it is not allowed in Sybase....

  • RE: xp_smtp_sendmail error

    Is that file in the C:\ directory of the server and not the client?  It needs to be or you need to use a UNC to have the server go...

  • RE: returning most current record

    lost my post I guess.. here goes again:

    you need to know the key columns for the tables:

    SELECT key columns, MAX( change_date--orwhatevertheauditcolumnis)

    FROM audittable GROUP BY key columns

    then you can use...

  • RE: How to compare text columns

    Then you could always break the statement into multiple filters

    where substring(a.text, 1, 8000) = substring( b.text, 1, 8000)

      and substring(a.text, 8001, 8000) = substring( b.text, 8001, 8000)

      and substring(a.text, 16001,...

  • RE: How to remove a device from a sybase database?

    sp_dropdevice not working?

     

  • RE: BCP Command Error using path that contains space?

    in dos command line you can wrap paths with double quotes

    select 'copy "\\ really long path or whatever.txt" ... '

  • RE: Parameters vs Local Variables in SP

    first off, are you doing a DBCC DROPCLEANBUFFERS between each test to make sure that the faster run isn't faster because of HDD IO?

  • RE: DST Ready

    Three cheers for Arizona and Hawaii: We don't need no steenking DST.

    (But why is it colder here in Phoenix today than in New York?  One of nature's cruel jokes?)

  • RE: Software as a Service

    I have one fundamental problem with software licensing: they want to disclaim any responsibility for faults.  They need to either treat it as any other product or accept full responsibility,...

  • RE: Populating Fact Table with keys from Bridge Table?

    I think I'd go the user defined function route:

    First, your group bridge table is probably normalized, so I'd write a function that concatenates your DRGkey into a sorted, comma delimited...

  • RE: How to determine the order of columns in indexing?

    It's all about how your application will query it (and/or needs it sorted).

    If you frequently select all orders for a given date, probably have a secondary index on order_date.

    If you...

  • RE: How to count the number of bytes in in each row?

    What's wrong with summing the length field in the syscolumns table? (where id = object_id( tablename ) )

  • RE: Scary Mining

    (Hate to be the cynic, but that's what I do best...)

    Steiger's Law simply put:  (Sooner or later) Any organization will always evolve to the point that its existence is more...

Viewing 15 posts - 1 through 15 (of 335 total)