Viewing 15 posts - 1 through 15 (of 222 total)
I have inheritance SQL Server environment where the Server team, etc wanted to be System Admin on the SQL Server.
They might perform some upgrade.
And, I found the work-around.
February 3, 2020 at 8:28 pm
I researched and found the SQL Error logs:
Error: 18401, Severity: 14, State: 1.
Login failed for user xxxxUser. Reason: Server is in script upgrade mode. Only administrator can connect at...
February 3, 2020 at 8:21 pm
I verified that the user connect to right server and I was able to duplicate the same issues.
My Steps to duplicate:
1. Create SQL login = 'DBATest1' and assigned a password.
February 3, 2020 at 4:57 pm
February 13, 2019 at 4:49 pm
DECLARE @Batchsize INTSET @Batchsize = 50; /* Change to whatever...
February 12, 2019 at 5:10 pm
Thank you, Jonanthan. Very appreciated.
February 12, 2019 at 4:58 pm
I'm reviewing Jonathan T-sql scripts and update shortly with questions.
Many thanks for Jonathan AC Robert and everyone helps. I'm very appreciated.
February 12, 2019 at 8:50 am
I'm not hundred percent sure on the historian data that the business wanted to keep. My best guest is one year.Also, I did some research and some suggested...
February 12, 2019 at 8:44 am
I already setup SQL Audit.There are many pre-existing Audit Action Type.So far, I did not find one that can help me to monitor a user permission changed.
February 20, 2018 at 9:01 am
Is that any existing t-script that I can use to trace?
February 20, 2018 at 8:44 am
Thank you, All for your input. The feedback answered my questions.
September 19, 2017 at 7:39 am
I have a SQL Server 2008 R2 and have 100 SQL Agent jobs listed with different schedule and time stamps.
Now, I needed to add addtion 7 hours to the existing...
May 21, 2014 at 3:25 pm
The best practice should create the database and allocate database size based on proper planning and estimate grow for minimum 3 years.
I won't let the application create the database.
March 13, 2014 at 5:28 pm
Thank you and very appreciated.
March 13, 2014 at 3:31 pm
Personally, when I create the database. I will allocated enough space to grow for minimum 3 to 5 years.
However, this database applications already existed and it was the...
March 13, 2014 at 2:34 pm