Red Gate forums :: View topic - Auto adding WITH for table hints
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

Auto adding WITH for table hints

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
marclallen



Joined: 11 Jun 2007
Posts: 41

PostPosted: Tue Jul 23, 2013 9:08 pm    Post subject: Auto adding WITH for table hints Reply with quote

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?

Thanks,

Marc
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 205

PostPosted: Wed Jul 24, 2013 10:42 pm    Post subject: Reply with quote

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/94413-sql-prompt-feature-suggestions
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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group