Been quite awhile since I debugged a stored proc in SQL Server 2000. What error message(s) are you getting when you attempt to debug the procedure?

Please do not cross post. Please post all replies here.

I think you want a RIGHT OUTER JOIN the way the query is currently written.

Change the INNER JOIN to a RIGHT...

The following:

declare @ x varchar(99) -- space added between @ and x to allow code to be posted.

set @x=0x77616974666f722064656c61792027303a303a323027

select @x

returns:

Is there actually more in the logs? ...

For S & G's, change this:

INNER JOIN dbo.EventDescription ED ON DEP.EventID = ED.EventID

to this:

LEFT OUTER JOIN dbo.EventDescription ED ON DEP.EventID = ED.EventID

What do you get then?

LiteSpeed probably logs errors in its own log file(s) or the application log file, check those for additional information.

Both have pro's and con's. In the environment I work, cost saving is important, especially since they are looking at trimming 11 to 18 million from next years budget.

Your welcome.

tom parks (3/9/2010)

---

It worked Lynn! Thank you. I guess I'm a little suprised that since I'm logged in to my computer with the same userid, that SQL Server...

You need to upload the image as an avatar, then it will show next to your posts.

Reporting Services comes with SQL Server 2005, why spend more money on Crystal Reports?

I am assuming you have a local instance of SQL Server 2008 running on your workstation.

Open the SQL Server Configuration Manager. Click on the SQL Server 2008 Services. ...

Actually, IIRC, Indexed Views are available in Standard Edition, just that the QO in Enterprise Edition will automatically use an Indexed View if it is appropriate for the query.

Please post the DDL (CREATE TABLE statement) for the table, sample data (as a series of INSERT INTO statements), and the code you have written in attempting to solve your...