As I understand it, you're asking where the activity that causes the triggers to fire would be recorded, yet you don't have access to the CREATE TRIGGER statements?  It's difficult...

Can you post the DDL for one of the triggers, please, so we can see what it does?  Normally an audit would capture a specified set of events without the...

Yes, point-in-time recovery isn't possible from a log backup that includes a bulk-logged operation, but, crucially, you don't have to do a full backup when you switch back to FULL,...

Slightly more complicated, but doable.  The tally table comes to the rescue again.  We use it twice - once to get multiple characters in our random string, and once to...

It's a virtual tally table.  If you put SELECT n FROM N16 at the end of the code, and run it, you'll see what it does.  Tally tables can be...

You can simplify by using a set-based approach instead of a loop.  I used NEWID instead of CRYPT_GEN_RANDOM, although I don't suppose it makes much difference.  Not sure why you'd...

Make sure you run your index maintenance at a time when nothing else is likely to be going on.  Ensure you are taking frequent backups of your transaction log.  Consider...

Neil

I'm guessing ANSI_PADDING is OFF in SSMS but ON in whatever driver your linked server object uses to connect to the remote server.

John

If you have one database with a log_reuse_wait_desc of LOG_BACKUP and the rest with AVAILABILITY_REPLICA then I think that's your answer.  You need to make sure your AG databases have...

What upgrade do you propose to do on the database, and why does that upgrade require the database to be removed from the AG?  If the database isn't in the...

I think if you're trying to create the folder "T:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\LOG" then the path "T:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup" would already need to exist.  Have you checked that?

John

Have a read about data type precedence - it should help you to understand.

Without being familiar with your data or database structure, it's difficult to advise on the query.  Consider...

I think data type precedence is causing your nvarchar(max) string to be converted to nvarchar(8000).  Trying converting those variables to nvarchar(max) instead of nvarchar(10).  Alternatively, there's probably a dozen ways...

• This reply was modified 5 years, 10 months ago by John Mitchell-245523.

Jonathan, yes, I agree.  I wasn't suggesting giving SQL Server more memory - I was just saying that I'd be comfortable with it actually using the memory that I had...

You should try again.  Just because you don't create the account(s), it doesn't mean you can't insist on a different one for each server.  If security on just one server...