Thanks GSquared

You can use:

EXEC sp_Msforeachdb "USE ? SELECT * FROM sysobjects where type='TR'"

in SQL2005. I believe it works also in SQL2000.

Luiz.

Thanks, John.

I installed Autohotkey and it solved my problem.

Luiz.

Well, I see that it's not only me who has problems with "SELECT * FORM" and COALESCE.

It seems that Mgmt Studio still doesn't offer a solution for (the not only)...

Eddie,

Your suggestion allows me to execute execute something using a shortcut.

What I want is to insert a...

Thank you for your answers.

Is there a way to do it through Windows?

Luiz.

If I have a situation where Query Analyzer and .NET, both running under the same parameter values, take different time to finish (.NET is slower), can I assume that Query...

Thank you for all your answers.

I agree with what you guys told. But it seems that other people don't. See, for example, the discussion in http://www.sql-server-performance.com/tips/views_general_p1.aspx. Does...

Thank you for your fast answeres.

Luiz.

Ok. sp_LoadFromFile was just a example. I know there is not such a proc.

But Does somebody know if there is a way to load an external file to a...

Thank you guys. Those are good suggestions.

Is it possible to load an external file to a table field? something like this:

DECLARE @T TABLE (Code VARCHAR(MAX))

UPDATE @T SET Code =...

Good idea Tarvin. I will.

Luiz.

Based on the suggestions that you guys gave, I decided to create a script to test all procs and functions.

The script is quite simple. All that it does is...

Actually the original script won't work if the index is UNIQUE or if it is a NON-CLUSTERED Primary Key. I fixed these two issues in the script Below.

Luiz Barros.

set ANSI_NULLS...

Thank you for all your ideas. They have helped me to understand my options.

Upgrade Advisor seems a good solution, but it's not possible to downgrade the database to 2000 version....