| Author |
Topic |
|
Kristen
Test
22859 Posts |
 Posted - 2007-11-01 : 15:27:34
|
| I'm sure you've got some ... please add to the list.Just based solely on what I've been working on in the last hour:Scripting a database has bizare defaults - "Continue scripting on error" is off ... so if your database has an Encrypted object that you didn't know about the whole script will be lostCollation, Indexes, Drop existing objects, Object level permissions, Indexes, Triggers (Sprocs are in a completely different place of course ...)But these are ON : USE database statement, Unique keys (if you say No to indexes do you get Unique constraints that are defined as using an Index?)Checkboxes would be better than Yes/No dropdowns.So ... if I have some encrypted Sprocs (and remember to tick the "Continue on error" box) there is no indication that the Sprocs ever existed in the script. I then have to generate a report (separately) of the errors, cut&paste the original Sproc script into the generated script (without the benefit of a comment to tell me whereabouts to insert it - e.g. in sys_depends order)Kristen |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-01 : 15:32:04
|
| I hate the script wizard in 2005. Those yes/no dropdowns are very annoying. I use third party tools to do the scripting now since the 2005 one sucks so much.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-01 : 15:44:29
|
| "I use third party tools ..."That's a sad indictment. Which 3rd party tools are you using? |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-11-01 : 15:45:09
|
| Also, if you tell it to include the USE DATABASE section in your script and you script each object to a different file, it only puts the USE DATABASE in the first file. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-01 : 15:48:13
|
quote:
Originally posted by Kristen
"I use third party tools ..."That's a sad indictment. Which 3rd party tools are you using?
I primarily use Graz's tool. A developer here at work also created one, so we use that for his project.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-11-01 : 15:51:47
|
| I tried to download Graz's tool a few weeks ago. I think for some reason it's blocked at my work. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-11-01 : 16:06:16
|
| The SQL 2005 Import/Export wizard never works for me; I just get a error when I try to do it with no clue about what the error actually is.I use the SQL 2000 Import/Export wizard instead:start, run, dtswiz ...CODO ERGO SUM |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-01 : 16:14:59
|
| "A developer here at work also created one, so we use that for his project"Sounds like what the developer's here say about one of my projects!!!I'll have a closer look at Graz's "scripter" |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-01 : 17:09:25
|
i hate that you can't search through execution plans... but working on it.  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-01 : 17:23:19
|
The XML isn't just use on its own ... and the Text Plan is deprecated apparently  |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-01 : 17:33:35
|
| I love the Showplan XML in SQL Profiler. I can't figure out how to display the graphical plan in SSMS when the data is from a trace though.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
SQL 2005 Annoyances