I've changed my focus to looking at XE. I was hoping capturing sql_batch_completed events would show how often the database is accessed. I set up my session to filter on...

I've worked with Audits in the past to capture different events so I'll start there.

My goal is to collect data to generate reports any time someone or something hits a...

I'll take a look at the resource governor as well. Thanks for the tip.

Previous communication to limit the number of connections hasn't worked. Some users run up to 20 at...

I'm assuming the script you are running prints the result to give you the update script which is why it is showing in the messages tab. Have you tried modifying...

It seems as though -force still looks to match and, if a match is found, then it drops and re-creates on the destination. It does not delete everything on the...

I looked into -force and, in my testing, found that it handles updates within a job so it is an acceptable solution for the update portion. I'm still hoping for...

Sounds like a small trade off in the grand scheme of things. Thanks for all the pointers.

That's a bunch of good information. Thanks for helping to clear that up, rvsc48.

Regarding scripts to keep logins, jobs, etc on the secondary up-to-date, doesn't that go against the idea...

I could easily set up a job to run every 15 minutes or so. I was more curious to see if there are any known workarounds since we aren't concerned...

I suppose I'm trying to get too granular which is leading to more work than necessary. My hope was that grant alter could be broken down into more specific permissions...

Thanks for all of the information. It was very helpful because some things I read swear by adding an identity column for the primary key regardless of what type of...

Thanks pietlinden!

That's why I posted it under the Programming --> General category. The Programming category has subcategories such as PowerShell and testing methodologies so I did't think it was too far...

Thanks for the tip ZZartin. That fixed my problem. I didn't mention that each Excel file opened will run its own macro which leads me to my next issue. If...

I'm getting back to this topic so I have a couple questions. The goal is to have only one subscription that can fire every report. Currently I see two options:

...