a close second being pepperoni pizza..

thanks Jeff appreciated 🙂

hahahaha ok I've never visited the US but thats an interesting eye opener to cultural differences as far as breakfast go !!

no I beg to disagree, but real coffee...

Jeff Moden (4/30/2008)

---

Couple of things...

First, 'DataBase_Version' does not exist in SysObjects unless you created a table or something called 'DataBase_Version'. What is 'DataBase_Version'????

Second, look at you IF statement in...

thanks prasad.. I think that was more the cut and paste error (my fault) in putting a simplified version in the thread

ok below is full syntaxically (?) correct version...

only on my sandbox but yes 🙂

several !

si

I've had a look at sp_executesql in bol and In not sure that would help, for example the end print statement

(print @dbname) I want it to "output" from the...

I dont sorry , when google itself "dimmed the lights" for a day (at least google uk) it had that bit of info to say it didnt make a difference...

no no no .. cant survive without my own daily coffee fix

having read this I then read the article on the butterfly effect , that indeed itself has to be a butterfly effect

far to many permatations to wrap my head...

when google used a black verison for the one day it did state that it actually made no difference to energy consumption and was to more highlight people awareness

~si

foreachdatabase doesn't really work as its a subset of user databases

losing the go does work as long as I include the command to run next within the dynamic sql

e,g

set...

just to clarify when I use

set @sqlstr = 'use '+@dbname +@ctrl

+'go'

exec (@sqlstr)

I get

Server: Msg 170, Level 15, State 1, Line 2

Line 2: Incorrect...

is this something perhaps where I need something like lumigetn og explorer to look at the trans logs ?

still hitting my head of a brick wall with this

~si