PS

i Used sp_helprotect to verify public role permissions

i did 🙂

that was first thing i checked....nothing

i fixed that problem -

i found an orphaned database user that did not have a server login associated with it

as soon as i...

looks good, thank you!!!

so there is no way to use just something like

sp_foreachdb ' db_name() + select count(*) fro table' ??

i know it's the wrong syntax....just for you to...

thank you

i know about this one...however

do you have an idea for specifically sp_foreachdb?

Turns out System Center Operations Manager Agent was running HealthService.exe as Local System

and firing up those 1600 connections every 15 minutes.

Here is the reference to that forum that helped....

i did setup a few filters.....nope, nothing there

i am capturing all the connections that i am interested in...

however,

not much info you can get trough sql profiler on internal\hidden\background processes

assuming that...

would you recommend any specific events that i shouild be collecting?

I did looked at the agent's jobs history...nothing there

all it had is a number of 'my' maintenance jobs, status report daily jobs, etc...

nothing that will have every 15 minutes schedule...

thank you

got it

Great solution, very convenient. Thank you for sharing it!!!

I am using sys objects catalogs\views as well as free redgate tool ‘SQL Search’….

It just bugging me WHY it is NOT showing...

Our case is more on the simple side….

We’ll have 10-20 people per group with same read only permission for all dbs.

In some cases, permissions for some members of the group...

one is sql server 2008 r2 best practice whitepaper - > use individual win accounts

and second .....i can't find it now...but do remember it was microsoft's sql 2005 BP ...

Thank you, i'll play with it.

those are not really phone numbers, it was just for example

no more rules, this is it

what and where do you think would be a performance...

One more condition here i forgot to mention...

the logic(algorithm) of number replacements should be followed as per below

we cant use some random number

the reason is appl talking to oracle as...

wait..it gets even worse 😀 , i have udf that being used in that cursor

so heres 2 queries to scramble users phone #

first is a function

second is that cursor's loop...