sysforeignkeys contains all foreign key information for a database.

sp_fkeys displays FK information for a given table.

A variety of information is available using the Information_Schema views associated with each database.

I agree that this approach does not work with millions of rows, but I have addressed that by doing queries to select 1000, 10,000 and then 100,000 rows.  With these...

You could certainly use composite keys for uniqueness, but you could also use an identity field in each table with a specific range per city.  Set seed as 1000000 and...

In the case you describe, the login itself has no permissions - permissions are granted only via the fixed database role.  Permissions will appear for the login only if you...

Make your query a SELECT INTO query and then use sp_spaceused 'tablename' to determine to determine the space used by the result set.

We use it to scan email in Exchange 2000 clusters, but I don't know too much about it.

I've been a SQL Server DBA since version 1.1, and it is not possible to be an effective DBA without local admin rights on the SQL Server and full console...

First, I really have trouble getting past the requirement for a separate DB for each city.  I work in a Fortune 50 company with 100,000+ users in 30 states and...

OK, now alexnep knows how to do it, but SeekQuel had the correct answer albeit for the wrong reasons.  Adding the column by whatever means is still a clear violation...