SQL Server 2005 Tidbit 030

Happy SQL Express User

30 tidbits.  The bit “3 oh”.  Our list is not a young list anymore.

This tidbit as a result of really good questions (aka questions I didn’t have a sufficient answer for or that I wanted to research more thoroughly) at our TechNet Events in Chattanooga and Knoxville, Tennessee.  (Which reminds me… I had a great time down there!  The people I met and worked with were so nice and friendly!  Thanks for making this northern boy feel right at home!)

“You say that you can manage SQL Databases and even SQL 7 and SQL 2000 Servers with the SQL Server 2005 Management Studio.  But what can’t you do to or with those databases or servers?”

Well… I have to correct myself on that one.  At the time the plan was to be able to manage SQL 7 databases with the Management Studio.  That changed before RTM.  Currently only SQL 2000 and newer database servers can be managed using the Management Studio. 

Note that this doesn’t mean you can’t still run SQL 7 and replicate or otherwise interact with your new 2005 databases.

That question is bigger than I can really address here… Your absolutely best source of answers to your specific questions of will-this-or-that-work-in-SQL-2005 is the books online.

“But Kevin… Don’t I need to buy SQL Server 2005 to get the books online?”

No!  You can get a free, full, stand-alone downloadable and installable copy of the documentation!  Click HERE for the download page.

Got an IT question?  Give me a comment, or contact me.