It looks like there is no problem; all the tables are empty.

The biggest hole in the Business Intelligence paradigm is that it assumes that there is some consumer for the system who will be able to use the information provided to...

Those error could not have come from the script on that link.

The errors are coming from some create table statements that you must have added.

Take a look at this thread:

Truncate All Tables

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65341

Just remember that everything is a cost vs. benefit decision.  It is really a matter of deciding where to spend the money, and that depends on your application.  For example,...

It would also be helpful if the Active Topics highlighted topics I have already posted on.

Your case statements produce null results when the values are equal.  Even if you correct the logic, it is more difficult to scale it up for more columns (x-way min), while the subquery...

The Active Topic problems really makes answering questions on the forums a lot harder to do, because it's so much work to locate new postings.  It's a big reason why I spend much...

I had a guy get up and leave in the middle of an interview, because he thought the job was beneath him.  A couple of years later, he came...

Either of these commands will change the SA password in 2005.  SP_PASSWORD works with earlier versions of SQL Server.

exec sp_password  @new = 'MyNewPassword' , @loginame = 'SA'

alter login SA with...

There is always a shortage of top talent for any job.

There is always a plentiful supply of second-rate talent and just plain incompetents for any job.

There is never a...

You can create a user table with a column of type SYSNAME.  I just ran this code OK in SQL 7.0, 2000, and 2005:

create table MyTableWithSYSNAME ( MySYSNAME sysname not null...

The last Friday of a given week?  Do you have weeks with more then one Friday?

Maybe I should start a new thread for this, but I find the Active Topics feature almost unusable.

If there are more than 15 topics on a page, it gives you...

A server name, database, login, user, table, view, stored procedure, function, etc. are only restricted to having names that are SYSNAME (NVARCHAR(128)).

Just because your current names...