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 wOOdy-Soft 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 Jakkels

  1. Jakkels

    Application massively slower than QA script

    Thanks for the responses chaps. Will have a look at capturing the coding in profiler
  2. Jakkels

    Application massively slower than QA script

    We have a query (a few actually) which runs for about 30 secs via Siebel 6 and the same query takes on 1 or 2 secs in Query Analyser, consistently. Naturally this performance problem is causing issues. We're wondering if the App isn't using the same execution plan, or using the indexes or.... It...
  3. Jakkels

    Copy db from one Server to Another

    The problem is with the file locations for the .ldf and .mdf files. The path from the old server will be the default path for the new restore. You must change it to reflect this. I.E On the old server Data file = e:\MSSQL\Data\MyDB.mdf Log file = e:\MSSQL\Log\MyDB_Log.ldf New Server may not...
  4. Jakkels

    SQL Agent Proxy account error

    Bump
  5. Jakkels

    SQL Agent Proxy account error

    In the SQL Agent Properties - Jobsystem tab you can select an account to use for Non-Sysadmin job steps. When I enter the proxy account I get an error Error execuring store procedure: "Specified user cannot Login" The account is fine, not locked or anything, I am entering it the...
  6. Jakkels

    Arcserve2000 or Veritas - Netbackup

    I have used both Arcserve and Backup Exec/Veritas for years in various environments and Veritas is the better product by a country mile. It may be more expensive, but is far far better. It also has better reporting abilities.
See more

Part and Inventory Search

Back
Top