Wow - I was out of the office for a few days and this post went crazy!

Thanks for all the input. For now, I'll stick with the join syntax. I...

CREATE ROLE Support;

GO

DENY INSERT ON DATABASE::**Name** TO Support;

DENY UPDATE ON DATABASE::**Name** TO Support;

DENY DELETE ON DATABASE::**Name** TO Support;

DENY EXECUTE ON DATABASE::**Name** TO Support;

GO

Then make them members of the role. The...

I am with you - I generally change the owner to sa for all databases. I did run into a recent exception though. We installed some third-party software that required...

We are a transportation company - operational systems as well as payroll and accounting systems. Some are third-party apps but the majority are inhouse written apps created by our developers.

Jack Corbett (2/25/2009)

---

When you say Update authority, do you mean the ability to update data or do you mean Alter [object] authority? There is a difference. If it...

These are not small tables - they have 500,000-1,000,000 rows on them so the fragmentation is a problem. If I manually run the defrag on the tables after the loads,...

The tables are 90% fragmented after the load. My fill factor is set to 80% - these tables are loaded fresh nightly but are updated/inserted/deleted from throughout the day as...

I am using the ODBC data provider. I have tried changing the RetainSameConnection property but this causes a validation error on my data reader.

For the new ADO.NET connector, I cannot...