question

LeThienLam-3020 avatar image
0 Votes"
LeThienLam-3020 asked LeThienLam-3020 commented

SQL Server: Process run query:'select[dbo].[SqlServerWorksrun](1)' when restart SQL Services

Process run query:'select[dbo].[SqlServerWorksrun](1)' when restart SQL Services.
Can you help me, what's this query?
Thank!

sql-server-transact-sql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MelissaMa-msft avatar image
0 Votes"
MelissaMa-msft answered LeThienLam-3020 commented

HI @LeThienLam-3020,

Welcome to Microsoft Q&A!

It seems that [dbo].[SqlServerWorksrun] is one user-defined function from your side.

You could execute below command to receive the complete code of this function if you have enough permission.

 use master --change to another database if necessary
 go
    
 sp_helptext SqlServerWorksrun

Then you could check more details with the creator of this function if it mentions in the comment or check with your team/administrator.

Thank you for understanding!

Best regards,
Melissa


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MelissaMa-msft
I have execute and error:
Msg 15197, Level 16, State 1, Procedure sp_helptext, Line 107 [Batch Start Line 2]
There is no text for object 'SqlServerWorksrun'.

0 Votes 0 ·

HI @LeThienLam-3020,

Please try to find the function in SSMS like below:

121911-function.png

If it is not there, you could find it in other databases or login as SA to have another try.

Thank you for understanding!

Best regards,
Melissa

0 Votes 0 ·
function.png (9.2 KiB)

OK thank @MelissaMa-msft.
II 've found
but I don't understand why it's running -> affect performance server

0 Votes 0 ·
Show more comments
LeThienLam-3020 avatar image
0 Votes"
LeThienLam-3020 answered

Database: master

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.