How to remove blank line in SSMS “Find and Replace” dialogue

Post a Comment

The answer is simple; in Management Studio go into Find and Replace (ctrl+H ) , in "Find Options" check "Use" and select "Regular Expressions".

Now, in the Find what: box enter the text ^\n

In the Replace with: box enter nothing, please don't take me literally on that and actually type the word nothing, I mean leave the text box empty.

Click Replace All.

Related Posts

There is no other posts in this category.

Post a Comment

Subscribe Our Newsletter