No longer reliable for sql server 2000

See the books online.

Sql 6.5

The DBCC PERFMON and DBCC SQLPERF statements documented SQL Server performance statistics used for studying SQL Server performance.

Sql 2000

No longer...

Why would you need the client tools on each pc?

MDAC 2.8 or later should be sufficient.

The same questions popped up earlier this week.

Have a look at

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=222383

or try a search on the forums on

blob, pdf ...

Haven't done it myself

CREATE TRIGGER TR_EMPLOYER_HISTORY /*NAME OF TRIGGER*/

ON dbo.[Emp Table] /*NAME OF TABLE

/*Darn spaces*/

FOR UPDATE /*ONLY FOR UPDATES*/

/*Only inserts when the salary is modified*/

INSERT INTO EmpHis

( /*COLUMNNAMES HERE*/

)

SELECT

INSERTED.Column1,INSERTED.Column2,...

FROM INSERTED /*CONTAINS THE...

seems enterprise manager has a limit of 1024 / field

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1124064,00.html

Are you monitoring SQL memory usage using the performance counters SQL Server provides or via the task-manager?

So @SeedTableName,@TestExecutionTableName are variable tables?

Looks like xpstar.dll has not been put in the registry.

Try adding it by using regsvr32

like regsvr32 xpstar.dll in the directory where xpstar.dll is located.

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