Error: [Microsoft][ODBC SQL Server Driver] Timeout Expired

I am getting above error msg when I tried to run my View.
The view have 12 tables and 20 joins, which tells you the complaxcity of
the view. When run this view using Query Analyzer it gave me the above
msg as well and then i update timeout property within QA. After
updating the timeout property, the view run fine. I need the same
changes in Enterprise Manager and update timeout property for the server
but it still not working.
Help!
Many Thanks
*** Sent via Developersdex http://www.codecomments.com ***Hi
Do you have appropriate indexes on the tables involved, especially on the
columns used for the joins?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Syed" wrote:

> I am getting above error msg when I tried to run my View.
> The view have 12 tables and 20 joins, which tells you the complaxcity of
> the view. When run this view using Query Analyzer it gave me the above
> msg as well and then i update timeout property within QA. After
> updating the timeout property, the view run fine. I need the same
> changes in Enterprise Manager and update timeout property for the server
> but it still not working.
> Help!
> Many Thanks
>
> *** Sent via Developersdex http://www.codecomments.com ***
>

Error: [Microsoft][ODBC SQL Server Driver] Timeout Expired

I am getting above error msg when I tried to run my View.
The view have 12 tables and 20 joins, which tells you the complaxcity of
the view. When run this view using Query Analyzer it gave me the above
msg as well and then i update timeout property within QA. After
updating the timeout property, the view run fine. I need the same
changes in Enterprise Manager and update timeout property for the server
but it still not working.
Help!
Many Thanks
*** Sent via Developersdex http://www.developersdex.com ***Hi
Do you have appropriate indexes on the tables involved, especially on the
columns used for the joins?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Syed" wrote:
> I am getting above error msg when I tried to run my View.
> The view have 12 tables and 20 joins, which tells you the complaxcity of
> the view. When run this view using Query Analyzer it gave me the above
> msg as well and then i update timeout property within QA. After
> updating the timeout property, the view run fine. I need the same
> changes in Enterprise Manager and update timeout property for the server
> but it still not working.
> Help!
> Many Thanks
>
> *** Sent via Developersdex http://www.developersdex.com ***
>

Error: [Microsoft][ODBC SQL Server Driver] Timeout Expired

I am getting above error msg when I tried to run my View.
The view have 12 tables and 20 joins, which tells you the complaxcity of
the view. When run this view using Query Analyzer it gave me the above
msg as well and then i update timeout property within QA. After
updating the timeout property, the view run fine. I need the same
changes in Enterprise Manager and update timeout property for the server
but it still not working.
Help!
Many Thanks
*** Sent via Developersdex http://www.codecomments.com ***
Hi
Do you have appropriate indexes on the tables involved, especially on the
columns used for the joins?
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Syed" wrote:

> I am getting above error msg when I tried to run my View.
> The view have 12 tables and 20 joins, which tells you the complaxcity of
> the view. When run this view using Query Analyzer it gave me the above
> msg as well and then i update timeout property within QA. After
> updating the timeout property, the view run fine. I need the same
> changes in Enterprise Manager and update timeout property for the server
> but it still not working.
> Help!
> Many Thanks
>
> *** Sent via Developersdex http://www.codecomments.com ***
>

Error while retrieving servers

I've tried to retrieve and fill a combobox with all my servers on my network, and the program tells me he doesn't found any servers, I've got three instances running (SRV-01,SRV-02,SRV-01\SQLEXPRESS), I really don't understand. So I use

SmoApplication.EnumAvailableSqlServers(true)

to test only on my local machine and no server found ?

Here is the code I used :

this.Cursor = Cursors.WaitCursor;

DataTable dtSqlServer = SmoApplication.EnumAvailableSqlServers(true);

foreach (DataRow drServer in dtSqlServer.Rows)

{

string sServer = drServer["Server"].ToString();

if (drServer["Instance"] != null && drServer["Instance"].ToString().Length > 0)

sServer += @."\" + drServer["Instance"].ToString();

if (listDataBases.Items.IndexOf(sServer) < 0)

listDataBases.Items.Add(sServer);

//Make the local server the default

Server local = new Server();

String serverName = local.Name;

if (local.InstanceName != null && local.InstanceName.Length > 0)

serverName += @."\" + local.InstanceName;

Int32 idx = listDataBases.FindStringExact(serverName);

if (idx >= 0)

listDataBases.SelectedIndex = idx;

this.Cursor = Cursors.Default;

}

Is someone can help me thanks, I use Win XP SP2, VS 2005 team suite, SQL Server 2005 std + SP1, SQL Server 2005 express + SP 1

PS : I've tried without EnumAvailableSqlServers using a simple textbox instead, and when I enter the name of my servers it works ?!!!

I've disabled SQL Server Browser now it see my local server but not my network instances and not my SQL Express instance ?|||Hi, I guess you are messing up with instance and server of the resultset of the enumaration of the server.

http://www.sqlserver2005.de/articles/1/

HTH, jens Suessmeyer.

http://www.sqlserver2005.de