What version of SQL Server are you using? If it's 2012 or higher, you can use AlwaysOn, which uses mirroring as one of it's foundational bases, but also includes High...

I'm confused...the query Chris provided does work--it brings back the '...@@2' value after inserting the 2 '%18%' values.

????

What are you expecting from the query that you...

Sue gets all the thanks--I barely know how to spell extended events, much less how to use them. 🙂
Yes, app vendors are the bane of DBAs' existence...because they do...

Thom,
I have a "silly question". Can the db_mail construct be manipulated to always send a cc of the .msg sent to the customer to a centralized mailbox? Then the...

Microsoft states this better than I can: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability-modes-always-on-availability-groups

In AlwaysOn Availability Groups, the difference between synchronous commit and asynchronous commit is how the transaction is committed to the secondary(ies) replica(s). In synchronous commit, the transaction is applied to...

Okay...now I've had more coffee. The answer can be found here: https://www.mssqltips.com/sqlservertip/2325/capture-and-store-sql-server-database-integrity-history-using-dbcc-checkdb/
It shows the data types of the returned fields in DBCC CHECKDB WITH TABLERESULTS when creating a...

Wow! I need to not post until I've had more coffee!!!
Sorry about that!! I now see what you're asking for--it's in the title of your post. UGH! More coffee!!!

Not sure what you're asking for. What columns? Are you referring to system db tables? If so, which ones? Or, stored procedures? Please help us help you. 🙂

Not sure if you're mixing up terms or just aren't stating all the pieces. When making changes in Visual Studio, are you building/publishing the report to the Report Server? If...

LOL! No worries. It's Monday. "Technically", your response was accurate...with an asterisk. SQL 2008 is no longer in mainstream support. It's now on extended support. 🙂

Anyway,

Agree with Sue as that's the best solution.
However, if you're not familiar with Extended Events, and since it is isolated to a 30 minute window of time, you could...

SQL Server 2008 and R2 is supported until 2019. Only mainstream support has ended. See this MSDN blog post:
https://blogs.msdn.microsoft.com/sqlreleaseservices/end-of-mainstream-support-for-sql-server-2008-and-sql-server-2008-r2/

@bmg002 - SQL 2008 R2 Developer Edition is not free--it is $50 (or more...). The Developer Edition of SQL Server did not begin being a free download until...

Is  SQL Server instance a named instance or default instance? If it's a named instance, you will have to include that in the connection string. If it is a default...