I CAN USE LIKE AND IT WILL WORK.

i also can base on the '_' character present in the temporary object name.

I believe I can find how much temporary tables are with...

Thanks. Finally I choose to run a first batch in which I create a stored procedure and a table in master. IN that table I insert the database name, datafile,...

I like very much SQL Server but I try to be objective at the same time.

Any way I am sure that the new version will be a great success and...

In Oracle you can handle errors better but this it, Oracle is more powerful.

I will move the trigger code into the procedures because in this way I can catch all...

Let's be more precise.

My custom error = 50001

Let's say the server error raised will be 547

The procedure who update a table it works properly, something like that

declare @error int

update x...

The problem is that it must work with Oracle and SQL Server too.

FInally I take the description from SQL Server log using the idea written in this forum few days...

Finally I did something like that.

FIrst of all I build some tables in which I clasified errors from sysmasters.

I made some views with these custom tables and system and views...

have you try with

delete #temp

insert into #temp

exec sp_executesql @string

and @String is the string with that result set

?

I am exasperated because anything I do it doesn't work.

Do you interogate an image data type using contains?

If so tell me how, please.

Mabe I didn't create the indexz properly but...

The problem remains is the query of image data types.

I made a full text index over this image column in conjunction with a string column which retains the file extension...

in sysmessages you cannot clasify errors.

All you can find is an id and a description.

I ask if there are others related tables to sysmessages or other posibilities for clasify errors...

in sysmessages you cannot clasify errors.

All you can find is an id and a description.

I ask if there are others related tables to sysmessages or other posibilities for clasify errors...

select id from sysobjects where xtype = 'U'

and you will find all the user tables.

If the name is @name, the id of @name table will be the following:

select id from...

Thanks for the support.

This contains simply doesn't want to work with images although the index exista and is populated too.

Is it posible to create full text index on image columns. Search the stored procedure sp_fulltext_column and you will see that exista a parameter named @type_colname  used only for image...