sorry i meant u CAN'T join on that

i see what ur doing wrong. you can join on that. it has to be something like this however i need the talbes columns to give a good solution

SELECT Address_1

FROM...

the reason i ask because the full text index probably just hasnt populated. their tricky when u set them up sometimes. If it hasnt populated then it wont return anything

what do u mean by doesnt work. does it error? Or just doesnt return results. Is this full text index newly created?

yes. the problem is there are multiple different monitors which are just dynamic sql to check things like drive space, replication latency, data inconsistencies, ddl changes....etc. These sql strings are...

RAISERROR( '*ERROR* put your comment here and it will show in the failure message', 16, -1, @@servername ) --WITH LOG

if u uncomment the with log it will write ur message...

somewhat unrelated however i'll mention it anyways. One thing that really bothers me is how much more difficult it is to work w/ excel files in sql 2005 and sql...

That's exactly what i was looking for. Thanks Lowel. I knew there was a way via ascii but hadn't done it before. This ones going in the tool box.

Again thank...

if u dont want to do it that way u may be able to utilize the sp_foreachdb

typo

declare @sql varchar(100)

declare @db varchar(100)

exec dbadev.dbo.atest --returns 1

set @db = 'dbadev'

set @sql = 'exec '+@db+'.dbo.aTestChanger ''alter proc dbo.atest as select 100''' -- in here u would...

i have a sol however it aint the least bit pretty however i'm going home so it will have to do for today.

in this sol u will have to...

not open query. thats somethin else.

sorry of course your right.

i think u can do it w/ open querry.

I did something like this the other day and ran into this same issue. i need to look...

That's not correct. When using UNION or UNION ALL SQL server will use the alias of the first statement for all. Also, it will use the data type with the...

WOW. THIS IS FUN...CHECK THIS OUT

SELECT TOP 20

NAME

, T.object_id

,

CASE WHEN 1 = 1 THEN ( SELECT ...