Mmmm... the question said "without spending a lot of time", so I chose the fourth option!

John

Edit: scrub that - I didn't read the Explanation properly.

• This reply was modified 1 year, 8 months ago by  John Mitchell-245523.

Was the server changed to Windows and SQL Server Authentication recently?  The change won't have taken effect unless SQL Server has been restarted since it was made.

John

Is modifying SPA so that it writes to a table whenever the linked server is used an option?  If not, have you tried setting up an audit?

John

I agree with Jeff, Johann and the author of the article.  Use char where appropriate, for performance, yes, and also for data integrity.  If an invoice number is 10 characters,...

My guess would be that since the transaction hasn't been committed, it wouldn't form part of the database backup... or at least if it did then it would be rolled...

(1) Yes

(2) It covers the state of the database at the moment the backup finishes.  There are no locks on user objects, although you may find that wait times are...

Not sure what this, is what you're looking for, but it's from the documentation for sys.server_principals:

Permissions

Any login can see their own login name, the system logins, and the fixed...

You can't just build a query on the fly like that.  You need to use dynamic SQL instead.  If you do so and you're accepting user input, be very careful...

Calculate the minutes and seconds the same way you did the years, months and days - using DATEDIFF.  Formatting of the type you describe is best done in the presentation...

Steve, what time zone will the PASS sessions take place in, please - Pacific Time?

Thanks

John

This is also didn't work for me - it said the database was inaccessible.  When I GRANTed CONNECT on the primary, it worked, though.  I wasn't happy with that, so...

Views don't take parameters, which I suspect is what @Table1 and @Table2 are in your example.  You will need to write it as a function or a stored procedure instead. ...

The tables in your query don't bear any relation to your sample data.  And please use a universal format for dates, since I got a character conversion error when I...

Sounds like you need database snapshots.

John

Check this out.  Since you're on SQL Server 2012, what you can audit may be restricted if you don't have Enterprise Edition.

John