smiley coder, please don't tell me you used MIMS or any of my access databases for track inspections 🙂

Um, what? 🙂

In terms of SQL language (as opposed to flow control and other non-SQL elements) Jet supports nearly as rich an array of language elements as SQL Server...

Wow.  One can do nearly everything except build windows...

the database size was from dbcc shrinkfile and the size on disk through RDP

the first script didn't report any objects other than the system tables. (although it was fine for other file groups)

I haven't looked into it, but the objects it missed all...

you guys have it easy - I grew up on FoxPro and now I have maybe inherited a few hundred users connecting to SQL using an access client (it worked...

I found the issue

I had grabbed several scripts to find the objects in that filegroup - such as

SELECT OBJECT_SCHEMA_NAME(t.object_id) AS schema_name
,t.name AS table_name
,i.index_id
,i.name AS index_name
,p.partition_number
,fg.name AS filegroup_name
,FORMAT(p.rows,...

thanks dude - that got me a lot back, but it's still not right - 155GB for for 2 system tables... any other clues ?

1.5 hours to generate? there  musta be a few big tables in there

pick off the big tables and isolate them into their own publications - you can always run snapshots...

so just to clarify - so we can get you a suggestion - your report server uses 200 tables? it needs all of these ?

I'm only asking because that sounds...

what percentage of the tables do you need for your reporting? if it's 10 tables that are used in your reports then initialisation from backup might not be your best...

I've never used initialise from backup, purely on the grounds that transactional replication allows you to pick 3 or 4 tables from 100.. then choose 5 fields from each table...

eirikur, was it you that asked me to write it up? I lost track of the original post

sounds like you might have some odd characters at the end of your field - they look like spaces in notepad, but might be CR or LF (or other invisible...

sounds a bit like the way c# handles null dates  - it puts 1/1/1900 in if a date comes through as null - you have to use "dbnull" instead (or...