Could not connect server from client machine

Hi all

I m a new member to this forum. Im a hardware engineer who rectify aome software related issues. Now our employees having problem with connecting their XP prof based clients to 2003 server from SQL query analyzer. I tried refresh sql server manager in server and tried restarting the server machine many times. sometimes it the client machine connects and disconnects immediately. i aslo tried changing the poll interval , but no use.

waiting for a speedy solutin... i know this is as easy query.

Hi mvramsubbu,

A warm welcome to forum

You need to digg more to get the Exact erro message refer Windows Event Viewer and SQL Server's Error Log for error and post them here so that you can get a good answer. unless you post the error message we can not help you.

Hemantgiri S. Goswami

cost estimate

Hi, all
I am writing a midware for some heterogeneous data sources, and I need to do some cost estimation to some SQL queries before they are sent to an underlying SQL server.
My question is, is it possible to get the cost estimates of queries from SQL server by some API ? If not, can I get the numbers of distinct values for attributes from the system catalogs ? and how about other statistics, such as cardinality, selectivity?

Thanks a lot!Use QUERY EXECUTION PLAN from Query analyzer and also PROFILER to assess the query process time and indexes.|||Originally posted by Satya
Use QUERY EXECUTION PLAN from Query analyzer
Yes, I can see the execution plan graphiclly displayed in Query analyzer.
But is there a way to use that information in my application?
BTW, what is PROFILER?|||use:

set showplan_all on

it will return what I think you're looking for, in table-based format, which you can iterate through and do what you wish with.|||Thanks strader.

PROFILER is tool used to trace the events on SQL Server, which is best used to know slow running queries and process.

Refer to books online for more information.|||Originally posted by Satya
Thanks strader.

PROFILER is tool used to trace the events on SQL Server, which is best used to know slow running queries and process.

Refer to books online for more information.

Thanks a lot!