Yeah, you don't really need this much. I just made the design flexible for future use.

Also, the script will readily work for him...

Declare @ColumnName varchar(128), @sql varchar(8000)

 , @NonNULLColumns varchar(1000)

Set @NonNULLColumns = ''

Set @sql = ''

select Column_name INTO #NonNullColumnNames

from information_schema.columns

where 1=2

Declare ColumnNamesCursor CURSOR FOR

select distinct Column_Name from information_schema.columns

where table_name...

You'd have to loop thru all the columns and perform an aggregaite check.

I'll post back in awhile.

Got up to 600K! Like how many times did those guys try?!? Hahaha!

Hahaha! I counted the digits as Sushila said. It has seven digits!

Hihihi!

Got up to 400k on it! Haven't seen it reflected on the scoreboard though.

Merry Christmas! Cheers!

I do not have the means to mimic an installation but I assume you are looking at the Collation Settings dialogue box where you chose to either use windows collation...

Actually, the collation is simply US. English but put in a more unique ID way.

Do you need to have the exact collation setting in the server installation? Or you...

Do you have 1300 SQL 2K Servers or do you have 1300 clients connecting to a single server?

Is it a single application using the sa account? Why would you...

This is very subjective. You need to consider the size of your db, the movement of data, the number of users, the number of concurrent connection, and a lot more.

In...

Which part are you at? What do you see? What are the possible values?

Right-click your db in EM and choose properties. In the Options tab, Under Settings, CHECK the Auto Srink option.

This will automatically shrink the database leaving it with 25% free space.

If...

Hey, aren't we making this a year end tradition???

Choos Dictionary Order and accent-sensitive ONLY.

This is a fairly small database. You DO NOT NEED A FILEGROUP. You only need the filegroup if you explicitly want a particular table on the other file. In your...