Don't know if pushing the where clause in the join syntax yields more performance.

DECLARE @FuSSIN VARCHAR(9)

SET @FuSSIN = '123456789'

DECLARE @lYear SMALLINT

SET @lYear=YEAR(GETDATE())

 SELECT

  C.Account      as [Account Nbr],

  @lYear- Year(C.BirthDt)  as [Age],

  isnull(C.ObjectiveName,'')   as [Objective],

  C.AnnualIncomeRange     as...

Try it more set-based, the triggers only does fire once.

Haven't written it all out.

/*INDIVIDUAL INFO*/

UPDATE FamilyGroupInfo

/*FEMALE COLUMNS starting with m??*/

SET

mFirstName = CASE myAccountTAble.GENDER WHEN 'F' THEN myAccountTAble.FirstName ELSE mFirstName END,

mGreeting...

Can you post the routine?

Since the SPID's are different I assume 2 different users.

There is no standard command for logging DataModelingLanguage-statements.

If you mean datachanges, you could periodically start a job that would write data from the auditing table to a file.

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