Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. seabra

    sa permissions

    My problem is that i have no other system administrator. MS
  2. seabra

    sa permissions

    Hello! I'm trying a problem with a sql 2000 server. My SA is not linked to the sys_admin role. How can i resolve this? Best regards MS
  3. seabra

    XP_FILEEXIST

    The problem is the SQL version. Thanks
  4. seabra

    XP_FILEEXIST

    DECLARE @CAMINHO CHAR(255) DECLARE @RESULTADO INT SET @CAMINHO='E:\CIMATRON\COM.RESULTADO.PDF' EXEC MASTER..XP_FILEEXIST @CAMINHO, @RESULTADO OUTPUT PRINT @RESULTADO Sorry, this is the code i'm trying to run, without "DIR
  5. seabra

    XP_FILEEXIST

    DECLARE @CAMINHO CHAR(255) DECLARE @RESULTADO INT SET @CAMINHO='DIR E:\CIMATRON\COM.RESULTADO.PDF' EXEC MASTER..XP_FILEEXIST @CAMINHO, @RESULTADO OUTPUT PRINT @RESULTADO Even when the file "COM.RESULTADO.PDF" doesnt exists it returns 1
  6. seabra

    XP_FILEEXIST

    I'm working with xp_fileexist function and it works very well. My problem is when the files i need to search are something like "aa.cc.extension". When the filename have more than one point the output is 1 even when the file doesnt exists. How can i resolve this? Any sugestion? Thanks
  7. seabra

    Update and leave latest item

    You can try something like this delete from tablename where revision not in (select top 1 revision from tablename order by revision desc) MS

Part and Inventory Search

Back
Top