Steve,

You need to install the Access Database Engine - that will install the ACE provider for OLE DB.

HTH

Have you searched on Stack Overflow?

https://stackoverflow.com/search?q=AcuXDBC

That changed with SQL Server 2008 -  it does not automatically add “Built-In\Administrators” as SQL Server SysAdmins during the SQL Server installation. Here is more detail, plus a brief discussion...

Thanks Steve I did figure it out. IMHO the explanation could have been a bit more detailed. I can follow dm_os_performance_counters to get to the SQL Server objects, but then...

I looked at the link for dm_os_performance_counters but can't figure out where it says to use counter_name = 'User Connections'. What am I missing?

Steve, Sorry I thought that the file names were different between the two formats, and by inspecting the file name you would know which version you had.

Take a look at the Scripting.FileSystemObject in VB. I used that in an SSIS package to check the date/time stamp for an xls file before importing,  you should be able...

I had worked on an invoice that could have one more more pages, but the remittance always had to print at the bottom of the last page. SSRS was not...

You could create an SSRS report, put each query into a separate table, add page breaks for each, and then set up a subscription to email the Excel file to...

You might consider using an expression like this, which would work with BETWEEN

100 * YEAR(observ_date) + MONTH(observ_date)

e.g. today's value would be 202005

+1

That does not match with this example:

https://docs.microsoft.com/en-us/sql/ssms/scripting/sqlcmd-use-with-scripting-variables?view=sql-server-ver15

and the example is:

:setvar SQLCMDLOGINTIMEOUT 60

:setvar server "testserver"

:connect $(server) -l $(SQLCMDLOGINTIMEOUT)

USE AdventureWorks2012;

SELECT FirstName, LastName

FROM Person.Person;

...there aren't any quotes. Is there a different...

I would compare the contents to other similar data that you might have elsewhere, for consistency. For example if you are using varchar(80) for names of people or places, then...

Jeff, it sounds like the OP has a permanent table Customers, and Info is a staging table that has updates & corrections.

Joe, to quote from Kenneth Fisher's blog yesterday "Is...

Your article https://www.scarydba.com/2009/02/25/three-kinds-of-execution-plans/ states

" You read that correctly, three kinds of execution plans. "

??