Mr. Shaw:

Thank you for the quick response.

Is there any reason for concern that this error shows up in 2 of the SQL Server 2000 databases?

Howard

I would like to thank Lynn, Jeffrey, and Jeff for their responses.

Howard

I finally figured out the solution.

-- List Jobs Next Run Date and Time.

-- Format Next_Run_Date MMM DD, YYYY and Next_Run_Time HH:MM AM/PM.

SELECT

...

Lowell:

Thank you for the revised script.

However, I was trying to return the two separate columns.

The next_run_date as MM/DD/YYYY

and the next_run_time as HH:MM AM/PM.

GSuared:

Thank you for the explanation.

Howard

Lowell:

Thank you for the fast reply.

The only Char(12) that I see is on the following line in the script.

convert(DATE, CAST(dbo.sysjobschedules.next_run_date AS CHAR(12)), 101) AS Next_Run_Date,

I changed this Char(12) to Char(37)...

on {Tools}{Options}{General} I have tried open in Object Explorer and Open in Object Explorer and new Query and neither works.

Object Explorer is not populated.

Please note that this problem is when...

I am having the same problem with ssms 2008 R2.

Jared:

Thank you for taking the time to help on this.

Howard

Jared:

Thank you for your response to my question.

Am I correct that in order to access the remote SQL Server 2000 databases I would perform the following steps:

In SSMS Object Explorer

File

Connect...

Ignacio:

It works.

I really want to thank you for all of your help.

It was your suggestions that ultimately lead me to the solution.

Thanks again,

Howard

Ignacio and CDeepak:

Thank you for your replies.

In reference to my question below:

However, on my application that runs on the server I had to first go the program executable on the...

CDeepak:

You said to "Run sqlserver management studio with run as administrator option and click on the option button of login screen and change network protocol option from default to TCP/IP...

Good news. When I run excel as an administrator? Shift+Right click and choose run as an administrator it works. No problems.

However, on my application that runs on the server I...

In Excel using 10.1.1.100,1433 or 10.1.1.100:1433 as the server name it will not work. In fact neither of them will connect to the server even after I click OK on...

I do not have SSMS installed on the Windows 7 computer.