Recent content by vechalapu

Hi, I have designed a new BO Universe. I would to save it to an existing Server Repository on SQL Server, so that all other users can use this universe. This existing repository database has few universes being used. I would like to add this new universe to the repository. Thanks.

Hi Mike, Thank You Very Much

Hi, Is there any function I can use to select records one day less than CURRENT_DATE in DB2? I would like to retrive records loaded one day before than that day in a DB2 SQL Query. Thanks in advance.

Hi, Thanks for all the help.

hi, When try to open a file in Vb 6.0, I am getting error 'file already open'. Is there any way to check, if the file is open or not, so that I need to open the file again. The file is stored on a network so I do'nt have too much control over the file. Thanks

Hi, I need to migrate databases from SQL Server 6.5 to new faster SQL Server 6.5. Please let me know if there is any documents listing tasks needed to done for successful migration. Thanks

Hi, I am trying to troubleshoot why a scheduled event did not run. I found out there is nay acivity log for few hours missing in the file. Can some one help how to find out what happend on the server during those hours. Thanking you

Hi, I need to add an identity column to a table with 5 million records. When I tried to add, transaction log is filling up as well as taking for ever. Is there any other I can accomplish this task without filling up log or in less time? Thanking You,

Hi Steve, Thanks for the reply. When you are defining Repository connection, as a supervisior when you click set up on "Administrative Setup wizard - Step 3/5", when you click setup, in database engine combo box, only MSAccess97 and MSAccess2000 are displayed. I would like to create...

Hi, I am new to Business Objects. I have completed Dimensional modelling and loading data in SQL Server 2000. I would like to create repository in SQL Server 2000 for this database. How would you create repository in SQL Server 2000? Do you create universe first or repository first? Thanks...

Hi, I have a function with two On Error statements in a same function. I would like to know which error handler will activate in case of an error in the function. Thanks in advance.

Hi, Does this work for SQL Server 6.5? I did not find login name column in syslogins table in SQL Server 6.5? Is there any other table I need to use instead of syslogins in SQL Server 6.5? I am migrating SQL Server 6.5 from one server to another with SQL Server 6.5 and planning to copy...

Hi, I need to copy SQL Server 6.5 Database on Server A to SQL Server 6.5 installed on Server B. The size of the user database to be copied is 5 GB. Do I need to create new database on Server B with 5 GB Data device before I run Transfer Manager to copy Database from Server A to Server B...

Hi, I have VB App calling crystal report. The crystal report generated on PC A is correct, but when installed on another PC B generates wrong results. I Checked DSN it is correct, so please let me know what else could create this type of error? Thanks in advance.

use rollback transaction.