How are you going to connect - with Windows authentication or with a SQL login?  In the former case, use the -T switch; in the latter use -U and -P...

It's fine to create a primary key constraint on multiple columns.  You'll want to choose your clustered index key more carefully, though.  The clustered index is by default (in most...

Change the two single quotes before select and after DMP to a double quote.

John

I'm not sure how to automatically detect if a backup device is corrupt. I haven't had the misfortune of having that happen, so I haven't  been fortunate enough to...

My guess would be yes, you'd lose it, but if you're going to go down the risky path of reusing backup devices, then you really ought to test it for...

Is N2 set up to record failed logins in the errorlog?  Are there any such messages in the errorlog?

By the way, I would not recommend installing SSMS on the database...

What have you tried?

I really can't tell what the data in your table represents.  If the table and its columns had meaningful names, that would be more helpful.  But if...

Fix the mailbox, I should think.  Have you even spoken to the Exchange (other mail systems are available) admin?

John

Yes.  That's a perfectly valid design decision if, for example, the main driver for your decision to use AGs is so that you can do patching without any downtime.

John

Could you post the stored procedure definition, please, or at least enough of it to illustrate your problem?

Thanks

John

Have you tried the COALESCE or ISNULL function?

John

Can you not just include a script to create the tables?  Alternatively, you could put the tables in the model database, so long as you don't create any other databases...

What have you tried so far?  I imagine if you replace the "th ", "nd " or "st " with " ", the CONVERT function in SSIS would be able...

There are a number of catalog views that you can query to find dependencies.  I don't have SQL Server in front of me at the moment, so I'm not sure...

I can't find anything in the documentation that confirms this, but I think sys.master_files isn't always up to date.  Therefore, if you have made any changes to the files in...