Friday, July 29, 2016
Friday, June 24, 2016
In this example, we want to delete from CustomerSales where CustomerID no longer exists in the Customers table:
DELETE dbo.CustomerSales a
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'a'.
This is the correct syntax:
Sunday, June 19, 2016
We'll see this if we try to failover the mirroring session when the databases are not in a SYNCHRONIZED state. Makes sense.. if you take a look at this post, you'll see the step before the manual failover was to resume the Mirror session. It just wasn't completely synchronized yet.
To confirm how far behind the mirror was, I ran this query on both the Principal and the Mirror.
The 'mirroring_failover_lsn' is the log sequence number that the Mirror partners use as the point of reconciliation. I waited a couple minutes and tried again. The failover completed successfully because the LSN was now the same on both the Principal and Mirror instance.
See this for more detail on sys.database_mirroring and the LSN:
Wednesday, June 15, 2016
I received this alert from one of my customer's servers today:
with that error number was found in sys.messages. If error is larger than 50000,
make sure the user-defined message is added using sp_addmessage.