Just adding my two cents.

.02

GO

or maybe

GO .02

Really liked the concept, but I ran into one issue. The object backupmediafamily.physical_device_name is nvarchar(260) so I changed @filename to nvarchar(260).

Thanks for the clear and concise article(s).

Larry

We all know that some can wait and some cannot wait. And there are some database changes that you would never make over a weekend.

I definitely agree. Overall, it helps to give a fresh look when Monday rolls around. And if someone drops something off late on a Friday, it'll be something to...

As a couple of comments stated, the names may not come back in the order you want. On the same server, I ran this query at different times and...

Robert,

In your diagrams, how did you get the yellow information boxes included. Did you just do multiple screen prints and then included them, or did you find some tool...

Dropped all the Foreign Keys that were associated with the Person primary key.

Dropped the Unique Clustered Index over Person.

Created the Primary Key as Clustered over Person_ID

Added the Foreign key constraints...