i've done something similar.

i use sys.views and not information schemas; there's a LOT of information missing in those compatiblity views, so i avoid them like the plague.

select

'exec...

i've had to address the same problem.

McAfee usually installs on an instance of SQL Express which has a hard internal limit of ten gig on the database;

available disk space will...

TexasJohn (6/7/2016)

---

For Access I went back to my original setup.

exec sp_addlinkedserver @server=N'AccessSchedule'

,@srvproduct=N''

,@provider=N'Schedule'

,@datasrc=N'LocalServer'

exec sp_addlinkedsrvlogin AccessSchedule,False,NULL,Admin,NULL

Where Schedule is the name of a DSN file on the SQL server

Now when I run

exec...

jerking my chain or is that new in 2016?

i tried 2008/2012/2014 and below with no luck.

;WITH MyCTE([path])

AS

(

SELECT 'c:\Programmefiles\Dicument\file1.txt' UNION ALL

SELECT 'c:\Programmefiles\Dicument\Subdocument\file1.txt' UNION ALL

SELECT 'c:\Programmefiles\Dicument\Image\file1.txt' UNION...

since you've set up teh DSN and the linked server, do you get a list of tables from this command that you could then query?

exec sp_tables_ex [AccessSchedule]

you get results that...

is the datatype of the source CHAR/NCHAR and not varchar/nvarchar?

exporting char values maintains their defined length.

you'd probably want...

how does whitespace wreck the import?

importing a csv is fairly straight forward;

you could bulk insert directly to a staging table, and trim the data before it inserts into the permanent...

DennisPost (6/6/2016)

---

Hi Lowell,

Thanks for taking the time to read and reply.

That approach won't work for us as the server is set to UTC and we need to be able to...

it sounds like your UTCToLocal functions are scalar which are notoriously slow, where including some datemath columns as the calculated value would definitely be faster since it would be treated...

floats are a pain. As Luis said, the underlying value is still digits, but when being presented in the GUI or exported out again, it's a bit ugly.

when converting a...

mw112009 (6/2/2016)

---

Need help with the following UPDATE statement.

The objective here is to update one field with a | delimited statement using the rest of the fields.

This works out well....

I'm now offering certifications in SQL Fertilization. If you act now i'll offer you 50% off my already low price of $99.

A DOS attack, as in denial of service attack?

That's a very poor way to try and justify disabling that setting. I don't believe the person who developed the list knew...

not sure why you think it's a security violation.

if database mail is enabled, the only users that can use it are sysadmins of sql, or users who have been...

if the only thing the query is doing is a SELECT statement, neither the XACT_ABORT nor...