Edit - Stack Overflow

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

Rev

In SSMS v18.2 (connected to Azure) the code works great. The short key returns Procedure or function 'Searchinall' expects parameter '@strFind', which was not supplied Any ideas?

gordon613
– gordon613

2020-04-01 13:39:54 +00:00
Commented Apr 1, 2020 at 13:39
@gordon613 have you typed keyword for searching while pressing short cut key on SSMS? e.g. 'Employee' and then ctrl + 4

Pedram
– Pedram

2020-04-01 13:45:21 +00:00
Commented Apr 1, 2020 at 13:45
@pedram.- thanks! I have now got it working - on my setup you need to type the keyword, then highlight it, and then press CTRL+4

gordon613
– gordon613

2020-04-01 14:02:51 +00:00
Commented Apr 1, 2020 at 14:02
1

@AngelWarrior, You might have tried it in new query and it should have worked for you. I mean no need to restart the SSMS. Thanks for providing Shortcuts path for SSMS 18.2.

Pedram
– Pedram

2020-05-12 04:24:33 +00:00
Commented May 12, 2020 at 4:24
2

One that is always missing is search through SQL job steps. I have seen quite few cases when that search was not run and we kept looking for something that was updating our data outside of all objects your query covers.

Wojciech Jakubas
– Wojciech Jakubas

2021-10-27 17:32:40 +00:00
Commented Oct 27, 2021 at 17:32

| Show 2 more comments

Correct minor typos or mistakes
Clarify meaning without changing it
Add related resources or links
Always respect the author’s intent
Don’t use edits to reply to the author

create code fences with backticks ` or tildes ~
```
like so
```
add language identifier to highlight code
```python
def function(foo):
print(foo)
```
put returns between paragraphs
for linebreak add 2 spaces at end
_italic_ or **bold**
indent code by 4 spaces
backtick escapes `like _so_`
quote by placing > at start of line
to make links (use https whenever possible)

<https://example.com>

[example](https://example.com)

<a href="https://example.com">example</a>

formatting help »
answering help »

Collectives™ on Stack Overflow