ArthurC,

Don't get me wrong, I was just making the case that is likely to fail if no generator of some sort was used

I...

As you have discovered already there is no provission for modified date in thesystem metadata. You will have to keep a log for that or use thrid party tools for...

the automatic truncation only happens if is either in simple recovery or you have a job that is doing it for you

did you restart the server ?

You have two options:

1. Call the connected users an ask them to close the connections and then run the alter database xxx set single_user with rollback immediate

2. don't be that...

to get rid of the statistics have a look at DROP STATISTICS on BOL

Cheers,

Sergiy,

I don't know exactly what are you trying to prove, on your results you must compare all the 1's or all the 2's but not 1's with 2's... ever heard...

If you can't change anything the only posible other way is so cumbersome that I'd rather tell you that there is not other way

Cheers,

Dangerous proposition to perform find and replace globally

quick example:

on the previous macro the fin was searchin for ") AS"

Problems:

1. if there is not...

That is not entirely true. If the severity level used in the RAISERROR WITH LOG is between 0 and 18 you don't need to be part of the sysadmin role...

First things first:

Adding users on the Flight is a BAD practice!!

Now if you still insist then you should do it ahead of time...

Well if spaces are important to you that's a different thing (you din't said that )

definitely the patindex method is way to go...

select REPLACE(LTRIM(REPLACE(col1, '0', ' ')), ' ', '0') AS new_col1 FROM @var

The second replace should be an space instead of an empty string for it to work!...

And if you read the poster correctly you notice that the many-to-many is already populated therefore simplifiying Sergiy's  strategy to:

SELECT l.CustomerId

FROM LINKEDTABLE l join #QproductId QP on QP.Productid =...

Sergy,

on my first post I said:

"... you should control those values in a separated table and access it through an sp  .. "

Because that stored proc serializes the access and...