Matt,

Sorry, I am not sure how to enable impersonation in IIS.

Thank you,

Norbert

Thank you for your input.

The asp code runs on Windows 2003.

Thank you.

Windows XP is on the client side.

This will be accessed through a web browser so I am not sure if the OS matters.

The server that SQL 2005 is on is...

Matt,

Thank you very much for the information.

Norbert

ALZDBA,

Thank you for your assistance. I got it working using Rank in SQL 2005

CREATE PROCEDURE class_top12 --class_top12

AS

BEGIN

SET NOCOUNT ON;

Select

CourseScheduleID, Course_Number, CourseDate, LocationID,

RANK() OVER

(PARTITION BY...

Mr. Corbett,

Thank you for this clear and great explanation!

Norbert

Thank you very much. This is very helpful!

Thank you..

I tried UPDATETEXT:

Update dbo.navigation_content

Setcontent_body = UPDATETEXT(content_body, 'tax deferred', '1031')

I get the error: Incorrect syntax near the keyword 'UPDATETEXT'.

Hi John - Thank you very much for your help. Sorry for the late response.

Your code works perfectly!

However, for some strange reason when I run your query against my real...

Hi Lynn,

The original error went away. Now I am getting these errors.

Server: Msg 207, Level 16, State 3, Line 1

Invalid column name 'course_type_id'.

Server: Msg 207, Level 16, State 1,...

Hi Lynn,

Sorry for the delayed response.

I am getting this error:

Server: Msg 107, Level 16, State 3, Line 1

The column prefix 'class' does not match with a table name or alias...

Thank you Lynn. I copied your code exactly and I got the error.

I will test John's code next.

Hi Lynn,

Thank you for your help.

I cannot figure out why I am getting this error:

Server: Msg 107, Level 16, State 3, Line 1

The column prefix 'class' does not match with...