You can also use the Import/Export wizard to generate the table structure if you don't have the SSMS tools pack or SQL prompt installed.

Or load the data into a staging table first, and then load the original target table from the staging table.  The staging table could have all columns as varchar(100) or...

If the .ndf files are being used by Full Text Indexing you will not be able to remove the files without first dropping the full-text indexes and then removing the...

It looks to me like those .ndf files have been created by or for use with the Full Text Search feature.

The table variable was there just as an example.  I used this to put your sample data in the table to demonstrate it working.  You can replace that part with...

If you still want to extract the datetime from the file name you could use something like the code below.

DECLARE @File TABLE ([FileName] NVARCHAR(255) NOT NULL PRIMARY...

Definitely tell your boss.  They might know about the ON DELETE CASCADE foreign key constraint....

There may well be other stuff affected that you do not know about.  Tell them what...

Does DATEDIFF not work for you?

select *, DATEDIFF(DAY, StartDate, EndDate) from #T;

I'm using SSMS v 17.9.1 and have that functionality.  From the Query editor window when I enter Ctrl+U focus jumps to the dropdown list of  Available Databases.  If I hover...

Does the list of server groups returned by the first query contain the server groups you have created?

If it only contains the 5 built in groups then I'm...

It's BIDMAS these days Joe - http://www.bbc.co.uk/bitesize/ks3/maths/number/order_operation/revision/2/

Presumably you are then going to use the new parameter somewhere in the stored procedure and you are going to have to eyeball the SQL code to work out how...

A Partitioned View may work in this situation.