I'm new to posting on this site although I have worked with SQL for over 20 years I tend not to post as 9/10 times you end up in a...

his user may be a developer...

you can...

what version of SQL are you using ? Is the user running the SSIS package in Visual Studio or executing the package in SSMS ?

I don't think you can - a pivot table is created from all its source data.

Why don't you just group by Student rather than creating a separate tab for each?...

The option is there because sometimes you do need to shrink a DB. Like in your circumstances where you are deleting 6 months (I think it was) of logs that...

The guy is just trying to send a test email under his credentials...

this is why I don't post on forums... Im an experienced DBA of 20 years working for some blue-chip companies along the way.

apologies for not being clear... I "eyeballed" some...

hmm..

I have just run a shrink file and a shrink file with reorganise on a 30Gb database. The DB has lots of indexes. Just checking a couple... (both Clustered and...

1. you need to give permissions to the user that is attempting to send the mail. This is in the MSDB database, role "DatabaseMailUserRole"

EXEC msdb.dbo.sp_addrolemember @rolename = 'DatabaseMailUserRole' ,@membername =...

db_denydatareader is a database role, you will find it in <dbname>, Security, Users, <username>, Membership.

you can actually get to it a number of ways. I think what John is suggesting...

1. you need to give permissions to the user that is attempting to send the mail. This is in the MSDB database, role "DatabaseMailUserRole"

EXEC msdb.dbo.sp_addrolemember @rolename = 'DatabaseMailUserRole' ,@membername =...

🙂

A DBA's first reaction is always "Noooo" - don't shrink ! Actually, you need to consider what your DB typical growth is going to be - and can you afford...