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: bjoern6689
  • Content: Threads
  • Order by date
  1. bjoern6689

    log shipping concurrent read and recover

    I'm looking for a way to load and recover the standby database at the same time someone is reading from the database. Today I get the following error: [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3101: [Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could not be obtained...
  2. bjoern6689

    revers trigger sql-script

    I'm going to change an existing trigger. Before changing I want to list the layout of the trigger, so I have a chance to do a fallback. Does anyone have a script that's able to select whats in dba_triggers column: trigger_body (datatype long)?
  3. bjoern6689

    summertime/wintertime change

    The time-shift from summertime to wintertime is comming up. Is that a problem from SQL-server 7 or SQL-server 2000 ?
  4. bjoern6689

    Where to find the last login time for an oracle user ver. 8.1.7

    Can anyone please help me find the last login time for an oracle user ver. 8.1.7 /Lars
  5. bjoern6689

    Documentation reporting tool ?

    I need a documentation reporting tools, to give me a report of all the sql-server settings. databases, Filenames, filegroups ,users, replication, size, jobs .... aso Does it exist?
  6. bjoern6689

    RMAN obsolete until

    I'm using rman/tdpo/tsm and have 3 succesfull backups: a) 03-feb-2003 b) 10-mar-2003 c) 11-mar-2003 "report obsolete" and "report obsolete redundancy=?" works OK. but "report obsolete until time 'sysdate - 1' device type 'sbt_tape'; doesn't give anything ??
  7. bjoern6689

    Transactionlog backup problem

    Running a maintenanceplan for all databases including backup of transactionlogs only results in a backup of tansactionlog for some of the databases. Not all ??
  8. bjoern6689

    Materialized views

    Hi I need help on finding the query part of a materialized view created by another user. Do anyone know a dba_ table or v$ view where I can find that?

Part and Inventory Search

Back
Top