1)If you are only running scripts and all objects are owned bij dbo, I don't foresee problems regarding database ownership.

2)I haven't got the chance to work with sql 2005. In...

You can generate scripts of all objects  using the enterprise manager.

(rightclick database->generate scripts)

You could create a blank database with all the necessary objects, back it up and restore it there.

also check this one out

http://support.microsoft.com/kb/839279

*is it the insert that takes longer than a minute or the whole batch?

*First thing to do is retrieving all requested records, since not-yet transferred records hold locks.

'todo, convert to...

with set identity insert

* a thread working with identity*

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=265998

SELECT     *, dateupdated AS Expr2, completed AS Expr1

FROM         dbo.ONSA_NSS

WHERE    dateupdated <= DATEADD(dd, - 5,getdate()) /*older or equal than 5 days*/

 AND (completed IS NULL)  /*not completed*/

AND (oneday = 1) /*oneday??*/

Do you have sample...

Do the client install & server install have the same servicepack level?

Have a look at DSN-less connections:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;892490

The recordset has more than one parameter for the open-command.

By default it requests the data in read-only mode.

See

http://www.w3schools.com/ado/met_rs_open.asp

for the available parameters.

Rs2.Open"Select * from [V2] where Flag=1",,adOpenKeyset

I only needed WHILE @@FETCH_STATUS = 0

Checking for other conditions would complicate my code.

*

Ado opens a cursor to the view ( rs2.open)

with Rs2!Flag=3 you try to update it via the cursor.

What are you trying to do (only viewing or also updating)?

Very weird indeed.

How do you check the size of non-clustered indexes?

Can we see that piece of code?

Is there a linked server involved?

What ODBC driver is it? Oracle, Mysql ,...

The following applies to sp3a but most likely also to sp4a (number 3):

1. To install SQL Server 2000 Analysis Services Service Pack 3a, see

2. http://go.microsoft.com/fwlink/?LinkId=28434.

   N