1) an oversight of waittypes in sqlserver

http://support.microsoft.com/?kbid=822101

2)The activity window in enterprise manager isn't autorefresh.

3) You could use the profiler if your query is composed of multiple steps, by watching...

1. The servicepacks are free and available at http://http://www.microsoft.com

It could be you have to pass a "genuine" validation first.

2. Yes, the latest servicepack includes all previous versions.

3.You can do...

Timetable

Timevalue datetime (time)

IsStart bit (value)

select Timetable.timevalue as starttime,min(table2.timevalue) as endtime

from Timetable

inner join Timetable table2

on table2.timevalue>Timetable.timevalue /*younger than*/

and table2.isstart=0

and Timetable.isstart=1

group by Timetable.timevalue

Renamed Time & Value because they are reserved words.

With some functions...

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?