To add to Phil,

You can also highlight and object in the object explore and then hit F7 to open Object Explorer Details.

Once in the OED you can navigate to...

Crap.  I googled it, but didn't search for the right terms apparently.  Thanks guys.

The only way i know to transfer a query right now is to select each one individually in SSMS and use the Script View As functionality.  Is there a way...

Yeah, i think we're going to need 2 licenses b/c we want to do the automated restore and dbcc check on a mirror server.

Thanks for the...

Let's say i have this backup scenario.  I discover that my most recent backup without the table corruption is DiffA2.

With SQL Backup Pro,...

• This reply was modified 6 years, 1 month ago by Jackie Lowery.

I'll throw SQL Backup Pro in the mix. Not sure of the cost for you, but you'd have to ask. https://www.red-gate.com/products/dba/sql-backup/

However, I think Ola's scripts with some simple...

• This reply was modified 6 years, 1 month ago by Jackie Lowery.

Do they support emailing backup results or at the very least just errors?

Also, as a side-note, our current solution is Veeam Backup and Restore.  The issue with Veeam is we can't restore a backup from several days back and all transaction logs...

Is there a reason native SQL Server backups won't work?

Native compression from 2012 and higher has comparable performance to other tools now - and is the reason I no...

• This reply was modified 6 years, 1 month ago by Jackie Lowery.

I'll definitely look into extended events. Thanks.

Yes, just trying to catch a data change, who changed it, and the SQL text.

So, the user opens a vb form that has a dropdown that they choose the company from. The vb form passes the company(db) to the report.  The stored procedure is...

• This reply was modified 6 years, 4 months ago by Jackie Lowery.

As you can see, there's 3 different tables i have to query to get the company name, db name, and user name.  The query I've written so far uses sp_msforeach...

The result set will be the Company name and Company database.  I have a vb form that the users run crystal reports from.  It has a company dropdown and a...

• This reply was modified 6 years, 4 months ago by Jackie Lowery.
• This reply was modified 6 years, 4 months ago by Jackie Lowery.