This will tell you the values of the key that are duplicated, and how many times they occur.  From there you can select * ...where MyKey = 'value here' to...

Please see your thread in the Backups Category.

Did you take a transaction log backup before doing your restore?

If not, then you cannot reclaim the transactions that occured after the full backup.  The transaction log is part of the...

You need to qualify your function name...   DBName.ownername.MaxLoginTime()

Steve

I've been watching this thread with interest.  I've heard the arguments that virtually ANY cursor can be re-written as a set based operation, and I guess I have to say...

I just finished typing a long reply, clicked post, and it went away.  To where, I don't know.

Anyway, the one database that we're shipping is our backup tape library, and...

What error messages are you getting when you try to attach or restore?

Exacty what steps are you taking when you try to attach? 

Have you tried copying model.mdf and modellog.ldf from...

Yes, collation sets case sensitivity among other things, character sets, etc...

In SQL_Latin1_General_CP1_CI_AS, the CI says "case insensitive".   You can change the collation of a database, but the objects currently within...

One thing to consider if you decide to change the collation on the database in question is that tempdb also has the system collation.  If you create temporary tables, they...

David,

I'm kind of surprised you haven't gotten any responses also!  To be honest, this is the first time that I have seen this thread, but it was certainly a...

It looks to me like everything went well except that you didn't use the 'WITH RECOVERY' clause on your last restore.  As Allen said, all that is required at this...

OH!  You can script a view, and get the source columns/tables that way.  In Enterprise Manager, right click, all tasks, generate SQL script.  Click "Show All", select your view from the...

Here's the procedure that I use.  It uses a control table to store the path to the backups, so I'm including the script to create that table as well.  Perhaps...

Here's the procedure that checks database file space.  It does do log files too, though.  I didn't write this one either, but I do know who did.  Some guy by...

Here's a stored procedure that will get all local drives, capacity, and free space.  I didn't write this, and I'm not sure who to give credit to.  Chances are that...