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 TouchToneTommy 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: *

  • Users: troysf
  • Content: Threads
  • Order by date
  1. troysf

    Problem using OLEDB to access SQL Server via widearea network

    Hi all, We are trying to access SQL Server using OLEDB via our widearea network from San Francisco to LA. It does not work. Does anybody know the proper settings/parameters in OLEDB to get this to work? Thanks. Regards, Troy
  2. troysf

    How to get the table names of a SQL Server 2000 database

    This might sounds a dumb question to some people. I need to know the table names of a SQL Server 2000 database inside a stored procedure. Which system table (or SP) should I use? Thanks. Troy San Francisco
  3. troysf

    Syntax for testing for an empty SQL Sever datetime field in CR formula

    In a CR formula, I try to test for an empty (not null)datetime field in a SQL Server table. I try the following syntax: If {mytable.datetime1} = date (0,0,0) then... and If not (DayeOfWeek{mytable.datetime1} in 1 to 7 )then ... None of these work. Does anyone knows the correct syntax...

Part and Inventory Search

Back
Top