That account is an Admin on the server.  Also, I am not sure where the C:\Users comes into play because I am not specifying that at all.

I would agree on the mdf and ldf file growth as stated above.  It should be to a reasonable MB growth not percentage.  The reason is if your files gets...

TRUNCATEONLY

Releases all free space at the file's end to the operating system but does not perform any page movement inside the file. The data file is shrunk only to the...

I was reading an article about MFA security a few months ago.  It was quite interesting because you'd think that is a good idea.  However, there are now hackers that...

It seems that it is changing.  With a more automated cloud version that you click, click, click and it installs it for you, automatically backs up and patches your SQL...

I have seen some databases with two transaction log files.  One on one drive with a max size and another one on a different drive.  The reason for this as...

run the select @@version and it will tell you which version you are running.

Are you meaning that when you look in Add/Remove Programs you still see things that say SQL2016?

Is the data sort of static during your DBCC run?  Do you do mass loads or deletes during that timeframe?  I would suspect your encryption process is causing it.

I guess I would be interested in knowing HOW the numbers of which versions running SQL Server were determined.  Is it a survey, some type of inventory data upload to...

In the future to help you with what are these are tables... in the past one thing that has helped me track that answer down is in Mgt Studio, click...

Yea.  He is running the show, I was just asked to look at everything and give my recommendations from a true DBA prospective.  He 'wants' that debug feature for whatever...

Thanks for the info.  I spoke with the guy that has maintained that server and he said from his workstation it works, just on the server it is not.  He...

Great.  Thanks for your help with this.  The SSMS is actually installed on the DB server, sorry, I forgot to mention that specifically.

One other thing is that all of the files should be sized exactly the same and have autogrowth set to the same size.  I personally would have the autogrowth way...

Cars are ever evolving.  To me about 2008 was the best of the best for automobiles, right before very heavy computerized and electronized everything became.  To me the keyless and...