This is still wrong!  The "in" should come between the table name and the file name in the bcp command.  If you try and run the command as it is...

Of course if you were building this in the real world then you probably would choose one of those field types but, as we've seen so often in the QOD, assumption...

Using LIKE 'A | Z' does not work either!  This only allows the single characters 'A', 'Z' or '|' (pipe).

It would not allow most valid values, eg 'B' or 'C'.

Using BETWEEN does not work here as you only want a single letter to be allowed in the field (if any).  Using BETWEEN would allow whole words in, eg 'test',...

I think you found the wrong article!  Try this one instead: http://support.microsoft.com/default.aspx?kbid=819264

Thanks for that link but I'm not sure if it really answers my question.

My main query is the extra step of adding the domain group to the local group.  Is this...

Can someone explain why you would need to add the domain group to a local group and give that access?  Why would you not just give access to the domain group...

No, it does still save the ISS file when you do a manual install.  It is saved in the system root folder, as it is when you choose to just...

I don't seem to have any answer options available for this question?!  Is it just me?

You should back up the master db after adding (or deleting) a user database.  SQL Server stores the list of databases in the sysdatabases table in the master db.  If...

I don't see anything wrong with this question. I ran the original CREATE TABLE script and it created the table fine, with a default value of 'Old' for the...