Search results for query: *

I have labelled a project that contains 2 files and 5 sub-projects. This appeared to work. I show History and select the label version, click GET and check recursive and build tree on the dialogue box. I click OK and all files are retrieved but they appear to be the latest version rather than...

sp_rename works and does not issue any error. It updates the entry in sysobjects but does not edit and change the name held inside the stored procedure following the CREATE PROCEDURE text! I am asuming that it is not designed to do so!

We need to apply some naming standards to existing databases and are trying to rename all the objects. Stored procedures are the problem, I can rename the object using sp_rename but this does not change the name within the procedure i.e. after CREATE PROCEDURE. Does anyone know of a quick way to...

I am trying to use the Retrieve LogonInfo for a subreport but I get the info for main report. Any ideas please?

Please Help if you can. We have a regular data transfer requirement from a sql database on server1 in domain1 to sql database on server2 in domain2. There is no trust relationship between the domains and there is a firewall between the two. How can we get this to work? many thanks, sue

We have converted some reports to CR 8.5 but have not changed the vb code to use RDC rather than the old OCX. Everything appears to be working OK! Does anyone know of a reason why we should not go for this as an interim upgrade until such time as we need to use the new features offered by the...

We are using CR 6 with SQL 7.0. The report includes a long text field which is not being printed correctly. Some lines are not wrapping around, so characters on the right margin are lost, also the last chunk of text does not appear. The text length ranges from 10 to 9000 characters. Any ideas?

Does anyone use CR8.5 with VB.NET/ASP.NET within the .NET framework? How easy is it to do this rather than using the CR.NET version?

IS this a bug/feature in MDAC 2.7 do you know? We are now experiencing this same problem on an existing application that works under MDAC 2.5. Since installing .NET and MDAC 2.7 we are now getting this error message on a stored procedure with datetime parameters. Can anyone shed any light on...

We are experiencing the following problem: Changes are made to an ASP and frontpage is used to transfer thwe new asp to our production WEB server. When we go to the page via the WEB site defined the change does not show however, if we navigate to the asp using the URL then the change is...

Hi, Does anyone know of any bugs/problems with installing service pack 4.0 please? cheers

Hi, It is not exactly the same but we are having performance issues running stored procedures in scheduled jobs. Run in Query Analyser it takes seconds, run overnight as part of a schedule and it takes 50 time longer. We tried it in SQL 2000 and this seemed to be OK, we have now found that...

Hi, We are experiencing this very same problem. Do you know if sql 2000 corrects it? cheers, Sue

Hi, Did you have any joy with improving this situation. We appear to be having the very same problem.Would be grateful for any guidance?! cheers

1. Am I correct in assuming that Crystal Reports 8.5 is required if we are converting all our databases to SQL 2000? 2. Is it possible to run two different versions of Crystal Reports on the one workstation? i.e. 6.0 and 8.5 We will need to do this because of third party software still...

Many thanks for your quick response, but we want to use integrated security and we know that the users can logon because sometimes it works! This error is occurring intermitantly for specific users who have been able to logon to the application and perform other tasks requiring a connection to...

We have distributed a VB6 application to windows 95 clients. It uses ADO and ODBC to connect to the SQL server. An intermittant error is occurring, -2147467259 [DBNMPNTW] Specified SQL Server not found. All users are on a fast link to the network (2mgbits). The application uses disconnected...