I tested the methods you suggested under SQL Server 2005 Developer Edition using a table with about 5,000,000 rows of randomly generated datetime values in the range of 1753-01-01...

This link below has my own procedure for generating a somewhat mnemonic password, as well as several others for generating random or semi-random passwords:

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

It is an interesting problem, because...

This code has a built in assumption that the year 6 is in decade 2000 to 2009.  You didn't really say what your rules are for knowing the decade, so...

The dbcc dbreindex always updates the statistics.  You can confirm this yourself by running this simple test in the pubs database, and looking at the statistics date before and after...

The check constraint is a bad idea.

Even if you fix the obvious bug in the check constraint, the contraint would prevent you from updating a row once the current system date...

One big problem with multiple databases is maintaining referential integrity.  If your Customer table is in one database and another database has a reference to the Customer table, you cannot...

I am aware there are workarounds.  However, this is not a problem that should not be happening.

I post at other forums where I have never seen this happen.  For example, I have never...

Remember that security has a number of aspects.

One is preventing people who shouldn't be able to do things from doing them.

Another is making sure that you have the data and...

I thought the puzzle was BS also and I still do.  Hence, my NZDF answer.

Someone has to have the power to manage the system and the databases, so if they don't trust you or other internal people, maybe they could contract with an...

SQL Server uses last binding, meaning that tables a stored procedure or script references do not have to exist when it is compiled.

You don't need it for the code you showed.  This runs just fine for me:

declare @count int

if exists (select 'x' from sysobjects where name = 'mytable' and type = 'u'...

Tell your boss he's going to have to find someone he trusts.

Perhaps he should consider external hosting.

I never heard of Omniforms, but it must be a very poor tool for working with a database if it can't handle a simple one to many relationship.

Since the only requirement posted was the output, this should do it.

select 104 union all select 105 order by 1

Good LUCK!!!