Re: SQL 2005 SP1 Cluster Issue
- From: "Victor Molina" <admin@xxxxxxxxxxxx>
- Date: Thu, 27 Sep 2007 08:49:01 -0700
Yeah the problem is actually running queries via the "new" query analyzer
that is built into management studio will run indefinately when you actually
run a custom query against the db, like simple select. But if you use
management studio to look at table properties and open up dbs using the GUI
it works fine. The way i got it to work was to restart the service.... but
does anyone know why this would happen?
"Linchi Shea" <LinchiShea@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3562A844-B8C2-4A59-84DA-5094D9305C75@xxxxxxxxxxxxxxxx
I'm not sure I understand. If you can "open tables, see dbs, open
properties", you are running queries against the server.
Are you having problem querying the server via a specific client tool?
Linchi
"Victor Molina" wrote:
Have any of you ever run across a problem in SQL Server 2005 running an
active/passive cluster on Windows 2003 SP1 Enterprise, where you can
connect
to the server via Management Studio open tables, see dbs, open
properties.
Everything runs fine with the exception of being able to run queries
against
the server? Does anyone know what might cause this kind of issue to
happen?
.
- Follow-Ups:
- Re: SQL 2005 SP1 Cluster Issue
- From: Geoff N. Hiten
- Re: SQL 2005 SP1 Cluster Issue
- References:
- SQL 2005 SP1 Cluster Issue
- From: Victor Molina
- SQL 2005 SP1 Cluster Issue
- Prev by Date: SQL 2005 SP1 Cluster Issue
- Next by Date: Re: SQL 2005 SP1 Cluster Issue
- Previous by thread: SQL 2005 SP1 Cluster Issue
- Next by thread: Re: SQL 2005 SP1 Cluster Issue
- Index(es):
Relevant Pages
|
Loading
