The data exist in the database in this format:

2010-09-23 13:02:54.000

I want to compare with a string that I get from a application:

01-02-2013

The hours , minuts and seconds are not importante.

Can...

I tried this:

convert(datetime,CONVERT(VARCHAR(10),dt_inicio,105),105) >= '01-01-2013'

AND convert(datetime,CONVERT(VARCHAR(10),dt_inicio,105),105)<= '14-03-2013'

but get the message:

can't convert char data type...

But, I need to make only one script that can run over 2000 or 2005 databases.

That script is valid only for sql server 2005, correct?

I have both realities:

Some databases are in SQL Server 2000 na others in SQL server 2005.

Can you show me the commands to do this?

Thank you

What are carriage returns?

I think that It is very dificult to implement on aview...

A view like:

select name, address from teste

I can replace the "|" character by:

select replace(name,"|",""), replace(address,"|") from teste

I would like to...

For instance:

I have replaced the character "|" on the view (in column DESC_ACTIVIDADE):

ALTER view [dbo].[vwSGCT_TO_CENTRAL_ACTIVIDADES]

as

select

ac.codctb,a.rgc as rgc,

dbo.spSGCT_NIFCTB_TO_NIF_CENTRAL(a.nifctb) as NIF,

dbo.spSGCT_NIFCTB_TO_FILIAL_NUMBER_CENTRAL(a.nifctb) as FILIAL_NUMBER,

INDEX_POS,

replace(DESC_ACTIVIDADE,'|','')DESC_ACTIVIDADE

from

actividadesac join

allctb aon ac.codctb...

I'm sorry. I didn't undesrtood your answer. Can you explain it other way?

Thanks

Maybe they have the old OS files. I will check with them.

Thanks

Thank you.

What about the restores that were made.

Can I having only a database know how many restores were made to it?

I cannot use the msdb because I want to see...

understood. I will test it.

Thank you.

Is that faster than my exemple?

I understand. I will need to think about that in the future.

For now, I would prefer to understand how can I do this.

Thank you very much for the code. I just didn't understood one thing.

My application name is GT.

I would like to audit everything that is NOT made by this applications.

For...

The cliente has a backup (1 month old...)