SQL Server 2005 is not supported on Windows 2012R2.

See

You can upload the reports using the report manager web application.

However, that needs uploading the reports one at a time.

Don't use triggers to restrict allowed data in a table. Use CHECK constraints instead.

If you insist using a trigger, use ROLLBACK to prevent the changes to the destination table. RAISERROR...

I suppose you're thinking of the sqlcmd utility.

It doesn't come with the native client installation.

It is installed with the client tools and with the database engine setup.

You can also dowload...

If you already managed to pass a whole datatable to a stored procedure, I guess you are using a Table-Valued Parameter.

Simply insert from the TVP to the destination table:

INSERT INTO...

Here's an example:

public void WriteDataTable(

String ServerInstance,

String Database,

...

The time portion of a datetime can be saved in a column of datatype "time".

The data is always saved in the internal representation, which is not 24 hours nor 12...

Queries that search for a particular transaction_id AND transtype AND transdate can take advantage from this index....

Take a look at these validation functions: http://www.sqlservercentral.com/blogs/pearlknows/2011/04/05/sql-validation-functions-cool-udf-s-to-have-handy/

I'm wondering why he wants to certify on a subject that he clearly doesn't master.

However I feel his pain: how is anybody without system/network administration skills supposed to understand how...

Open the maintenance plan and select the cleanup task.

In the properties window you should see the "Timeout" property. How is it set?

Can you please share the error message?

Now he's trying to set up a virtual lab environment and getting sysprep errors...

Looks like you have a timeout set to something other than 0 on your cleanup task in the maintenance plan. Can you confirm?

The scripts deletes old mail messages sent using...