8 events
when toggle format what by license comment
Sep 15 '11 at 12:28 comment added Eric Liprandi Thanks for the replies and comments. Yes, we have already used SMO for other parts. I was just looking for a possible simple fix. Right now, I can setup a mass update search and replace script that will replace encapsulated data types. That will work. Thanks.
Sep 14 '11 at 0:04 comment added garik @Aaron Bertrand I have just suggested workaround. I can suggest to write small program by using SQL Server SMO scripting and then replace all these types with []less data types :), Is it ok, now? Is this available for audience of this site? So I suggested cheap and simple one-time way.
Sep 13 '11 at 23:45 comment added Aaron Bertrand You're telling the guy to run macros against the script that management studio produces when he scripts a table, right? Or are you solving a different problem?
Sep 13 '11 at 23:43 comment added garik @Aaron Bertrand I don't know what are you talking about, really :), sorry, friend.
Sep 13 '11 at 23:38 comment added Aaron Bertrand That gets the list, now what about the actual replace? Keep in mind your audience may not know what a truth editor is, despite your link. You also have to account for keyword column names, which are quite common, such as [date], case sensitive collations, etc. I think brute force replace is a lot more tedious than you think.
Sep 13 '11 at 23:22 history edited garik CC BY-SA 3.0
added code to get sql server types
Sep 13 '11 at 22:37 comment added Aaron Bertrand The first option can be tedious if you have a lot of different types, and the second can be problematic if you actually do want or even need the square brackets around column names, table names, etc.
Sep 13 '11 at 22:00 history answered garik CC BY-SA 3.0