OK attached is a sample script.....:)

Thanks,

Phil.

Hi, see attached, still working on the insert scripts for the data but I have the table defs...

The ManufacturingOrderId appears multiple times as does the Products (for each build, entry...

Hi Lutz, the excel data was sample data (not reflective of the real world) but point taken I can also provide sample scripts......

With regards the expected result......

When the manufacturing order...

Thanks for taking time to review my post. I will look at the link provided.

Many Thanks,

Phil.

Hi, I ran that but received:

Msg 207, Level 16, State 1, Procedure USP_DelOldFiles, Line 12

Invalid column name 'exec master.dbo.xp_cmdshell 'dir '.

Msg 207, Level 16, State 1, Procedure USP_DelOldFiles, Line 12

Invalid...

Thanks for posting. No joy after removing the clause.

I will google for a script using CLR.

Thanks,

Phil.

Sounds like a plan.

Thanks,

Phil.

Thanks for the reply. I have xcopy working as required, just going to browse the scripts section to find a script to delete from the network share.

I will also check...

Thanks for the update.

Phil.

Hi. Thanks for the post. I resolved this yesterday on the train 🙂

=IIF(Fields!MyField.value = Nothing,True,False)

Thanks for posting.

Phil.

Thanks Grant.

Would you suggest I run a 'Reorganize Index' instead of a 'Rebuild' (I know a rebuild will reorganize anyhows). Small database. Not sure how large the data file...

Regards part 2 of my post I have found a standard report 'Disk Usage'.

It reports Auto Growth Event for the Log File on 18 occasions. Currently 98.5% is unused (I...

OK I have now resolved. I amended the profile security.

Thanks,

Phil.

I have run:

EXEC msdb.sys.sp_helprolemember 'DatabaseMailUserRole';

The account in question is a member.

I then ran:

EXEC msdb.dbo.sysmail_help_principalprofile_sp;

The account is not associated to the database mail profile (there is only one profile).

Anyone...

Hello once again Jack. That did not work, I get the feeling Visual Web Developer is not the best tool to use! My main issue is not being a coder...