I am totally ignorant of FIPS codes. How are they used in practice?  For example, the post office can deliver a letter to an address in zipcode 91607 (North Hollywood,...

Thanks Rudy. I agree that MS blew it with the pdf format. CHM is much more useable.

Barkingdog

Rudy,

What a great link! I was totally unaware of it. Do you know fo one for sql 2005 also?

Bill

Thanks for the URl.

I found this presentation: http://support.microsoft.com/kb/325024 

and it answered many of my questions.

It's about sql 2000 but it's a great presentasiton. For example,  the presenter makes it clear...

Thanks to everyone for your great replies!

Bill

Thanks to everyone for the insight.

Looks like it's time to find a "consolidation" partner who has been through the "loop" before.

Bill

Not fully tested but this worked in a simple test case.

Used Sql 2005 SSIS (maybe even Sql 2000 DTS) to copy the source table (with UDT) over to a non-existant destinaiton...

I tried deleting the UDT but, as expected, Sql said I couldn't do that because the UDT was being used.

Any suggesitons how to unbind the UDT?

TIA,

Bill

Interesting point. I'll try it out.

Bill

I did a fresh install of sql 2005 and apparently don't have the Upgrade folder you referred to in your posting.

Bill

Yes,  dbcc opentran did the trick . It showed that one long, big, transaction, was running. The developer was not committing properly. When I pointed this out to him, he corrected...

SqlSpec looks good! I'll check it out.

Thanks.

Thanks to everyone for your responses! This is, in my opinion, one fantastic strings of answers!

Thanks,

Bill

Thank You,

and Yes I do have quite a mix of terms. The intended platform is sql 2005 but how should I refer to that feature of SSMS that one uses to...

I have the same problem with the Upgrade Advisor on a Windows 2000\ sql 2000 server. I have uninstalled the .NET 2.0 Framework, reinstalled it (downloaded from Microsoft's site today), but...