There is no Query Analyzer - look for Management Studio. Free download of Management Server Express: http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
Yes, recreate the DB, that's a good way to learn. It will give you a task list of things to do and learn along the way. I'm so impresssed by our (Microsoft) free tools right now I can't imagine why anybody would purchase them (excluding full version of SQL Server). - Matt Small >i am a total sql server noob >sure i have always done insert, edit, updates, via cf, but never really >messed with the db. >other then to use query analyzer to look at the dba's stored procs & crud. > >any one know a good basic site on getting up to speed quickly on creating >tables [do they need there own unique db?] and the like. >going to install 2005 for the 2nd time after i get off the phone with >co-worker. > >first time i couldn't find the query analyzer, got frustrated & unistalled >it. > >really just want to try to recreate, not convert, the access db OWS from >WACK book to SQL2005 >not sure if thats the best way to learn? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:232465 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
