My favorite and one I've been using for the last seven years or more, is PowerDesigner from Sybase.  It's a mature and well rounded product but far from cheap.  There...

Help the next guy out, always post the solution you found, even if it was just a stupid mistake.  It's likely someone else will make the same mistake.

James.

I agree.  Why burn bridges if you don't have to.  I have always either called, sent email or snail mail thanking the interviewer for their time and encouraging them to...

Are you scripting this?  If this is just a one time occurrance then simply look at the error message and get the object name of the object that is dependent...

Since you are reseeding to a value lower than the maximum value in the table, any future DBCC CheckIdent with the reseed option will automatically reset the current seed value...

Sorry, I didn't think about the system databases when I was reading your post.  As I recall there was an "advanced" option for several of the different components when doing...

I can not help you with the part about where to change the setting during installation, but you can change it after installation.  In SQL Server Management server, Object Explorer,...

Have you tried assigning the record set to a table variable, testing for errors and then only if not an error returning the table variable as the record set?  Just...

I must be missing something but it seems that having to manually adjust the DDL of the views (which would be needed EVERY time an attribute was added) defeats the...

Dang, I'm playing second fiddle to everyone today.    Guess it's time to call it a day and head for the showers.  I'm...

Hmm, are we talking about databases on two different physical servers or two different instances of SQL Server?

If so are they linked?

It looks like your Source and Destination tables...

John: No problem, just wanted to make sure I wasn't missing something.  Also I just checked and Ryan's orginal "example" code appears to run against the northwind database, so if...

Shouldn't matter as long as you have permissions on both databases and both tables.  Make sure you referencing the objects fully, haven't misspelled any of the names:

DatabaseName.ObjectOwner.TableName.ColumnName

Usually when you see...

John: Don't you still run into the same problem of having an order by clause with an item not in the select statment?  This seems to be a reoccuring problem...

Oops! I see Mark beat me to it.  That's what I get for taking a bathroom break before finishing my post