SQL Journey

A blog about real-life SQL Server Troubleshooting, providing solutions that actually work. By a SQL Server Enthusiast.

Browse by Tags

Tagged Content List
  • Blog Post: An interesting issue with SQL Server Script upgrade mode

    Here's another common issue that I've seen quite a few people run into of late. When you run a patch against SQL Server, the patch installs successfully, but on restart, SQL goes into "script upgrade mode" and you're unable to connect to it. Upon looking at the errorlog, you see something like...
  • Blog Post: An interesting issue with SQL Replication and a rogue system spid

    I recently came across this interesting issue with SQL Replication. We were trying to create a new publication, and the new publication wizard would just hang. Upon doing some investigation, we found that we were hitting the connect article mentioned here . However, the connect article mentions that...
Page 1 of 1 (2 items)