timeout error sql query

José Luis De Oliveira

Hi Philipp,

When I want to open designer or print preview, I have this error message (see print screen).

What I don't understand is that it works on SBO or MSSQL but not when I want to open designer.

Can you help me, please ?

Thank you in advance.

Best regards,

Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-image-uploads/joseluis-deoliveira/error.JPG]error.JPG[/url]

Philipp Knecht

Hi José

It shouldn't matter from where you start this query (Preview/Print/Designer) because it's an SQL Server Timeout meaning that there is no repsonse from SQL Server after sending the statement.

You can influendce the Timout by adding the following metadata to the query:

/* @@TIMEOUT=[1000] */

This means timout is for this request 1000 seconds which should be enough :)

hth