I think this is an even more important question now that we're entering what, bi-yearly or is it now yearly release cycles?  Does anyone know how the CAL licencing works...

...and I can confirm they've fixed the bug 🙂

Ooh, excellent.  Downloading now 🙂

Another issue with 17.2 is trying to apply Manage Compression through the menu system which won't be fixed until 17.3 (Link)
To be fair it's quicker and just...

Was the 2016 in the second option a typo or deliberate 😉  I *almost* picked that one.
Happy holiday from the UK my American friends.

Cheers Jeff! Glad I qualified that with an "AFAIA" now 🙂

Well spotted! The SUBSTRING error is occurring because I'm willing to bet that the filepath your using has a space in it somewhere - xp_cmdshell doesn't support spaces (as...

Just a slight amend to SSCrazy's script and worth a bump as it was very useful. If found that it didn't look in a particular folder as the @folder...

Bump!

Just thought I'd add my two-penneth as I was getting this exact error today and this was the first post I found on a search.

The BULK INSERT is performed from...

This is good info, and something I'll be applying to one of our BULK INSERT stored procedures. So many thanks for that.

Where you mention constraints are disabled, it would...

Another Like/Thumbs up for the use of auditing with triggers. We also find them incredibly useful for sending emails as soon as a record is inserted into a particular...

If only the world/clients were that easy to work with, IceDread 😉 I would never want to do it out of personal choice!

Lucky you if you've never had a...

Would the COALESCE be this sort of query?:

DECLARE @EmployeeList varchar(100)

SELECT @EmployeeList = COALESCE(@EmployeeList + ', ', '') + CAST(Emp_UniqueID AS varchar(5))

FROM SalesCallsEmployees

WHERE SalCal_UniqueID = 1

SELECT @EmployeeList

In my experience COALESCE can...

TurnerC,

Someone will probably point out a much better way of doing this but getting a single column of multiple records into a comma-separated string can be done thusly:

SELECT STUFF((SELECT ','...