We have Lumigent Log Explorer that also can send alerts for those types of activities.

I don't think there should be any problems.  I have a publisher DB that is also a subscriber from another server.

Is this your scenario ?

Publisher pushes Tables A,B,C,D .... etc  ...

Yes, Miss Smarty-Pants !  I am weaning myself away from EM 

Yes, Miss Smarty-Pants !  I am weaning myself away from EM 

It can also be random. I've encountered that one day (2006-10-03), and the next day they're back to "normal" (3/10/2006). Pretty annoying when you're trying to sort by data.  Never...

What are you doing with the system databases ?  Just save & restore ?

Now we find that using Application Roles means you can't use Connection Pooling.

From SQL_Performance:  "While SQL Server application roles are handy, they can also negatively affect your application's performance. The reason...

So, for the Stored Procs, I should grant 'exec' permissions just to the App Role, not public ?

By the way, thanks very much for your help !

Yes, our lead developer is testing a few applications by having them invoke sp_setapprole, and it looks good so far.  We're planning the "one at a time" method as we...

Is there a better route ?  I'm trying to figure out the best way to fix a bad situation. Currently there's a widely known sql login that has db_owner permissions....

I was thinking of creating 3 different App Roles. 1 for read access to be added to db_datareader, 1 for read/write to be added to db_datawriter, and 1 added to...

We're thinking of using application roles, but I don't quite get how to give it permissions.  We currently have a sql login that's being used & abused. It has dbo...

Sorry ... I haven't dealt with those scenarios.

I have 2 ways I know of to search SPs

1) Script all the SPs at once into 1 huge script, then use "find"

2) query syscomments table in the DB..   ...

Thanks, but the only units of time are:   Days, weeks, months & years.   Hours should be there though