Search results for query: *

I did a lot of research and analysed that the Access 2000 was not supporting the serail datatype in Informix. So modified the fields that had serial datatype in Informix to Integer and used a global autogeneric function in the front end and generated a sequence This gave me a solution. See if...

I have an application which usess access as front end and informix as the backend. I have a lot of code in access which uses the 'DoCmd.RunCommand acCmdSaveRecord' to save a record. Now this works perfectly with access 97. Now when I convert the application from 97 to 200 it does not let me...

I have a partitioned view, I can't create index on that because I am using computed (non deterministic) column. My doubt is whether or not the view will refer to the index I created on the tables involved in the partitioned view

What are the resources(like memory) used for a login? What is the maximum connections established through a single user login? For eg How many connections can be created through SA user, for a single database and different database? What is the advantage of creating more users and sharing...

Terry Thank you. I could acheive this in a more simpler way : Declare @string varchar(1000) Declare @search char(1) set @search='r' set @string='arghjikrkrtruiorkrmrnrjrtyuir' select (len(@string)-len(replace(@string,@search,''))) as NumberOccured

Is there an inbuilt function to find the number of occurences of character in a string. Or is there any other way in which you can accomplish the same

What is the possibility of a Single Database corruption in SQL.

If SQlServer gets more than one request for the same database how are they prioritized and how does SQL Server implement Queues. Any Links/Resources please

Can you suggest if option 3 is best for 300 devices and one device should support 1.2 million records per hour and 10000 records per 30 seconds. For defn. of device see my previous reply

Device means , a user defined software tool to insert the records into the database. This software tool will be running in a separate maching and it uses ADO Connections to insert the records.

We want a database which have to handle incoming data from 300 devices and the same time any no(around 300) of web clients can query the DB 1.Whether to have a 300 databases (each per device) or 2.Storing more than one device data in same database but having sepearate table for each device...

I am passing a single parameter in a reportviewer and I have a timer in VB to refresh the report data.In the timer I am calling the refresh method. The problem with Crystal reports is that it prompts for the parameter value each time.Using Enableprompting property I disabled the request for...

I found it myself. <br><br>But was very disappointed that nobody had helped me<br><br>Regards <br><br>DeepaRajesh

How do I activate the Find Tab when I a create a Help file using Help Workshop. I am able to create the button but would like to know how to activate the Find Tab<br><br>Please give a step by step procedure<br><br>Thanks in advance<br><br>Deepa

Hi,<br><i>select getdate </i>()<br>will give you the system date<br><br><br><br>

Please refer to the mail that I have sent you

There are two ways:<br><br>1. Use sp_detach_db and sp_attach_db(Transfers the entire db)<br><br>2. Connect to the new PC,by registering the IP address.<br>   To register, open SQL EnterpriseManager, Right Click on <br>   SQL ServerGroup and go in for New SQLServerRegistration. Give the IP...