are you getting any errors!! or simply mail is not sending??

Do you see any things weired in Process Monitor??

In addition to the books i would also recomend to check out the below article.

http://www.databasejournal.com/article.php/1503191

Hi

http://www.amazon.com/Professional-Server-Integration-Services-Programmer/dp/0764584359/ref=pd_bxgy_b_text_b/102-9869184-7952947

http://www.amazon.com/Microsoft-Server-2005-Integration-Services/dp/0672327813/ref=pd_bxgy_b_img_a/102-9869184-7952947

If Performance is not the choice then i would like to go with INTERSECT.

This is pretty straught forward and can easily extendable.

Same question..why do you want to use Telnet.

Hi Jeffrey

it looks to me he is storing all these different queries/conditions in a table.

Its not a good idea. What it is your actual requirement??

HI Gail

I agree with your statement on this. Count(*) and Count(ColumnName) are not the same :):-)

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.vom

Hi

As Steve suggested..If you were able to find teh asnwer to your question then it would be great to post the answer in this forum. It will certainly help others.

Thanks...

there is one good line article from Steve Jones on this..

http://www.sqlservercentral.com/articles/Administration/autoclosefordatabases/891/

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.com

My Asnwer is perfectly valid i.e will display 1..6.. if we execute this query in 2000.

We should have this question specific to the SQL Server version.

Thanks -- Vijaya Kadiyala

Hey Steve, it snice question..

if SQL Server runs on Unix ..Wow..

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.vom

Hi

Computed columns is very nice solution for this requirement...thanks nagraj for showing this..

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.vom

Hi

You need to use T-SQL stored procedure to do it. do you want to achieve this using SQL OR t-sql is OK.

May i know where do you have this...

Hi

You can check out the below link, tho it is from front end application.

http://www.codeproject.com/KB/database/locate_sql_servers.aspx

Btw can you tell us what is requirement!

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.vom