Bill and Homebrew01, thank you. These are the solutions I was looking for.

I have about 50 tables in the Database.

• Some are lookup-tables...

RGR'us, Is my db in in full log mode (I used the defaults of EM when I made the database)?

I'am not worried, I just want to start with a clean...

Glynne, thank you, fine to know that the DDL changes are not logged.

And the changes in the records of the lookup tables? Are...

Glynne, thank you for your answer. Let me give an explanation of what I mean.

I don't need any recovery. My database is ready and OK. It goes in production now. All...

Do you mean that the backup-defaults (when making a database with the EM, without any changes) are that no history is retained (no log)?

That's fine. Thank you.

Me too,

But having tha answers on the main page would even be better.

Now we have questions like:

Question - Worth 1 Point(s)

Category : SQL...

This one gives you the date without the time:

SELECT CONVERT(DATETIME, FLOOR( CONVERT(FLOAT, GETDATE()) ))

But, as SQL Server still has no separate date and time types ( 

Frank, you wrote:

select

 convert(char(8), dateadd( ss ,...

I tried this (always looking at your smart solutions) but got not the right answer.

I think it was...

In EM, a double click on a table gives a rough estimation of the record count.

Using SELECT COUNT(*) gives you the correct answer (the same as in QA).

Try '20050120'

This is the ISO standard way of representing a date as string.

SQLServer takes this format independant of the datetime configuration of the computer.

Cris:

If you use the ISO format for dates (yyyymmdd), not the yyyy-mm-dd format, SQL Server is not vulnerable for myd or dmy dates.

See CONVERT ISO 112 (or 12 for yymmdd)...

Frank,

Du bist WUNDERBAR.

...oops, ...

That was my problem.

I tried the whole thing in EM,

and after a refresh it shows the correct value, no zeros any more.

Btw, I'll use your "correct" date,...

Sorry, it is not an Integer field, it is a numeric (precision 10, scale 0) field.

But Convert gives still an 0 (zero)

Frank, thank you for your answer.

You asked:

Does it need to be an INT column?

The answer is Yes, because it is an old application that has to use an former DB...

Kenneth, you are right.

The presentation layer should be separated from the data layer.

But, I'am just surviving in the new world of asp.net.

Not knowing how to place the outcome of one...