July 16, 2009 at 7:18 am
We will be converting from SQL2000 to SQL2005, are there any 'DOs', 'Don'ts', or 'Gotcha'. Also, do we need any extra tool(s) for SQL2005 to view jobs/views/SP, etc.?
July 21, 2009 at 2:51 am
By default Management Studio will be installed as part of SQL 2005 installation. SSMS is a one tool which can be used to perform all sql server related activities like administration,querying. In simple words the SSMS performs both the operation of EM & QA which was in SQL 2000.
For Migration from 2000 to 2005, follow the conventioinal and adviced method given by microsoft.
July 24, 2009 at 10:24 am
Thanks for the information. Is there a cheat sheet or some guide (or a cross reference) which can help us with 2005. For example, In SQL 2000, to create/update jobs, you go to 'Management/SQL Server Agent/Jobs' and how to do same in SQL2005? Or is it very intuitive??
July 28, 2009 at 8:37 am
MSDN, which i believe the best and got all the information for both GUI and T-SQL. There are some other stuffs also available over WEB.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy