Ramesh that was spot on... the only thing that was missing from your sample was a single character due to my poorly named variables:

WHEREN <= LEN( T2.DefinitionAsHTML )AND SUBSTRING( T2.DefinitionAsHTML,...

Thanks Ramesh; i'm looking it over now; i must have got a copy paste error, as it returns an erro based on something in the data;

Conversion failed when converting the...

stating the obvious, you can't have SQL server watch itself..if it goes down, it can't report. you need something running with the operating system.

I know over at sourceforge.net there is...

a SQL 2005 database, no matter what compatibility level it was set for, is still in SQL2005 format, and can't be restored or attached by previous versions of SQL.

compatibility level...

two things i could think of checking are:

check the table for a trigger...maybe a trigger is changing the bit field...

check and make sure the field isn't a calculated field, and...

this will KILL you if you are searching a database that has a table with millions of rows..

this works really well whens earching for data like you describe:

CREATE PROCEDURE UGLYSEARCH...

several ways, but information_schema is the recommended practice:

select TABLE_NAME,COLUMN_NAME,* from

INFORMATION_SCHEMA.COLUMNS

WHERE COLUMN_NAME like '%native%'

select OBJECT_NAME(id) as Table_Name,name as ColumnName from syscolumns where name like '%native%'

if you are SP2 on your 2005 instance, you could use a logon trigger:

from some ms technote:

In SQL Server 2005 Service Pack 2, there is a new feature for Logon

Triggers....

the Y should be surrounded with two single quotes, not a double quote....

a double quote implies a column name:

set @sql =

N'ALTER TABLE ' + @table_name + ' ADD "Testcolumn"...

My old link from 2005 is broken.... I'll re-find the solution and update.

for a single field, this still works fin on my server:

create function dbo.RTF2TXT(@in varchar(8000)) RETURNS varchar(8000) AS...

does it HAVE to be done instantly in a trigger?

how about a scheduled job that runs periodically(or is queued based on the trigger you are building)

in that case, you could...

pointing out the obvious here, but this might help:

the book must exist first in your dbo.books table.

after it has been added, you can realte the book to one or more...

--create database [ ] --example where i created a badly named database

select dbid,'[' + name + ']' from master.dbo.sysdatabases

results:

1 [master]

2 ...

what was the results of the query i posted?

was it 'No Name Database' literally?

did you try drop database [No Name Database]?

somebody ran this command:

--Turn system object marking on

EXEC master.dbo.sp_MS_upd_sysobj_category 1

after that is run, all commands that create objects in SQL 2000 are system objects. this is fine if you were...