Gotchas in Management Studio 2008
If you script objects in management studio 2008 be
careful its a bit forgetful. If you are using a case insensitive collation and
you have objects that refer to other objects but use different case for the
object names then when you try and script objects some might not be included. I
found this when trying to script a function and two tables. The function
referred to one of the tables but with a different case. Oddly this table didn't
get scripted.
This has been fixed and will be available in an upcoming cumulative
update.
The next gotcha is using the debugging in SSMS 2008. You have to be careful
if you cancel your debug session because the database you are connected to might
change
If you cancel a query that is in debug mode, the query window will be
connected to the database selected when the query window was opened. i.e. if you
change the database before you start debugging the database will not be the same
before and after cancelling the query,
To repro.
Open a new window this is likely to start in master
change the database
from the drop down say tempdb
type wait for delay '00:00:10'
start
debugging
cancel debugging
you will now be connected to master and not
tempdb.
Be warned.
-
