What are the challenges you face when working across database platforms? Take the survey

Auto adding WITH for table hints

marclallenmarclallen Posts: 53 Bronze 3
edited July 24, 2013 5:42PM in SQL Prompt Previous Versions
I've been looking for a solution to help me migrate from an SQL 2000 database to something to run in SQL 2012. One of the key pain points is that the WITH keyword on table hints is now required.

I was hoping that SQL Prompt, during reformatting, would be able to detect and add that in.

However, I didn't see any way to do that.

Can it do this? Or do you have another suggestion as to how to accomplish that?




  • Options
    Unfortunately the tool does not currently have this capability and I do not have any suggestions on how to best accomplish this.
    If you wish you can request this feature for this tool.
    You can direct feature requests to our uservoice forums.
    http://redgate.uservoice.com/forums/944 ... uggestions
    These forums are actively monitored by our development team and allow our users to reuest features and vote on them.
    If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release.
    Manfred Castro
    Product Support
    Red Gate Software
Sign In or Register to comment.