SQLCMD: Includes with :r not working as expected - by Manuel Bauer

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 785538 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 4/25/2013 12:19:03 AM
Access Restriction Public


When using a *.sql file containing the statement ":r .\MyScript.sql" in SSMS (SQLCMD Mode) the error message "The file specified for :r command was not found." is shown.

The same *.sql file works when I execute it in the T-SQL Editor of SSDT 2010 / 2012.
Sign in to post a comment.
Posted by Alex [MSFT] on 8/7/2013 at 5:44 PM
Thank you for your feedback. The issue described in SSMS is by design. File paths specified in SSMS using the :r comamnd should be specified with an absolute path.
Posted by Microsoft on 4/26/2013 at 12:34 AM
Thank you for submitting feedback on Visual Studio and .NET Framework. Your issue has been routed to the appropriate VS development team for investigation. We will contact you if we require any additional information.
Posted by Macy [MSFT] on 4/25/2013 at 12:50 AM
Thank you for your feedback, we are currently reviewing the issue you have submitted. If this issue is urgent, please contact support directly(http://support.microsoft.com)