The problem I had was that I was calling a property of a com wrapper that returned a SQLDMOSQLServer. The problem was that in my code I was reseting the...

Ok here goes. You will soon learn that CURSORs are bad, satans invention. Initially were only included in SQL Server cos ANSI standard required them. Put this way in 6.5...

The package data is held in sysdtspackages and the package info is held in an image column, so you can't really query it.

Have a look on www.sqldts.com

Simon Sabin

Co-author of SQL...

POssibly because of the time it takes to send the information to the profiler, are you running it local to the server or remotely

Simon Sabin

Co-author of SQL Server 2000 XML...

Have a look at http://www.sqlservercentral.com/forum/reviews.asp?CAT_ID=7&FORUM_ID=29&TOPIC_ID=1364&type=2&article=488

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

They are both bad because you cannot use indexes you should use

Create Procedure dbo.Foo

(@P1 int = null, @P2 char(5) = null,..)

As

IF @P1 IS NULL AND @P2 IS NULL

SELECT...

If you want a TSQL solution use BULK INSERT, your SP could then be passed with a filename and that can then run BULK INSERT into a table which you...

I had this when I inadvertently reset the connection have you tried

dim d as sqldmo.database

set d = g_objSQLServer.Databases(g_strDatabaseName)

For Each sqltable In d.Tables

debug.print sqltable.name

next

Simon Sabin

Co-author of SQL Server 2000 XML...

Put the values in a table and do something like

UPDATE ICCATG

SET CATEGORY = NewCategory

FROM MappingTable

WHERE MappingTable.OldCategory = ICCATG.Category

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Just a word, if would probably be quicker to populate this columns at the same time you are populating #statesummary, rather than updating it, this is especially true if you...

I believe, not done it myself, that you can use SET LOCK_TIMEOUT. This will set how long to wiat for a lock before cancelling the query.

This will also affect...

Is the server running?

Has the password of the SQL Server service account been changed and thus the server cannot start because it has the wrong password?

Simon Sabin

Co-author of SQL Server...

There will undoubtedly be improvements in Yukon.

I don't use IIS and SQL but do use FOR XML and OPENXML

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Triggers are one option. Lumient log explorer is another.

With triggers you are best to log to another table.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

You need to use a global temp table i.e prefix ##

Look up "bcp utility, copying data to or from temporary tables" in BOL

Simon Sabin

Co-author of SQL Server 2000 XML Distilled