Leaving aside the issue of what type of database principals you'd assign (but I agree entirely with the use of roles) here is the sort of code I'd use to...

While we are waiting for more information, this is how I'd tackle the problem as I understand it... (actually, I'd make sure there was a primary key before I'd do...

On 8 July 1835, Ada Byron married William King, 8th Baron...

If we accept the research published by the 'Women in Mining' organization (who would, I'm sure, disagree with...

Is this a cultural or innate difference? What research do...

I haven't tried this yet, but it says it allows you to make SQL queries to an OLE DB database

http://www.logicainformatica.it/NewSite/CosaFacciamo/DispositiviMobili/iPhone/RemoteQuery_en.html

With the iPhone, you can set up a VPN link. I haven't heard of any security hole...

Yes, if I could only use a small bluetooth keyboard with it, the thing would be nigh-on perfect.

Yes, give it a look. The original routine took 19 minutes to run. We now have entries in the 5 seconds region and each revision is pushing the speed up....

[p]Yes. I put everything in MS_Description because this is the only thing that is accessible to SSMS. I then put a YAML structure into the string so I can do...

I know it is a bit of a trip down memory lane now, but Robyn Page and I wrote an article in 2007, SQL Server Excel Workbench[/url] (http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/) describing various...

Simple Talk has just published Donald Knuth as Geek of the Week[/url] on http://www.simple-talk.com/opinion/geek-of-the-week/donald-knuth-geek-of-the-week/. Donald Knuth is in the list of people interviewed in the 'Coders at Work' book....

Now (2005/2008)

sys.extended_properties

http://msdn.microsoft.com/en-us/library/ms177541.aspx

[font="Courier New"]SELECT  SCHEMA_NAME(tbl.schema_id) AS [Table_Schema],

        tbl.name AS [Table_Name],

        clmns.name AS [Column_Name],

        p.name AS [Name],

        CAST(p.value AS SQL_VARIANT) AS [Value]

FROM    sys.tables AS tbl

        INNER JOIN sys.all_columns AS clmns ON clmns.OBJECT_ID=tbl.OBJECT_ID

        INNER JOIN sys.extended_properties AS p ON p.major_id=clmns.OBJECT_ID

                                                   AND p.minor_id=clmns.column_id

                                                  ...

Sure, this topic is more for the database developers in the community....