Are you sure that is the only query you are running? Is it part of a larger script? There's no subquery there, so the error message doesn't make sense.

-SQLBill

Try a CASE statement:

SELECT Result =

CASE WHEN address2 IS NULL

THEN address1

...

Standby puts the database into READ-ONLY. Once in Standby mode you can only restore log files.

-SQLBill

Oops. That should have been:

and then you run it with:

EXEC (@sql)

-SQLBill

I don't quite understand what you are looking for....you can only concatenate by adding two or more items.

If you don't want the WHERE clause, try this:

SELECT ISNULL([LastName], 'Lname Unknown') +...

Plus it's supposed to be:

@sql =

and then you run it with:

EXEC @sql

-SQLBill

Pretty sad isn't it? Right click on a file and select properties. You'll see when it was last updated. Cool. Now click on an .mdf file all it shows...

This is a misconception of most people. SIMPLE mode does not mean the log file is shrunk. The log file is checkpointed, then truncated. Truncating only leaves more empty...

Nothing is wrong. You are comparing 'apples and oranges'.

creation date(time): 2000/08/06(01:40:56),...

That is the CREATION DATE(Time) of the database - not the backup.

-SQLBill

Or it's the poor wording of whomever wrote the documention. It does NOT say EQUAL TO 400 characters. It says UP TO 400.

-SQLBill

You have two choices.

1. Create a new table. Then insert all the rows from the old table into the new table (INSERT tblname SELECT * etc)

or

2. Use SELECT INTO. This...

Who says it will be re-released? I've never known Microsoft to 're-release' a hotfix or Service Pack. They do additional hotfixes or Service Packs, but not a re-release.

-SQLBill

What do you mean you scheduled a job for reindexing? Do you reindex your database daily?

If you are using DBCC DBREINDEX that could be the problem. That command DROPS the...

Check out ALTER DATABASE in the BOL. You can use that command to change the collation.

-SQLBill

Does your table have those columns? Are you saving that data anywhere?

When a transaction happens on the database, a date/time isn't recorded unless you create a trigger or some other...