and when will we be getting the book?

is one of those unique values a null?

The service named "SQL Serrver (MSSQLSERVER)" should be stopped.  I use the service screen in Computer Management; but there are several ways to stop a service.  It will automatically ask...

I see the same thing you do.  The first time I ran creates, the second I ran drops.  Perhaps it is because you really do not want drops the first...

browse the forums on this site... there is a DBA writing exactly what you are looking for and a list of people getting in line to receive it

I did not totally follow what you are trying to say; but, suggest trying to add the dateadd function to your SQL... as follows

dateadd(day, 1, checkin) AS checkout

for more details...

are you using RTM or GA software or one of the CTP versions (April, June, September).  If CTP... get the new stuff... otherwise, post your script

sounds to me like to be a good plan.  It's been a while since I have uninstalled 2000; but I would make sure that my databases were physically backed up...

I do not get a wizard... when I right click on the database name (in SSMS) I am given the "Script DB as" and then another drop down to "Create...

Okay, let's discuss what Walmart is doing to promote RFID and what RFID is going to do to more and more employees.  Last year in San Diego we had a...

not used to the acronym... thought Jamie was referring to South Side Middle School, and hadn't used code control there yet

The original poster said that delete was reseting the identifier and I said that it did not for me.  As for whether truncate is logged, or not, I will stand...

There are lots of useful scripts here

http://www.sqlservercentral.com/Scripts/

I seem to remember a comp2db script; but did not see it when I looked.  This is obviously a worthy script to have...

would not that put locks on tables that would keep other users from inserting?

This is approximately the same message that my users were getting when trying to connect without logging into the domain.  That fix follows:

When you attempt...