Search results

  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
  16. W

    SAGE - SQL - ACCESS LINK

    Also not a sage user. The blank data type probably indicates a calculated column. In design view of table you'll see no data type and a function reference. The users may have select privilege on the table but can't execute the function. Hth, Wayne
  17. W

    SSMS - turn off Auto Complete via space / spacebar

    Isaac, Maybe you were using Redgate's SQL Prompt. It's much easier to customize. Wayne
  18. W

    Protecting tables from accidentally being deleted or edited

    If you apply a foreign key at least it will ask you before it drops the table. That should help a little. As for editing … maybe the triggers in the newer versions of Access … hth, Wayne
  19. W

    question about WOKE

    You've run out of other topics ??
  20. W

    how to combine 2 separate queries in sql server

    I'm on an iPad so typing is tedious. I see 4 views in the 2nd query. The actual execution plan should be showing full scans for them. You can create them with schemabinding. That will let you put indexes on them and really speed things up. Failing that, you can do as Minty said earlier and put...
Top Bottom