Well, you can't make any log backups until you've made a full backup.  Therefore if you want point-in-time recovery capability in test/dev right from the start then yes, you need...

Where are you restoring the database?  I can't think of any reason to do another backup just because you've restored from a backup of the same database.  The only thing...

I think it depends on the default language for the server, which you can find in sys.configurations.
SELECT l.name, l.alias
FROM sys.configurations c
JOIN sys.syslanguages l ON c.value_in_use...

You could set up a daily job (or whatever frequency is appropriate) to look for jobs that aren't owned by the SQL Server Agent service account, and change them so...

Anthony

Don't do either.  Not yet, at least.  If you're worried about the growth of your log file, make sure you are making frequent log backups (unless you're in...

SELECT
     id
,    Name
,    'temp1' AS SourceTable
FROM #temp1
UNION ALL
SELECT
     id
,    Name
,    'temp2'
FROM #temp2

John

This almost works, but please will you check your logic for Company 2, Item 1 - it should be 55 + 23 = 78, shouldn't it?

SELECT

Yes please - and preferably also without one of Companyname and Dataname_key.

John

I don't really understand your requirement, but in trying to get to grips with it, I noticed that you have a denormalised design and the wrong data types.  Parent_Group_ID should...

Nah, I've never smoked.  But thanks for the offer!

I wasn't necessarily suggesting that you increase the scope of your alerting.  I was just showing how you can reduce...

Please can I exchange it for a nice single malt?

The xp_readerrorlog proc takes up to two search parameters, so you can make your code more efficient, something like...