Thank you very much for the helpful suggestions so far.

Thuan Pham

Ian

Thank you very much for the insightful reply. I will try it.

Ray,

Thank you for the reply. I don't have access to changing the code on the client side. Which regard to opening the SO. When we first create a SO, it...

Hi,

This looks like a permission issue. Make sure that you have access to the server. You can check this by creating a test table with a primary field and some...

Hi,

We need information like how many transactions is the server expected to handle every hour or minute. How many users will connect to the server ?

Basically, this is what I want. I have an SQL server database and a Visual Foxpro application connecting to it. I can't change any code in the Visual Foxpro application...

Thank you for all your help. I will try the Select 'This is a test' statement.

It would be great if the user can link to the query and update or insert data because of permission requirements. We don't want the user to see all data...

Did you try this :

update X column from table C where X in (select column X from table A inner join B on A.X = B.X)

This will not work...

Since the cast statement: CAST ('Tuesday, May 10, 2005' AS smalldatetime)  has error, try this

cast('5/10/2005' as smalldatetime)