Viewing 15 posts - 1,891 through 1,905 (of 26,488 total)
Okay, could you answer this question with what you have posted?
February 22, 2018 at 3:08 pm
February 22, 2018 at 3:05 pm
Could you explain, "typical users should also only access the...
February 22, 2018 at 2:57 pm
To add to this, you may actually want to look at custom database roles. Not every user needs access to every table in a database. Think about confidential data that...
February 22, 2018 at 10:59 am
Yes, db_datareader and db_datawriter could be considered the minimum. The others are not typically granted to typical users. As Jeff also said, typical users should also only access the database...
February 22, 2018 at 10:54 am
Okay, I try it on my local system and no problem. Guess I won't be of much help. Can't try it on any of our servers unfortunately as our network...
February 21, 2018 at 9:25 am
Yes, I am suggesting that your log growth (or database growth for that matter) should NOT be set to a percentage. If it is set to a percentage, each time...
February 21, 2018 at 9:21 am
February 21, 2018 at 8:19 am
Two things. One, it appears that your log growth is set to a percentage rather than a fixed size. Second, you may want to look at how many virtual log...
February 20, 2018 at 9:15 am
Just for my (and maybe others) edification, what problem(s) are you trying to solve by uninstalling and reinstalling SQL Server? If you can provide the actual error messages that is...
February 13, 2018 at 4:00 pm
I don't use a lot of batch scripts so just curious what the pause at the end of batch statements is doing.
February 13, 2018 at 3:54 pm
Why are you doing a COMMIT in your CATCH block instead of a ROLLBACK which would be more logical.
February 13, 2018 at 3:52 pm
Viewing 15 posts - 1,891 through 1,905 (of 26,488 total)