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.
-
Source Click Here.
Post a Comment