use greg's suggestion and run the script for the views instead!

It's beer-thirty......what a great phrase! Isn't it always that Time though ?! Enjoy!!!

yes - i did make note of proper usage - so very proud of ya!

imran - you should know that it's never easy getting away from remi...the only way to keep him off your back is by posting your final code!

you probably remember because he's (was ???) a good looking guy with a great body!!!

ok - ok - just teasing! this is why I...

not to mention shooting in the dark - thx (i think!)

Taco Bell - isn't that where they serve carne de chihuahua..

you & remi celebrate! i'll just have my banana-broccoli shake!

jumping into the fray...best i can do in a really busy day...don't shoot!

select [* wars] from [A table for one] where date...

NOT to introduce a note of sobriety to this...but it appears that no one has told Dave about 3rd world countries either...I once read a book by Paul Theroux (NOT...

I'm with you on this one Michael...though I personally don't have any hunter genes in me (deep-rooted or otherwise) I still place a lot of importance on the "tactile" -...

I'm not sure about this but I think that "sp_add_job" - @delete_level = 0 should do it....check your script and see if the @delete_level is set to 1 for the...

remi - that's the part i can't figure out...why the server still "thinks" that the table is there...i deleted & selected from sysobject w/out any problems...that's why i wanted to...

I'm still waiting for the sample data/results and ddl to test my theories though.......hope you're not holding your breath tho' - your help/presence is too invaluable...

yes - here's an example..

CREATE TABLE t2 (a char(1),

b AS CASE a

WHEN 'x' THEN 'true'

...

Now if only I could get rid of that dynamic SQL Execute, I'd really be happy......Imran is the only one who can put you out of your misery!

Yet again Learn2Live - verry nice - didn't realize that the WhereCondition was actually a column till I read what you posted...talking of which, shouldn't the select be..

SELECT @EventID =...