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

We have a datacentre in London with many users in Glasgow. The Glasgow users frequently experience dire application performance while London users of the same applications have no problems....

When I eagerly walked into my current role nearly 2 years ago, I was staggered by the number of linked servers (often 5 or 6 instances of 3 different linked...

no need to enable change tracking - think of it more like...

you're still executing the function once per row

you should persist the data

ALTER TABLE dbo.ctest

ADD MLT AS dbo.sludf_AnswerTableValue(CasMachineID, CasID, '000-002', 'Code') PERSISTED

this means it is stored and not recalculated on each...