As with so many types of testing, you must also test your "made up" questions as well. This question actually has two correct answers... made up or not... 😉

It orders by data_id assuming that you want to know the next one. Your example data was not in order by data_id, but I think you may have meant...

Oh, yes you can... put the tables in a different DB and either make "surrogate views"...

Just alter the table to add the ID column making sure that it has the IDENTITY property included.

The first 3 things I'd do is...

1. Update to sp2 and apply the latest cumulitive update (#7, I believe).

2. Turn off autoshrink. If it keeps growing, it's...

Thanks for the feedback, Gene, and good luck on your efforts! Let us know if anything comes up... maybe give us some feedback on what you ended up doing....

You've summarized the soft skills very nicely, Tony. And, I absolutely agree, David Poole's well thought out statement of "if people will voluntarily use you as the first point...

intvfan (4/26/2008)

---

I still would love to have the log not grow!!! I am loading millions of rows in several tables.

I would love to BULK load. Do you bulk...

You don't need to worry about DateFirst with the following...

[font="Courier New"] SELECT LEFT(DATENAME(dw,GETDATE()),3)

+ ', ' + CONVERT(VARCHAR,GETDATE(),106)[/font]

Have you got a server called "FindUsers"??? That's where the error is on my machine...

Sounds like someone changed a role or reassigned a role. Maybe even changed to Windows Authentication without doing the necessary work to keep privs.

I import all columns as VARCHAR and evaluate from there. You should only import to a staging table... there you can make such decisions before transferring to the final...

Nah... I screwed up.

The real key to this whole thing is...

Seggerman (4/25/2008)

---

There are times (not too often) where speed at any cost is unwise

I may be a newbie at SQL Server but in computer programming for over 3 decades

my current...

I agree... why is everyone still looking for an aggegate function and passing columns of data when Robert's very simple formula...