The reason is that some create a table and unintentionally consume a large amount of space. Being able to prevent that from happening would force them to rethink their strategy...

So you are saying if the stored procedure should run at some point between 6 AM - 10 AM then I should schedule the SSRS process to run every 5...

I want to be able to control it at the table level. They should be able to still create/update multiple tables that add up to xGB but not do so...

Eric - That's exactly what I need and was definitely over-thinking it. Thanks everyone for the help!

If I leave those off then it works and that's where I've been getting stuck. I can see it in personal certificates in MMC but I read it needs to...

I've previously attempted to follow that but I get this error when I try to run the command New-SelfSignedCertificate -DnsName <serverFQDN> -CertStoreLocation cert:\LocalMachine\My -FriendlyName test99 -KeySpec KeyExchange 
If...

It tuns out it was a bad disk belonging to another role as part of a separate SQL instance that was causing issues with this install. Once that disk was...

I showed that to the sys admin and he gave it a try but we didn't have any luck with it.

Sue - Thank you!  I was able to get it to work using both NET START MSSQL$<instancename> /f /T3608 /mSQLCMD and .\sqlservr.exe -c -m "SQLCMD" -S <instancename>

As a...

After no luck finding meaningful error messages or finding information online, I decided to tear into the registry. It's important to note that I did also change the structure and...

sevensinz and Phil - Both are good points.  I think I'm trying to get too creative when there are simpler solutions that work just as well, if not better, than...

Thanks for all of the pointers.  It seems as though my design isn't the issue which is good.  I was following along with another thread on this board about someone...

No, it won't be every combination.  Just trying to tie together fields that are part of three separate lookup tables. So for example if the Name in the source is...

The partial example I included doesn't get into updating.  It is only for new records and, therefore, requires an insert.  Hopefully in an attempt to make better sense picture it...

The issue I'm having is fully populating the dimension.  I'm using SSIS as my ETL tool and here's the incomplete part of what I'm visualizing. 

Each record would...