Also, remember you can change from 8.0 to 9.0, but you cannot change from 9.0 to 8.0.

Really... Our first SQL 2005 install I created three new dbs as V 9.0,...

What service pack level are you running ?  If you are at SP1 there is a potential bug that I found that the service will not start under certain conditions....

  My brother bought a new PC at Best Buy about 6 weeks ago with Vista. He has had no problems at all with any software or Vista. The only...

We are in a cut expenses mode so going to Vista is not even a thought. About 1/3 of the companies PC's are still Win2000. We will probably be one of...

I guess I would agree with that statement. We have DB2 MF and AIX, Oracle AND SQL Server. All four of us are I guess you'd say experts in one...

My story is that I grew with our IT Dept. I started as a Data Entry clerk, became the tape librarian in the C. Room, then an operator, then Online...

I guess another part of this upgrade path is, if we spend of this time and energy to upgrade all 20+ SQL Servers on 2000 to 2005 along with rewriting DTS...

  We have over 20 production SQL Server 2000 installations currently. I have a dev box running 2005. I have found a handful of bugs in the RTM and in...

I have found it very frustrating. Attempting to use MGT studio to grant select access to 50 tables to one user... good luck... you have to do every table seperately....

I really do not think SQL Authenticated logins are going away any time soon. Otherwise MSFT would not have upgraded them in 2005 to allow for password expiring and the lockout...

Great idea, however for persistant connections via a web service or application the password cannot change or it will break connectivity.

  The problem is that most basic bundled software packages REQUIRE 'sa' to be used to do upgrades that I know of. It is very sad that software companies utilize...

I noticed that as well. I don't know of a way to override that. Odd to me as in SQL2000 you could override both data files and program files. Since...

Once you save the import/export package to msdb goto Business Intelligence Development Studio, goto file, open, open project solution.

That all sounds good, however, we have alot of software package companies that I want to apply a SP or hotfix to and they tell me frankly, you apply that and...