Search results for query: *

I have found the problem thanks to Microsoft - I applied a HOTFIX 859 to SQL and that produces the error. There is another hotfix that you have to ring Microsoft to acquire it as they recommend to wait for another service pack eg SP4 unless it severely affects you operations

Under SQL 2000 running on Windows 2000 server I am able to rename Columns in a Table. But now I have SQL2000 running on Windows 2003 Server and when I go to do a rename of a Column I get the error message 'Scan_Name' table - Unable to rename column from 'Given_Name' to 'Given_Nam'. ODBC...

Hi Danster, No Go. We have tried this - but the problem arises when we publish and try to run the report through Crystal Enterprise. The reports work on the PCs using the CR report Writer nromally as expected. The problem to me seems to be the way the Crystal Enterprise Server is...

I have CE9 on a Windows 2000 server and the data was sitting on SQL2000 under Windows 2000. I have since moved the data to a Windows 2003 server still running SQL2000. I have changed the CE9 ODBC to point to the new server (only changing the server name) and using SQL Authentication and the...

Hi People, I'm having a problem where-by I've created stored procedures that are recursive and return a single result set - I can use this to save someone creating 40 plus reports by adding the procedure like a table and then linking one of the result columns to a column in another table...

Hi People, I'm having a problem where-by I've created stored procedures that are recursive and return a single result set - I can use this to save someone creating 40 reports by adding the procedure like a table and then linking one of the result columns to a column in another table already in...