Recent content by bjoern6689

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...

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)?

Sorry what I ment was: Is SQL-server able to handle the fact that i.e. the time 02:20 occurs twice?

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

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

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?

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 ??

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

Depend on the version. In 8.1.7 it's not possible

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?

including all 3 columns means that it's only nessesary to access the index and not the data-tabel. With only 14000 rows in xwalk02 the index will still be relatively small. I agree that if possible put the new index in cache.

1) Drop the hint. 2) create an index on cms.xwalk02 containing: cpt, si and apc in that order. 3) Accept updating 440 mill rows takes time.