Viewing 15 posts - 1 through 15 (of 101 total)
That did the trick. I'll continue to monitor it to see if it gathers the data I'm looking for.
April 17, 2020 at 5:42 pm
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...
April 17, 2020 at 3:36 pm
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...
April 16, 2020 at 5:23 pm
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...
April 10, 2020 at 5:53 pm
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...
December 31, 2019 at 7:51 pm
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...
December 20, 2019 at 7:12 pm
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...
December 20, 2019 at 6:09 pm
Sounds like a small trade off in the grand scheme of things. Thanks for all the pointers.
November 22, 2019 at 1:54 pm
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...
November 21, 2019 at 7:35 pm
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...
November 4, 2019 at 4:54 pm
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...
September 5, 2019 at 11:28 am
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...
August 20, 2019 at 11:46 am
August 9, 2019 at 12:03 pm
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...
August 8, 2019 at 7:28 pm
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...
August 7, 2019 at 3:33 pm