import wizard is probably dropping and recreating the tables;

the existing table says NOT NULL,

but whatever the wizard creates allows nulls.

pretty easy to check, compare the table definitions.

saved to file? i am pretty sure you need a system...

TexasJohn (6/8/2016)

---

Nope. C,D & E only. So there are two things going on here. The catalog is wrong and the DSN file Schedule64 was saved to the...

mapped drives like the z: drive are per user.

if you run xp_fixeddrives, do you have a Z:\ drive?

Welsh Corgi (6/8/2016)

---

I am getting a Primary Key Violation when Loading a Table.

I queried the source table and there is only one record with value of the primary key.

This does...

There's no difference ETL wise.

having SPARSE columns lets SQL optimize for mostly null values, and that's under the hood, albeit potentially a bit slower.

I think of sparse columns the same...

I found this interesting, so i duplicated your issue.

I created a couple of server triggers, backed up master and restored it as a new name [masterbackup]

even though i've connecting via...

also, check your schema changes history. if not too much time has occurred, the definition might still be in the default trace.

Sure, its part of a scripti share here that checks for all invalid objects. It triesto recompile procs, functions and views.

sp_InvalidObects.txt

yes, but it's TWO tables that are affected. you want to truncate both parameters and events. i think it might require a DELETE, as i think there is a foreign...

tiny tables.

small tables will not benefit from reindexing. only your large tables.

offhand, i think it's 1000 rows or less don't get any fragmentation benefit/results from reindexing, but we could look...

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...