Is your application AllFusion Gen ?

Has it worked before? If so, what has changed?

Is your machine up to date with patches?

Is your sql server up to date with patches?

Is this...

Can you contact the support of the application?

see http://www.sqlteam.com/item.asp?ItemID=11842

on more info about ado properties.

Basically sp_cursorfetch is called for each row of your recordset, causing a roundtrip (network delay (100ms?) -> 59*100ms = 5.9 sec).

Plus it use a...

I recommend not to use select * in views nor in stored procedures

Cons of using select *:

You don't know which columns actually will be queried.

The lesser columns the faster. (less...

At which part there are blocking selects? section 1 (the conversion) or section 2 (assigning the language) of the code?

What is the code behind dbo.IPStringToNumber?

-------------------------------

Declare @DateInPast datetime

set @DateInPast=dateadd(d,-5,getdate())

update dbo.wmsLog set longIP...

Perhaps the upgrade of the application has some optimisations that aren't so hard on the cpu? (improved queries ...)

Looks like the server is too busy.

How long you waited?

1)The default database is set by login. See sp_defaultdb in the books online.

Not sure if they can still login when the default database is offline.

(can somebody confirm or correct this?)

2)They...

perhaps you should trace the route the pakket that ping sends.

in a "dosbox"  ( execute cmd)

tracert 10.0.0.5

should deliver an output (or similiar):

tracing route to 10.0.1.5 over a maximum of 30 hops

1) <10...

Thats right.

Restore would be:

*restore full backup of saturday with norecovery

*restore differential backup of wednesday with norecovery

(this instead of applying all transactionlogs since saterday, which would take a long time)

*apply...

1) adding an access database :

EXEC sp_addlinkedsrvlogin

    @rmtsrvname = 'MyAccessTable',

    @useself = false,

    @locallogin = 'loginame',

    @rmtuser = 'admin', /*default access account*/

    @rmtpassword = NULL /*always NULL, see the link below*/

2)...

If adhoc queries would be permitted, your original select will most likely work.

I personally haven't any experience querying access tables through sql server.

Vijay, mind to share the solution for future reference?

You can find a list of connectionstrings at

http://www.connectionstrings.com/

Can be a standalone server without a domain.

For windows authentication it needs a domain except if you run the application on the server itself.

See the books online (sql server help...