I believe there are two types of questions in interviews:

1) Questions that show the interviewers that they should hire you (what's in it for you).

2) Questions that help you to...

Jorge,

I can think of at least two possiblities:

1) The updating of information was in the middle of a transaction and when the server went down and was brought back up,...

What type of data are you talking about?  Can  the user name be stored in each row?  Can the data be partitioned per table by user?  i.e. have a dbo.mydata...

Jeff,

You're right, the data is useful for resolving the problem.  It just wasn't as useful to know whether the topic is one that you even wanted to look at.  Although,...

Just a note on format.

In the future, you may wish to put your question first and the sample data after it.  The newletter includes your subject and the first part...

One thing I ran into, if you do a snap-shot from db1 to db2 and have it "Drop the existing table and re-create it" there is a problem.  You cannot...

I am curious, what kind of data are you collecting that you need a row defined that is larger than 8060?

Steve

That works.  Thanks!

Steve

I can't get IE7 because I am still on Windows 2000.  I will use the right-click, open in new window tip.  Thanks.

Steve

The only time I ever used the script before was to reload a test database from a production database with dts and the constraints where causing problems when the data...

After looking at some of the links, am I correct in saying that a Windows 2000 Server with Sql-Server 2000 STANDARD Edition is not able to use more than 1.7...

I tried setting Auto Close on a few of my databases and my Enterprise Manager connection starting filling up my log with entries of Starting up database 'xxx'.  Is there...

I don't know about the collation but if you are trully just wanting to import the data into SQL-Server 2000, you might look at using the DTS  Import/Export Wizard.

Steve

This is one of the most silly questions I have ever seen.  If you want a column sorted for output you use ORDER BY in the SELECT statement period.

It would...

If I remember correctly, I just detached the 7 databases and attached them in 2000.  There were some login issues I had to deal as well.  It seems that there...