How can I just display the filename only in the tab? Currently I'm getting the full path in the tab.
Go to Start > Programs > Microsoft SQL Server > Service Manager. Locate the running MS SQL Server instance name (circled below in red). This is what you'll need to enter in the record.
use MyDb select * From GetFiles('C:\Temp\');
Go into Tools > Options > Text Editor > Editor Tab and Status bar, and set all tab text to false except for Include file name (set this to True). Now, when I next execute the query, the Tab text presents the new filename.
see here, make include filename true
[edit]..I misunderstood your question, there is now way that I found not to include the path[/edit]
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With