Viewing 15 posts - 1 through 15 (of 594 total)
You need to install the Access Database Engine - that will install the ACE provider for OLE DB.
August 13, 2021 at 2:07 pm
Have you searched on Stack Overflow?
April 30, 2021 at 4:36 pm
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...
April 13, 2021 at 5:45 am
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...
March 12, 2021 at 4:05 pm
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?
March 12, 2021 at 2:01 am
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.
August 26, 2020 at 3:28 pm
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...
August 25, 2020 at 2:29 pm
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...
August 16, 2020 at 4:45 pm
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...
June 18, 2020 at 4:31 pm
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
May 5, 2020 at 1:50 pm
May 1, 2020 at 2:13 pm
That does not match with this example:
and the example is:
:setvar SQLCMDLOGINTIMEOUT 60
:setvar server "testserver"
:connect $(server) -l $(SQLCMDLOGINTIMEOUT)
SELECT FirstName, LastName
...there aren't any quotes. Is there a different...
March 20, 2020 at 2:40 pm
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...
February 21, 2020 at 7:57 pm
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...
February 14, 2020 at 5:03 pm
Your article https://www.scarydba.com/2009/02/25/three-kinds-of-execution-plans/ states
" You read that correctly, three kinds of execution plans. "
February 11, 2020 at 3:08 pm