Database restore?

2005-06-02 Thread Noah J SILVA
Hi, I want to know the best way to duplicate a database in SAPDB 7.4. I made a new database, took a full backup of the original db, and tried to restore it to the new database (on the same server). The restore fails with error -2008 "Message not available". Thank you, Noah Silva Ar

RE: Alter Table on existing table containing data

2005-06-02 Thread Kittel, Martin
Hi Stefan, >From: Stefan Schmidt [mailto:[EMAIL PROTECTED] > >I am trying to add a column to an existing table in a database. When I >try to do this in SQL Studio, it give me a warning about "ALTER TABLE" >being very slow when used on a table containing data and then it seems >to hang. Is ther

RE: Tablestatistics

2005-06-02 Thread Kittel, Martin
Hi Bernd, >From: Eckenfels. Bernd [mailto:[EMAIL PROTECTED] > >While running some queries on TABLESTATISTICS I noticed that it is >pretty slow. How do you handle those? Copy it to temp tables for >processing or are there some cached operations? > TABLESTATISTICS actually reads all pages of a tabl

RE: Webdav, Server Crash (CREATE FUNCTION in 7.5)

2005-06-02 Thread Kirmse, Daniel
Hi Xavier, First of all: There is no other way to retrieve a documents URL than by using a recursive select. That approach was perfectly right. As for the means you used I have to disappoint you in a way: functions are not released in 7.5. They are present in a more work-in-progress like way. A