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...

Is the database being protected by access user security?

In this case you probably have to copy the mdw file to your sql server.

A Workgroup Information File (*.MDW) stores information to...

Looks they have service pack 4 of sql server where the issue should be resolved.

If adhoc queries of your access databases isn't allowed, you can still refer to them if...

cvsql1\administrator should be correct

My account in SQLServerAgent service got abbreviated to

.\administrator

I hope this helps.