quote:

---

Is the server running? You might open the Services applet and be sure the server is started or even manually start it....

I have checked the log. Here are the final entries (the server name is torcom2, and the instance of sql is torcom2 as well, so to access it I use...

going back to my topic, does anyone know how to do what I'm asking for?

I tried the same code in a stored procedure and it didn't work. If you simply want to display deletions after the fact create a trigger that does a "select...

I'm not sure, right now it is in a trigger.

So far all I've done is create a copy of the original table (tester) and name it tester_deleted. Then I have a delete trigger on the tester table that is...

I figured this out. Microsoft's website said that sql server would install right over msde. That is not quite so. It did install, but it didn't overwrite the msde installation...

Here is the output of select @@version:

Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation ...