MS Office, Programming, SharePoint, Software

SharePoint Upload Failed: We're sorry, someone updated the server copy and it's not possible to upload your changes now

Confusing Microsoft Error: Someone updated the server copy?!?

For starters, I must say that this error message is cryptic and confusing to the end user, giving no real idea to the user what might be the cause.

In my case, this error cropped up in an Office 2016 setup. Specifically, the user’s computer had Office 2016 and was connecting to a SharePoint 2016 document library. The error would then show when the user attempted to check in an edited PowerPoint document.

Continue reading “SharePoint Upload Failed: We're sorry, someone updated the server copy and it's not possible to upload your changes now”
Database, Programming, SQL, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Tips, Technology, Transact-SQL, tSQL

TSQL Query to Compare Row Counts of Tables in a Local and a Remote Database

This is a fun thought exercise…. in MS SQL Server, use a linked server to compare how many rows are in each table of a backup development server with how many rows are in the actual production server. This would be especially relevant if you just did a database backup from prod into development and now want to see a few hours later on what tables the most growth is happening on…

Continue reading “TSQL Query to Compare Row Counts of Tables in a Local and a Remote Database”
Database, Programming, SQL, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Tips, Technology, Transact-SQL, tSQL

TSQL How to Query the Recovery Model and Log Location of all Databases

Seeing where each database and log lives on your server and how large the file is

If you are maintaining the databases on a server, you’ll likely want a comprehensive view of what each database’s recovery model is as well as where the database and log files are stored. An added bonus is seeing how large each file has grown so you can shrink them if necessary. You can see this all in one place using a handy query…

Continue reading “TSQL How to Query the Recovery Model and Log Location of all Databases”