Search results for query: *

what will be the CE9 Query To return Number of instances currently runing? many thanks

if the .NEt service is runned from a diff box then sql server please check the regional settings at that box as well

how to increase memory used by a process, i am trying to increase memory used by mssearch.exe, I have windows 2000 server 2GB RAM I processor SQl Server Stabdard Edition Virtual memory 3070 MB I need increment in physical and virtual memory for mssearch.exe many thanks

I am working on a denormalized table ContactID Order_Order_Date ParticipantDate 1 20/12/2001 NULL 1 NULL 12/10/2002 1 29/12/2001 NULL ..... Query I am firing is select...

here is the query... SET QUOTED_IDENTIFIER OFF declare @vTemp as varchar(22) declare @vTemp1 as varchar(60) declare @vTemp2 as varchar(12) set @vTemp2 = '" 4"' --set @vTemp1 = '14 Marchmont Rd' set @vTemp1 = 'SF6 9NU' --ASSIGN ANY VALUE LIKE '.', '(' AND ERROR WILL OCCUR set @vTemp = '.'...

well, I have done almost all the things but still getting this error while doing full text search Execution of a full-text operation failed. A clause of the query contained only ignored words What i have done is 1.removed every thing from all the Noise.* files in \FTDATA\SQLServer\Config,( i...

Much thanks for the advice of using temp table I have recived the same advice from other forums i have posted the message. ISSUE 2, well, all what I want to do is assign a value to a varible from a select query and then use that variable in freetext() or contains(), when I assign value...

ISSUE 1 I want to use variable in fulltext funtions while accessed through cursor, from below error it feels like this feature not supported CODE SAMPLE DECLARE cr_GroupByAddZipNameMatch CURSOR FOR --SET @vZip1 = '"' + @vZip1 + '"' SELECT * From temp where...

I am creating query dynamically, based on parameter enter into the store procedure, but i found that i am not able to concatenate one of my field which is binary and Primary key in the database with the query string. I cant change the database. Any suggestions ?

HI guys, i had the same problem and i resolved it, tell me whether any of you has transfered the CMS database from one server to an other ? If yes or even no, try this: if you are on a domain try running all the CE servers under the Domian account which should be in the local Administrator...

Hi can u tell me how to connect crystal reports with Oracke DB on Unix, which odbc driver should I use ? many thanks

synapsevampire, first thing, how can we force CE to limit instances to 1 ? and the report which user will click to run from any instance, i think that report will get refreshed only and only if that particular instance is refreshed(am still not sure), econd thing, YES user should not press...

We have Crystal Reports 9 Advance Edition here and by with we have got Crystal Enterprise Standard Edition for 5 concurretn users, we have tested it as well. Now, I was to ask a question regarding Crystal Enterprise, we have a user requirement here to Auto-Refresh Report Data On the User...

Well.. I have a main report(NO1.rpt) and i insert a sub report(NO2.rpt) in it, now that subreport(NO2.rpt) has another subreport(NO3.rpt) in it which works fine if i run only (NO2.rpt) but when i start (NO1.rpt) and clicl the link of ondemand subreport which is (NO2.rpt) it shows the data but...

Well.. I have a main report(NO1.rpt) and i insert a sub report(NO2.rpt) in it, now that subreport(NO2.rpt) has another subreport(NO3.rpt) in it which works fine if i run only (NO2.rpt) but when i start (NO1.rpt) and clicl the link of ondemand subreport which is (NO2.rpt) it shows the data but...