Kevin Remde's IT Pro Weblog
IT Pro Resources
TechNet EventsMicrosoft Security Response CenterMicrosoft Virtual AcademyKevin’s Evaluation Download Center
IT Pro Evangelist Blogs
Blain Barton Blain Barton's Blog@BlainBar
Brian LewisMy Thoughts on IT...@BrianLewis_
Dan Stolts IT Pro Guru Blog@ITProGuru
Jennelle Crothers TechBunny@jkc137
Kevin RemdeFull of I.T.@KevinRemde
Tommy PattersonVirtually Cloud 9@Tommy_Patterson
Yung Chou Yung Chou on Hybrid Cloud@YungChou
SQL Server 2005 Tidbit 030
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.