You'll have to generate scripts of all of the objects in the DB - tables, views, procedures, functions, users, etc. Then you'll have to export the data. bcp works, as...

Database restores (including log restores)

Autoclose (a good candidate on SQL Express)

Some sp_configure alterations

DBCC FREEPROCCACHE

Post it on Connect and see what the MS people say.

The info bar at the bottom of the screen does change colour (in SQL 2008) based on what server you're...

umanpowered (11/5/2008)

---

I went directly into a table in SQL 2005, and change a column. I closed

the table. The 'modify_date' is still showing the previous date.

I'm using the...

You can restore the backup to 2008. Databases can always be upgraded in version, never downgraded.

Try something like this

SELECT * , ROW_NUMBER() OVER (ORDER BY ID) % 2 AS AlternatingFlag

FROM SomeTable

The dead lock resources were on the two tables in...

As I said above, you don't need an update in the trigger. The trigger is fired by an update, there's no need to repeat that update within the trigger.

You don't...

That kind of catch-all query doesn't perform well at all. On SQL 2000 there's no way to make it perform well

Have a look at this thread - http://www.sqlservercentral.com/Forums/Topic599065-65-1.aspx

sp_help 'tbl'

Use dateadd to remove 8 hours from the two datetimes. Is it because sharepoint stored times in GMT?

SELECT NVARCHAR1, NVARCHAR6, DATEADD(hh,-8,Datetime1) as StartTime, DATEADD(hh,-8,Datetime2) AS EndTime

FROM PROWSS_Content.dbo.alluserdata

WHERE DATEADD(dd, DATEDIFF(dd,0,getdate()),0) BETWEEN...

It does during the installation

I hope I don't have to re-install....

You don't need an update in the trigger. The trigger is fired by the update. If you want to check the new values, use the inserted table. deleted, in an...

You can add a filter on the nvarchar6 for the room you want to display.

SELECT NVARCHAR1, NVARCHAR6, Datetime1, Datetime2

FROM PROWSS_Content.dbo.alluserdata

WHERE (DateTime1 >= DATEADD(dd, DATEDIFF(dd,0,getdate()),0) AND DateTime1 < DATEADD(dd, DATEDIFF(dd,0,getdate())+1,0))

...

Doesn't look like a great config. How heavy's the SQL load going to be?

SQL doesn't work well with hyperthreading. SQL 2005 and 2008 are far better than 2000 was, but...