Recent content by WayneRyan

  1. W

    Preventing login to server from a client PC

    KitaYama, Google SQL Server logon triggers ... that's what you need. Hth, Wayne
  2. W

    Returning multiple resultsets from a SPROC into an ADODB recordset

    Isaac, Look at sp_help for a table. It returns multiple recordsets. ADODB has rs.MoveNextRecordset. Hth, Wayne
  3. W

    Want to know about "Select Top 1000 Rows"

    Tools --> options This is a settable option, near the bottom. Change the 200/1000 to 0 and you get all. They set those so you don't clobber the network by selecting all from LARGE tables ... They want to protect you :) When you drag names the "[]" are also optional in newer versions. Hth, Wayne
  4. W

    How to run the scripted database in a new server database

    Nector, What generated the script? For most of it. You could run it in SSMS from the master database. The embedded \r \n stuff makes it seem the file originated from a Unix system/utility. Otherwise, the database can't exist on the server where you run the script. The datatype nvarchar really...
  5. W

    T-SQL - Trigger: How to select columns that can only be updated and the other columns are not?

    Dennis Very brief as I'm on a phone. Your inserted table is the same as the source table (IF YOU EXIT THE TRIGGER) Apply your logic to the inserted table; If no violators exit - all is OK Else EITHER 1) rollback - cancel ALL rows updated OR 2) use the deleted table to "restore" the original...
  6. W

    VERY strange behaviour

    Mountain, Typing on phone so ... Try looking at the mSysobjects table at the connection strings. Any surprises ??? Hth, Wayne
  7. W

    How to contact the administrator

    Mike375 ???
  8. W

    Solved Error 3662 You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column

    Kayla, How are you connecting to the Server? Are they connecting to YOUR server? Do you have remote logins enabled? Wayne
  9. W

    Recommendation for calling Share Procedures with Parameter

    MajP, For parameters, look at table-valued functions. They can use your recursive CTEs. They look like tables, but AFAIK you can't link them ... only as ADO entities, but can be used in SQL Server queries. Sorry, *typing*on phone S L O W L Y. Wayne P.S. experiment in SSMS, SQL servers...
  10. W

    Recommendation for calling Share Procedures with Parameter

    MajP, You will definitely want a server-side VIEW. The view is a recursive CTE that is very cool for traversing your hierarchy. The view is accessible either as linked table or as an ADO record-set. Google recursive CTE. Google materialized views if you want to index. HTH, Wayne
  11. W

    Not Equal Expression with Nulls in field

    MajP, On iPhone so ... Some databases will implicitly convert Nulls. Null can = '' -- empty string SQL Server won't do that. Use Coalesce: Where Coalese(ID, -99) <> 18 -- -99 isn't in YOUR data Hth, Wayne
  12. W

    Wait until certain external process has stopped

    Erwin, I still don't know why your original wasn't working. Thats the best method. Your current workaround is based on --> if the file exists; its done. That isn't always the case. At least have the shelled process make a new file AFTER the real file completes.en You can --> echo >>...
  13. W

    Wait until certain external process has stopped

    Erwin Stay with wscript.shell. Fix your reference... or whatever. Its the least complex solution. Wayne (can't type on iphone)
  14. W

    Wait until certain external process has stopped

    Erwin We just migrated to 64-bit 2019 and replaced our API calls with wscript.shell and it works great. Much better. What does not work mean? Wayne
  15. W

    WildCards wtih Null values

    Unless prevented by software or constraints shouldn't the form control be checked for an empty string and resulting from multiple searches? On iPhone so can't type well. Wayne It changed resulting from multiple to --> righteous mating. LOL
Top Bottom