Maybe you can find something on http://www.microsoft.com/technet/scriptcenter/default.mspx

SQL: http://www.microsoft.com/technet/scriptcenter/scripts/sql/default.mspx?mfr=true

Cluster: http://www.microsoft.com/technet/scriptcenter/scripts/ccs/default.mspx?mfr=true

Else I suggest you ask this on a developers forum.

There is no such way to determine last access to a database. You can set up a profiler trace that logs all connections to a database. When nothing is logged...

You can just start of the installation. It will first execute a check about the current configuration and display any errors and warnings found.

Looks like you refer to a download of March 2007. In that case download the most recent file from Microsoft site and apply this to your server and workstations.

Most people...

It doesn't matter when you downloaded the SP2. The file is still the same.

Remember to apply SP2 on the server as well on each workstation you have SQL (client) installed.

What...

I have the same IMPROVEMENT of performance from the same query running on SQL-2000 (25 minutes) and SQL-2005 (45 seconds). The query includes a DISTINCT and an ORDER BY. My...

a simple google search for --sql server performance monitor counters-- will give you a lot of hits.

for instance:

http://www.sqlservercentral.com/articles/Administering/performancemonitoringbasiccounters/1348/

http://www.windowsitlibrary.com/Content/77/15/1.html

Are you sure the changes are committed?

We had a similar problem and found the application had some issues with opening/creating different connections (SPID's). After some time the 'old' connection timed...

can you be more clear? I don't understand what you want.

If you need to change an update/insert statement you can use an INSTEAD OF trigger (see BOL for explanation).

Did you also apply SP2 for your client tools on the workstation?

Do you get the same error if you work directly on the server instead of connecting through a workstation?

I'm not sure but I think it will generate an overhead similar to Windows Performance Monitor. But it can also depend on the number of alerts that are generated.

You can also copy the table to another database (or with another name within the database). That will save you time if you have to roll back. The copy of...

You should have created a baseline (by use of counters) for you servers and database. By checking periodically the workload on the server you can notice if everything is working...

And I keep on learning new stuff 😉

The solution Seth has provided works fine. You can alter it a bit by moving the CASE from 'Colorder' to the ORDER BY if you don't want to see this...