The table definitions are the same? (char vs varchar)

*Closing the connections would be a great start. (releases remaining locks etc)

*Sql server's goal is to occupy memory till 4-10mb free memory is left over. (in dynamic memory allocation mode)

Motto: not...

1)Always specify the datalength when converting, otherwise you risk truncation

->CONVERT(VARCHAR(20),CREATED_DATE,101)

2)What datatypes are @START_DATE and CREATED_DATE?

Have a look at http://support.microsoft.com/kb/839279

it is the "full" version of the problem description.

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