yes, the User is in DB_DDLADMIN, DB_DATAREAD & DB_DATAWRITER. I thought if I do the "DENY DELETE" command at the end that it would take away that privilege. If that's...

Thanks Lowell.

I created a Database Role via your recommendations and added a User to it. I've just begun testing and I'm able to DELETE a record from Tables. So the...

Thanks Chad ! That worked !

Thanks, Jocelyn!

Good tip. This is being done ONLY in Development, but, it's still a good idea.

Thanks, Greg. They require "sa" privileges on the Database. So db_owner seems to be what I need. That way they can do whatever they want within that database, and not...

To make them an ADMIN of their own database, can I assign them to the 'DB_OWNER" Database-Level Role?

Thats great news! Thanks for the quick response Jeffrey.

Great. Thanks, Andrew !

Yes, there are 7 FileGroups. Those are good recommendations.

thanks Steve !

The User Database (it's a Vendor application/database) is on the same drive as TempDB. The drives on located on a SAN configuration. And the FileGroup that the error is referencing...

My question: Is 1053 the free space in the database or the free space on the hard drive that tempDB resides on?

Answers:

- 1053MB is the FREE Space available in TempDB

-...

Thanks Brandie !

The TempDB is configured for AUTOGROWTH and there is plenty of disk space. So it's unclear as to why TempDB might be the cause of this.

I don't suppose...

Thanks for the quick response, Brandie.

Regarding the actual Hard Drive space. Yes, it has 9.57 GB of FREE space. I also looked at TempDB and it has 1053MB Space Available.

Also,...

Thanks for the quick response!

This is a new database with all new design. And the people "designing" it keep changing their minds. So there is no data yet.

I will search...

Done. A new post with info has been added.