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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by manufcs

  1. manufcs

    service pack

    Hello, This thread gives exact information about the SQL Server service pack installed. Find SQL Server SP version thread183-458253 Manu
  2. manufcs

    Shell command

    If you are looking for firing a shell command from Interactive SQL then the command is system <operating system command> Eg. system date Following are the reading from testing the above command 1. The command worked only in Interactive SQL Graphical and didn't work on Interactive SQL...
  3. manufcs

    database security

    Hello rheiser2002, This depends on the facility provided by the database. In general creating a VIEW is the best suited solution to your requirement. Oracle supports views, synonyms. Sybase & MS SQL Server allows access to limited field of a table to a user. Manu
  4. manufcs

    MYSQL vs ACCESS WHICH IS MORE POWERFUL

    Regarding Access and MySQL I have mentioned few points in forum - Advice on which type of DB to use thread669-449642 Hope this may help you. Manu
  5. manufcs

    Advice on which type of DB to use

    Hi, I know few of them. Hope someone can add to these. Access is not ment to support centralized database system. MySQL support it. Access supports RDBMS, whereas it is enforced from front-end in MySQL. MySQL support larger database size then Access (exactly how much that needs to be find...
  6. manufcs

    sql or not

    Dear AccessXP, I have mentioned points to consider before taking any decission in Advice on which type of DB to use thread669-449642 dated 05-Jan-2003 Hope this will help you Manu
  7. manufcs

    Advice on which type of DB to use

    Hello OPMCoordinator, Decission to change database depends on many factors out of which I am pointing out few of them. 1. The size of existing database. More the database size better data recording tool you require. 2. Type of application whether it is LAN/WAN. 3. Facilities or utilities you...
  8. manufcs

    What is this database with a *.dat extension?

    Hello Ron, .dat file extension belong to many programms. Reading your query I concluded that it is customized .dat file and the data is being written in it's own format. I suggest following things - 1. If you have ODBC driver for the same then migration is possible. 2. Any inbuild tool to...
  9. manufcs

    Excel 97 into SQL varchar field

    NathanGriffiths is right. I tried your problem as mentioned in http://support.microsoft.com/default.aspx?scid=kb;en-us;236605 I converted excel file into text file and then using DTS migrated to SQL Server. All rows were successfully migrated. Manu
  10. manufcs

    Recursive Query

    Hi, SELECT MANAGER, USER FROM USER_MANAGER GROUP BY MANAGER SELECT USER FROM USER_MANAGER WHERE MANAGER = 'PAUL' Hope I have solved it right. Manu
See more

Part and Inventory Search

Back
Top