SQL 2000 EM "features" missing in 2005 SSMS?

Question

SQL 2000 EM "features" missing in 2005 SSMS?

WayneS

SSC Guru

Points: 95460
More actions
September 30, 2008 at 9:36 pm

#125035

I have SS 2005 (Dev) on my computer. I frequently need to connect to a SS 2000 server. I've noticed a couple of things that I could do in EM (2000) that don't seem to be available in SSMS (2005).
1. In EM, when viewing the jobs, the details include additional columns: Category, Enabled, Runnable, Scheduled, Last Run Status, Next Run Date. SSMS doesn't have these columns (just name and status), but they would be very useful. Is there a way to show these columns?
2.In EM, there is a tree to click on to view the DTS packages. There isn't a corresponding tree in SSMS. How do I display the SS 2000 DTS packages?
I'm sure that there are others, but these are what I notice the most. Do I need to install the 2000 client utilities?
Thanks,
Wayne
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

WayneS (9/30/2008)
I have SS 2005 (Dev) on my computer. I frequently need to connect to a SS 2000 server. I've noticed a couple of things that I could do in EM (2000) that don't seem to be available in SSMS (2005).
1. In EM, when viewing the jobs, the details include additional columns: Category, Enabled, Runnable, Scheduled, Last Run Status, Next Run Date. SSMS doesn't have these columns (just name and status), but they would be very useful. Is there a way to show these columns?

Open the Job Activity Monitor. All those columns are there.

2.In EM, there is a tree to click on to view the DTS packages. There isn't a corresponding tree in SSMS. How do I display the SS 2000 DTS packages?

In object explorer, expand out Management -> Legacy -> Data Transformation Services

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

WayneS SSC Guru Points: 95460 More actions · Answer 2

GilaMonster (10/1/2008)
WayneS (9/30/2008)
I have SS 2005 (Dev) on my computer. I frequently need to connect to a SS 2000 server. I've noticed a couple of things that I could do in EM (2000) that don't seem to be available in SSMS (2005).
1. In EM, when viewing the jobs, the details include additional columns: Category, Enabled, Runnable, Scheduled, Last Run Status, Next Run Date. SSMS doesn't have these columns (just name and status), but they would be very useful. Is there a way to show these columns?
Open the Job Activity Monitor. All those columns are there.

Ahhh, thanks. I was clicking on the Job Activity Monitor and not seeing anything in the Object Explorer Details. Double-clicking did the job.

2.In EM, there is a tree to click on to view the DTS packages. There isn't a corresponding tree in SSMS. How do I display the SS 2000 DTS packages?
In object explorer, expand out Management -> Legacy -> Data Transformation Services

Thanks again. I believe that I expanded everything BUT that in looking for it.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2