I tried profile, but I didn't see the login name for this user show up.

But this message was generated every one 1 minute.

I don't know the IPAddress which this user...

Thank you all!

Can you please make an example?

Thanks

Thanks, I found it. You are correct, I should look under securables for databases. I see excute is granted.

Thanks Jason for the script, I will check into it.

I know how I can set up this in SSMS. But my question is when I use SQL grant execute to that user, how can I check in SSMS if...

Great, thank you.

If I do this, is there a way later I can check from management studio, this user has been granted execute ,

Thanks

I got it, thanks all

Thanks,

There are hundreds tables in the database, I right click one, and I see Full_text-index grayed out.

I also do a query SELECT FullTextServiceProperty('IsFullTextInstalled')

It returns 0

Thanks all, this is a server that hosts vendor product for network department that manges VDI.

SO this message: There is insufficient system memory in resource pool 'internal' to run this...

[The first thing that you need to do is set the max server memory to a sensible value that will ensure SQL does not try to starve the OS. By...

Thanks all, I will give it a try

I would also like to know the exprience of DBAs who are using virtual boxes comparing with physical

Thanks

Thanks, and what does the second SQL statement mean, the one check constraint.

When you say above, do you mean the last statement in the query: ORDER BY ss.School

Or where else...

Not sure about the detail of the query. But they are research and evaluation department, I guess they used it to combine diffrent years data for some kind of reports.