Search results for query: *

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

Hi, Is it possible to create a Stored Procedure in VB during Run Time with variable number of parameters? Thanking You,

Hi, I need to pass 10,000 bytes of string data from Visual Basic ADO to a SQL Server Stored Procedure. Right now I am calling SQL Server Stored Procedures 10 times sending 1000 bytes each time. The performanance is slow. Is there any way I send all 10,000 bytes of data to a Stored Procedure...

Hi, I need to pass 10,000 bytes of string data from Visual Basic ADO to a SQL Server Stored Procedure. Right now I am calling SQL Server Stored Procedures 10 times sending 1000 bytes each time. The performanance is slow. Is there any way I send all 10,000 bytes of data to a Stored Procedure...

Hi, I am executing SQL task for executing Stored Procedures. Whenever Stored Procedures abends due to fatal error i.e. invalid column name is not being recongised by DTS as an error instead it says it is successful. Is there any way to trap fatal errors from Stored Procedures when executed...

Hi, I need to design text boxes with fixed length i.e. a text box of 4 chars long. Is there any way in CR 6.0 to accomplish this? Thanks, Babu Vechalapu

Hi, Is there any way I can see byte position in the Crystal Report Designer. Thanks, Babu Vechalapu

Hi, I am using CR 6.0. I would like convert a crystal report automatically generate a spread sheet without replying for the prompts. I would like to schedule this job every night through a SQL Server Data Transformation Service scheduler. What is the best way I can achieve this. Thanks...

Hi, Is there any way to print crystal report to a spread sheet without answering prompts. I would like to schedule crystal report to run daily without replying to prompts. Thanks in adavance. Babu Vechalapu