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!

  • Congratulations SkipVought 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. lhotta

    Exporting database each 2 hours, is it hurt the server ?

    One way you could objectively analyze the impact of the export is to look at the length of time that it takes the job step to complete.
  2. lhotta

    Take ownership from command line

    THe PERMS command in the resource kit lists an option to take control of a file.
  3. lhotta

    list of users

    Try the userdump utility from the resource kit.
  4. lhotta

    AT command

    I think what you want to do is the following: 1) Start - Run 2) Enter cmd - hit enter - this brings you to a command prompt. From there you can do all the typing for at commands. 3) to see the list of currently scheduled jobs, just type in at
  5. lhotta

    Is there a way to extract WINS Data base?

    There is a winsdmp.exe utility in the nt resource kit Bill L'Hotta
  6. lhotta

    Shared Directories

    check to see if you have permissions on the share as well as on the files. If that isn't the problem, try to log on as the user yourself at the server, then on a remote workstation and see if you can duplicate the problem. Bill L'Hotta
  7. lhotta

    Restoring a Database

    Also make sure that the E drive is not compressed.
  8. lhotta

    Drop database problem

    Just because you close the connection at the client doesn't mean that the server closes the connection. There is a timeout for each client connected to the database. Worst case, you can stop/start sql server service and you will be able to drop the database. I don't remember the timeout...
  9. lhotta

    login failed in SQL2000

    I had similar experiences using Veritas Netbackup product. Make sure your account is set up as system administrator under SQL. It may need to be in machine admins as well. If those steps fail, make sure you have explicit read/write permissions to each database. Good Luck

Part and Inventory Search

Back
Top