[SQL Server 2000] How to programmatically read Merge Agent properties

Dear all,
I would like to read from SQL Server information that is presented in
Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
Agents (particularly the columns "Subscription" and "Action Time").
Which tables should I read? I checked the tables in msdb and master database
but couldn't find anything suitable. BOL and Google were of no help either.
Thank you in advance for your help.
Best regards,
AndrewTry a profiler trace and examine the source of the executed procs.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uBPvoxZAHHA.4024@.TK2MSFTNGP04.phx.gbl...
> Dear all,
> I would like to read from SQL Server information that is presented in
> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
> Agents (particularly the columns "Subscription" and "Action Time").
> Which tables should I read? I checked the tables in msdb and master
> database
> but couldn't find anything suitable. BOL and Google were of no help
> either.
> Thank you in advance for your help.
> Best regards,
> Andrew
>
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...
> Try a profiler trace and examine the source of the executed procs.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Thank you in advance for your help.
>> Best regards,
>> Andrew
Ok, I've checked, but unfortunately that is an undocumented procedure:
sp_MSenum_replication_agents @.type = 4
(type = 4 stands for merge replication agent)
Thank you for your help.
Best regards,
Andrew|||I took cursory look at the text of that proc and the called proc and it
looks to me like the source of the data is the MSmerge_history table. It's
documented in the Books Online.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uizTrebAHHA.4328@.TK2MSFTNGP03.phx.gbl...
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...
>> Try a profiler trace and examine the source of the executed procs.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \
>> Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Thank you in advance for your help.
>> Best regards,
>> Andrew
> Ok, I've checked, but unfortunately that is an undocumented procedure:
> sp_MSenum_replication_agents @.type = 4
> (type = 4 stands for merge replication agent)
> Thank you for your help.
> Best regards,
> Andrew
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:CF65CD9F-E7BA-4FAB-AC81-326BD56C2FB7@.microsoft.com...
>I took cursory look at the text of that proc and the called proc and it
>looks to me like the source of the data is the MSmerge_history table. It's
>documented in the Books Online.
[...]
> Dan Guzman
> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \
>> Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Ok, I've checked, but unfortunately that is an undocumented procedure:
>> sp_MSenum_replication_agents @.type = 4
>> (type = 4 stands for merge replication agent)
Dan,
Thank you for your help!
Best regards,
Andrew

[ODBC SQL Server Driver] Timeout Expired - How to fix

I am running SQL (Selects and Deletes) against a large
table in a database and am getting Timeout Expired. I am
using Enterprise Manager (Right Click on Table and select
Query). Is there a setting that I need to change to allow
a long running query? It works fine in the SQL Query
Analyzer.
SELECT COUNT(*) AS Expr1
FROM CallDetailThe timeout is a property of the connection to the server. Select your
instance in the Enterprise manager, select properties. Then on the
connection tab change the timeout. (Zero means infinite)
Bruce
"Michael Orechoff" <anonymous@.discussions.microsoft.com> wrote in message
news:0ee701c39d6b$f0e86750$a401280a@.phx.gbl...
> I am running SQL (Selects and Deletes) against a large
> table in a database and am getting Timeout Expired. I am
> using Enterprise Manager (Right Click on Table and select
> Query). Is there a setting that I need to change to allow
> a long running query? It works fine in the SQL Query
> Analyzer.
> SELECT COUNT(*) AS Expr1
> FROM CallDetail|||Better indexing / design so that the query doesn't take so long? Use Query
Analyzer rather than Enterprise Manager (see http://www.aspfaq.com/2455)?
You could kludge it up by increasing your timeouts, but this is like
bandaging a fever.
"Michael Orechoff" <anonymous@.discussions.microsoft.com> wrote in message
news:0ee701c39d6b$f0e86750$a401280a@.phx.gbl...
> I am running SQL (Selects and Deletes) against a large
> table in a database and am getting Timeout Expired. I am
> using Enterprise Manager (Right Click on Table and select
> Query). Is there a setting that I need to change to allow
> a long running query? It works fine in the SQL Query
> Analyzer.
> SELECT COUNT(*) AS Expr1
> FROM CallDetail

[Microsoft][SQLServer 2000 Driver for JDBC]The requested instance is either invalid or not

I have this instance running, on a server. I can connect to it using SQL
Query Analyzer as well as SQL Enterprise Manager.
But when I try to connect to it using SQL Server JDBC it gives error,
[Microsoft][SQLServer 2000 Driver for JDBC]The requested instance is either
invalid or not running.
I havent changed anything in Java code it is still the same. It was working
fine earlier. Can any one help?
I had similar problem with SQL Analyzer too but I could fix it using
cliconfg utility provided by MS.
| From: "Developers@.Enzigma" <developers@.enzigma.com>
| Subject: [Microsoft][SQLServer 2000 Driver for JDBC]The requested
instance is either invalid or not running.
| Date: Thu, 20 May 2004 16:29:47 +0530
| Lines: 14
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <eIISfmlPEHA.1340@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| NNTP-Posting-Host: 203.123.162.162
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFT NGP08.phx.gbl!TK2MSFTNGP12
.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.jdbcdriver:6044
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
| I have this instance running, on a server. I can connect to it using SQL
| Query Analyzer as well as SQL Enterprise Manager.
|
| But when I try to connect to it using SQL Server JDBC it gives error,
| [Microsoft][SQLServer 2000 Driver for JDBC]The requested instance is
either
| invalid or not running.
|
| I havent changed anything in Java code it is still the same. It was
working
| fine earlier. Can any one help?
|
| I had similar problem with SQL Analyzer too but I could fix it using
| cliconfg utility provided by MS.
|
|
|
With JDBC SP2, I can only reproduce this behavior if I have incorrectly
specified the instance name in my code. What is the name of your instance,
and can you post the code snippet that reproduces the problem? You
mentioned using cliconfg.exe to fix a similar problem with Query Analyzer.
Please run this tool again and verify that there are no aliases that point
to an invalid instance name as well.
Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

[Microsoft][ODBC SQL Server Driver]Timeout expired

I keep getting the above error when i run a sql from my web page. The query runs fine in enterprise manager. What is worng . Please help.

sql="SELECT top 1 * FROM V_ISSUE WHERE ISSUE_ID=" & issueid & " order by issue_id"

if Session("rs").State = 1 then Session("rs").Close
Session("rs").Open sql,Session("MyConn")Please Try this Code

sql="SELECT top 1 * FROM V_ISSUE WHERE ISSUE_ID=" & issueid & " order by issue_id"

Session("rs").Open sql,Session("MyConn")

Session("rs").close
Set Session("rs")=Nothing

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead(recv())DId you enable remote con

Dear All

I am using sql server 2000 SP4. Os is win2003 server. I was able to register sql server from my server using Enterprise manager. but i am not able to register the same from any client machine. pls help me

raffi

Hi,

DId you enable remote connections yet ? Have a look at my screencast on my site. You will find a tutorial to enable remote connections for your SQL Server 2005. By default this is turned off.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead(recv())

Dear All

I am using sql server 2000 SP4. Os is win2003 server. I was able to register sql server from my server using Enterprise manager. but i am not able to register the same from any client machine. pls help me

raffi

Hi,

DId you enable remote connections yet ? Have a look at my screencast on my site. You will find a tutorial to enable remote connections for your SQL Server 2005. By default this is turned off.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

[Microsoft][ODBC SQL Server Driver] Timeout expired

I am getting this error when I try and look at the Top 1000 records of a view
that I have created, in Enterprise Manager. If I copy the SQL for the View
into Query Analyzer, it returns results fine (in approx. 2 minutes). In the
Enterprise Manager Properties Advanced window, I have set Query timeout to
both 0 (never times out?) and 60000 (100 minutes?) to no avail. Any
suggestions would be greatly appreciated.
What is the exact error number and message? There are several types of
timeouts. If you are not specifying the correct parameter, it will continue
to timeout on that type.
Sincerely,
Anthony Thomas

"Gary W. Hinkel" <GaryWHinkel@.discussions.microsoft.com> wrote in message
news:E43E35ED-809B-4DF4-8869-0EE3A49F9EEF@.microsoft.com...
I am getting this error when I try and look at the Top 1000 records of a
view
that I have created, in Enterprise Manager. If I copy the SQL for the View
into Query Analyzer, it returns results fine (in approx. 2 minutes). In the
Enterprise Manager Properties Advanced window, I have set Query timeout to
both 0 (never times out?) and 60000 (100 minutes?) to no avail. Any
suggestions would be greatly appreciated.
|||Unfortunately, there is no error number, and the error message is the subject
line of this post. Also, I am not specifying any parameters at all, as this
is happening in Enterrpise Manager, Views, right-click on view, Open View,
Return Top.
"AnthonyThomas" wrote:

> What is the exact error number and message? There are several types of
> timeouts. If you are not specifying the correct parameter, it will continue
> to timeout on that type.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Gary W. Hinkel" <GaryWHinkel@.discussions.microsoft.com> wrote in message
> news:E43E35ED-809B-4DF4-8869-0EE3A49F9EEF@.microsoft.com...
> I am getting this error when I try and look at the Top 1000 records of a
> view
> that I have created, in Enterprise Manager. If I copy the SQL for the View
> into Query Analyzer, it returns results fine (in approx. 2 minutes). In the
> Enterprise Manager Properties Advanced window, I have set Query timeout to
> both 0 (never times out?) and 60000 (100 minutes?) to no avail. Any
> suggestions would be greatly appreciated.
>
>
|||If you've changed the SQLEM, Tools, Options, Advanced Tab, Query Timeout
value to 0 and you are still getting the message, then you are probably being
blocked by current processes and are getting a LOCK TIMEOUT (which is really
a Lock Wait timeout). You do not have the ability to modify the Lock Timout
setting through EM; however, you can through Query Analyzer.
The Properties, Advanced Window does not exist for SQLEM. There is a
Properties, Connections, Remote Connections area for the currently selected
database, but that property is a timeout setting for RPC queries, not SQLEM
DMO.
Sincerely,
Anthony Thomas
"Gary W. Hinkel" wrote:
[vbcol=seagreen]
> Unfortunately, there is no error number, and the error message is the subject
> line of this post. Also, I am not specifying any parameters at all, as this
> is happening in Enterrpise Manager, Views, right-click on view, Open View,
> Return Top.
> "AnthonyThomas" wrote:
|||Thanks for all your assisstance Anthony. This has cleared things up for me
as far as SQLEM is concerned (ie: I won't use it to display views, I'll use
QA instead).
I had initially thought that if I could resolve the timeout issue in SQLEM,
then the same issues in getting data into MapPoint, Excel, etc. through an
ODBC connection could be resolved as well.
Now at least, I can focus my efforts on getting the View data into
MapPoint/Excel etc.
Thanks again Anthony.
Sincerely,
Gary W. Hinkel
"AnthonyThomas" wrote:
[vbcol=seagreen]
> If you've changed the SQLEM, Tools, Options, Advanced Tab, Query Timeout
> value to 0 and you are still getting the message, then you are probably being
> blocked by current processes and are getting a LOCK TIMEOUT (which is really
> a Lock Wait timeout). You do not have the ability to modify the Lock Timout
> setting through EM; however, you can through Query Analyzer.
> The Properties, Advanced Window does not exist for SQLEM. There is a
> Properties, Connections, Remote Connections area for the currently selected
> database, but that property is a timeout setting for RPC queries, not SQLEM
> DMO.
> Sincerely,
>
> Anthony Thomas
>
> "Gary W. Hinkel" wrote:

[Microsoft][ODBC SQL Server Driver] Timeout expired

I am getting this error when I try and look at the Top 1000 records of a vie
w
that I have created, in Enterprise Manager. If I copy the SQL for the View
into Query Analyzer, it returns results fine (in approx. 2 minutes). In the
Enterprise Manager Properties Advanced window, I have set Query timeout to
both 0 (never times out?) and 60000 (100 minutes?) to no avail. Any
suggestions would be greatly appreciated.What is the exact error number and message? There are several types of
timeouts. If you are not specifying the correct parameter, it will continue
to timeout on that type.
Sincerely,
Anthony Thomas
"Gary W. Hinkel" <GaryWHinkel@.discussions.microsoft.com> wrote in message
news:E43E35ED-809B-4DF4-8869-0EE3A49F9EEF@.microsoft.com...
I am getting this error when I try and look at the Top 1000 records of a
view
that I have created, in Enterprise Manager. If I copy the SQL for the View
into Query Analyzer, it returns results fine (in approx. 2 minutes). In the
Enterprise Manager Properties Advanced window, I have set Query timeout to
both 0 (never times out?) and 60000 (100 minutes?) to no avail. Any
suggestions would be greatly appreciated.|||Unfortunately, there is no error number, and the error message is the subjec
t
line of this post. Also, I am not specifying any parameters at all, as this
is happening in Enterrpise Manager, Views, right-click on view, Open View,
Return Top.
"AnthonyThomas" wrote:

> What is the exact error number and message? There are several types of
> timeouts. If you are not specifying the correct parameter, it will contin
ue
> to timeout on that type.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Gary W. Hinkel" <GaryWHinkel@.discussions.microsoft.com> wrote in message
> news:E43E35ED-809B-4DF4-8869-0EE3A49F9EEF@.microsoft.com...
> I am getting this error when I try and look at the Top 1000 records of a
> view
> that I have created, in Enterprise Manager. If I copy the SQL for the Vie
w
> into Query Analyzer, it returns results fine (in approx. 2 minutes). In t
he
> Enterprise Manager Properties Advanced window, I have set Query timeout to
> both 0 (never times out?) and 60000 (100 minutes?) to no avail. Any
> suggestions would be greatly appreciated.
>
>|||If you've changed the SQLEM, Tools, Options, Advanced Tab, Query Timeout
value to 0 and you are still getting the message, then you are probably bein
g
blocked by current processes and are getting a LOCK TIMEOUT (which is really
a Lock Wait timeout). You do not have the ability to modify the Lock Timout
setting through EM; however, you can through Query Analyzer.
The Properties, Advanced Window does not exist for SQLEM. There is a
Properties, Connections, Remote Connections area for the currently selected
database, but that property is a timeout setting for RPC queries, not SQLEM
DMO.
Sincerely,
Anthony Thomas
"Gary W. Hinkel" wrote:
[vbcol=seagreen]
> Unfortunately, there is no error number, and the error message is the subj
ect
> line of this post. Also, I am not specifying any parameters at all, as th
is
> is happening in Enterrpise Manager, Views, right-click on view, Open View,
> Return Top.
> "AnthonyThomas" wrote:
>|||Thanks for all your assisstance Anthony. This has cleared things up for me
as far as SQLEM is concerned (ie: I won't use it to display views, I'll use
QA instead).
I had initially thought that if I could resolve the timeout issue in SQLEM,
then the same issues in getting data into MapPoint, Excel, etc. through an
ODBC connection could be resolved as well.
Now at least, I can focus my efforts on getting the View data into
MapPoint/Excel etc.
Thanks again Anthony.
Sincerely,
Gary W. Hinkel
"AnthonyThomas" wrote:
[vbcol=seagreen]
> If you've changed the SQLEM, Tools, Options, Advanced Tab, Query Timeout
> value to 0 and you are still getting the message, then you are probably be
ing
> blocked by current processes and are getting a LOCK TIMEOUT (which is real
ly
> a Lock Wait timeout). You do not have the ability to modify the Lock Timo
ut
> setting through EM; however, you can through Query Analyzer.
> The Properties, Advanced Window does not exist for SQLEM. There is a
> Properties, Connections, Remote Connections area for the currently selecte
d
> database, but that property is a timeout setting for RPC queries, not SQLE
M
> DMO.
> Sincerely,
>
> Anthony Thomas
>
> "Gary W. Hinkel" wrote:
>

[Microsoft][ODBC SQL Server Driver] Timeout expired

I am getting this error when I try and look at the Top 1000 records of a view
that I have created, in Enterprise Manager. If I copy the SQL for the View
into Query Analyzer, it returns results fine (in approx. 2 minutes). In the
Enterprise Manager Properties Advanced window, I have set Query timeout to
both 0 (never times out?) and 60000 (100 minutes?) to no avail. Any
suggestions would be greatly appreciated.What is the exact error number and message? There are several types of
timeouts. If you are not specifying the correct parameter, it will continue
to timeout on that type.
Sincerely,
Anthony Thomas
"Gary W. Hinkel" <GaryWHinkel@.discussions.microsoft.com> wrote in message
news:E43E35ED-809B-4DF4-8869-0EE3A49F9EEF@.microsoft.com...
I am getting this error when I try and look at the Top 1000 records of a
view
that I have created, in Enterprise Manager. If I copy the SQL for the View
into Query Analyzer, it returns results fine (in approx. 2 minutes). In the
Enterprise Manager Properties Advanced window, I have set Query timeout to
both 0 (never times out?) and 60000 (100 minutes?) to no avail. Any
suggestions would be greatly appreciated.|||Unfortunately, there is no error number, and the error message is the subject
line of this post. Also, I am not specifying any parameters at all, as this
is happening in Enterrpise Manager, Views, right-click on view, Open View,
Return Top.
"AnthonyThomas" wrote:
> What is the exact error number and message? There are several types of
> timeouts. If you are not specifying the correct parameter, it will continue
> to timeout on that type.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Gary W. Hinkel" <GaryWHinkel@.discussions.microsoft.com> wrote in message
> news:E43E35ED-809B-4DF4-8869-0EE3A49F9EEF@.microsoft.com...
> I am getting this error when I try and look at the Top 1000 records of a
> view
> that I have created, in Enterprise Manager. If I copy the SQL for the View
> into Query Analyzer, it returns results fine (in approx. 2 minutes). In the
> Enterprise Manager Properties Advanced window, I have set Query timeout to
> both 0 (never times out?) and 60000 (100 minutes?) to no avail. Any
> suggestions would be greatly appreciated.
>
>|||If you've changed the SQLEM, Tools, Options, Advanced Tab, Query Timeout
value to 0 and you are still getting the message, then you are probably being
blocked by current processes and are getting a LOCK TIMEOUT (which is really
a Lock Wait timeout). You do not have the ability to modify the Lock Timout
setting through EM; however, you can through Query Analyzer.
The Properties, Advanced Window does not exist for SQLEM. There is a
Properties, Connections, Remote Connections area for the currently selected
database, but that property is a timeout setting for RPC queries, not SQLEM
DMO.
Sincerely,
Anthony Thomas
"Gary W. Hinkel" wrote:
> Unfortunately, there is no error number, and the error message is the subject
> line of this post. Also, I am not specifying any parameters at all, as this
> is happening in Enterrpise Manager, Views, right-click on view, Open View,
> Return Top.
> "AnthonyThomas" wrote:
> > What is the exact error number and message? There are several types of
> > timeouts. If you are not specifying the correct parameter, it will continue
> > to timeout on that type.
> >
> > Sincerely,
> >
> >
> > Anthony Thomas
> >
> >
> > --
> >
> > "Gary W. Hinkel" <GaryWHinkel@.discussions.microsoft.com> wrote in message
> > news:E43E35ED-809B-4DF4-8869-0EE3A49F9EEF@.microsoft.com...
> > I am getting this error when I try and look at the Top 1000 records of a
> > view
> > that I have created, in Enterprise Manager. If I copy the SQL for the View
> > into Query Analyzer, it returns results fine (in approx. 2 minutes). In the
> > Enterprise Manager Properties Advanced window, I have set Query timeout to
> > both 0 (never times out?) and 60000 (100 minutes?) to no avail. Any
> > suggestions would be greatly appreciated.
> >
> >
> >|||Thanks for all your assisstance Anthony. This has cleared things up for me
as far as SQLEM is concerned (ie: I won't use it to display views, I'll use
QA instead).
I had initially thought that if I could resolve the timeout issue in SQLEM,
then the same issues in getting data into MapPoint, Excel, etc. through an
ODBC connection could be resolved as well.
Now at least, I can focus my efforts on getting the View data into
MapPoint/Excel etc.
Thanks again Anthony.
Sincerely,
Gary W. Hinkel
"AnthonyThomas" wrote:
> If you've changed the SQLEM, Tools, Options, Advanced Tab, Query Timeout
> value to 0 and you are still getting the message, then you are probably being
> blocked by current processes and are getting a LOCK TIMEOUT (which is really
> a Lock Wait timeout). You do not have the ability to modify the Lock Timout
> setting through EM; however, you can through Query Analyzer.
> The Properties, Advanced Window does not exist for SQLEM. There is a
> Properties, Connections, Remote Connections area for the currently selected
> database, but that property is a timeout setting for RPC queries, not SQLEM
> DMO.
> Sincerely,
>
> Anthony Thomas
>
> "Gary W. Hinkel" wrote:
> > Unfortunately, there is no error number, and the error message is the subject
> > line of this post. Also, I am not specifying any parameters at all, as this
> > is happening in Enterrpise Manager, Views, right-click on view, Open View,
> > Return Top.
> >
> > "AnthonyThomas" wrote:
> >
> > > What is the exact error number and message? There are several types of
> > > timeouts. If you are not specifying the correct parameter, it will continue
> > > to timeout on that type.
> > >
> > > Sincerely,
> > >
> > >
> > > Anthony Thomas
> > >
> > >
> > > --
> > >
> > > "Gary W. Hinkel" <GaryWHinkel@.discussions.microsoft.com> wrote in message
> > > news:E43E35ED-809B-4DF4-8869-0EE3A49F9EEF@.microsoft.com...
> > > I am getting this error when I try and look at the Top 1000 records of a
> > > view
> > > that I have created, in Enterprise Manager. If I copy the SQL for the View
> > > into Query Analyzer, it returns results fine (in approx. 2 minutes). In the
> > > Enterprise Manager Properties Advanced window, I have set Query timeout to
> > > both 0 (never times out?) and 60000 (100 minutes?) to no avail. Any
> > > suggestions would be greatly appreciated.
> > >
> > >
> > >

[Microsoft][ODBC SQL Server Driver] Invalid cursor stateevery time I save in enterprise ma

Hi,
every time I save after a change in any table through enterprise nmanager
I receive this error:
[Microsoft][ODBC SQL Server Driver] Invalid cursor state
If I generate a script instead-of saving directly
and if I execute this script through the query analyzer all works fine!
My windows 2003 is english
my SQL Server is french
my default language is french
I've found the same error on another server which is in the same config.
any idea?
thanks.
Jerome.
> every time I save after a change in any table through enterprise nmanager
> I receive this error:
> [Microsoft][ODBC SQL Server Driver] Invalid cursor state
So why not use scripts in Query Analyzer? IMHO, there are only a few cases
where Enterprise Manager should be used...
http://www.aspfaq.com/2515
http://www.aspfaq.com/2455
http://www.aspfaq.com/
(Reverse address to reply.)
|||enterprise manager is easy to use.
When I update or add a column, I can do this very quickly in enterprise
manager
using query analyzer is an overhead for me :-)
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23hCrneyyEHA.2624@.TK2MSFTNGP11.phx.gbl...
> So why not use scripts in Query Analyzer? IMHO, there are only a few
> cases
> where Enterprise Manager should be used...
> http://www.aspfaq.com/2515
> http://www.aspfaq.com/2455
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
|||This is over your head?
ALTER TABLE <tablename> ADD <columnname> <DATATYPE>
http://www.aspfaq.com/
(Reverse address to reply.)
"Jj" <willgart_A_@.hotmail_A_.com> wrote in message
news:eat5rhyyEHA.4028@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> enterprise manager is easy to use.
> When I update or add a column, I can do this very quickly in enterprise
> manager
> using query analyzer is an overhead for me :-)
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:%23hCrneyyEHA.2624@.TK2MSFTNGP11.phx.gbl...
nmanager
>
|||yep
specially when you have a lot of columns to change/add/remove :-)
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ebp1VjyyEHA.2540@.TK2MSFTNGP09.phx.gbl...
> This is over your head?
> ALTER TABLE <tablename> ADD <columnname> <DATATYPE>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eat5rhyyEHA.4028@.TK2MSFTNGP15.phx.gbl...
> nmanager
>
|||> yep
> specially when you have a lot of columns to change/add/remove :-)
Okay, so is there something especially painful about learning them? It
certainly can't HURT you to have this knowledge; surely someday you will
have to connect to SQL Server without using a GUI as a crutch...
|||There are different combinations of service packs that lend
themselves to having this error more often - e.g between
8.00.0859 and 8.00.0875 you can get the error more often,
version 8.00.0927 or no SP3 version 8.00.0194 you don't,
etc.
The bottom line is what Aaron keeps telling you - you should
be using Query Analyzer for this type of thing. It was
designed more for this type of activity.
-Sue
On Mon, 15 Nov 2004 11:17:34 -0500, "Jj"
<willgart_A_@.hotmail_A_.com> wrote:

>yep
>specially when you have a lot of columns to change/add/remove :-)
>"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
>news:ebp1VjyyEHA.2540@.TK2MSFTNGP09.phx.gbl...
>
|||I've the version 859
what is the 927 version? SP4? intermediate release?
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:isshp0916fff78e8q6i0rn7n1lh5a0meen@.4ax.com...
> There are different combinations of service packs that lend
> themselves to having this error more often - e.g between
> 8.00.0859 and 8.00.0875 you can get the error more often,
> version 8.00.0927 or no SP3 version 8.00.0194 you don't,
> etc.
> The bottom line is what Aaron keeps telling you - you should
> be using Query Analyzer for this type of thing. It was
> designed more for this type of activity.
> -Sue
> On Mon, 15 Nov 2004 11:17:34 -0500, "Jj"
> <willgart_A_@.hotmail_A_.com> wrote:
>
|||> what is the 927 version? SP4? intermediate release?
Hotfix. Only certain ones are available without contacting PSS directly.
http://www.aspfaq.com/2160
http://www.aspfaq.com/
(Reverse address to reply.)
|||Hot fix for the following:
http://support.microsoft.com/?kbid=839688
But then you will be managing hot fixes based upon not
wanting to use Query Analyzer for writing T-SQL to maintain
your databases. Doesn't seem like a good path to go down.
So if another slammer comes out, would your company want you
to patch it and use T-SQL for table changes or would they
want you to leave the box vulnerable so you could use
Enterprise Manager to make all your table changes?
-Sue
On Mon, 15 Nov 2004 13:40:43 -0500, "Jj"
<willgart_A_@.hotmail_A_.com> wrote:

>I've the version 859
>what is the 927 version? SP4? intermediate release?
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:isshp0916fff78e8q6i0rn7n1lh5a0meen@.4ax.com.. .
>

[Microsoft][ODBC SQL Server Driver] Invalid cursor stateevery time I save in enterprise ma

Hi,
every time I save after a change in any table through enterprise nmanager
I receive this error:
[Microsoft][ODBC SQL Server Driver] Invalid cursor state
If I generate a script instead-of saving directly
and if I execute this script through the query analyzer all works fine!
My windows 2003 is english
my SQL Server is french
my default language is french
I've found the same error on another server which is in the same config.
any idea?
thanks.
Jerome.> every time I save after a change in any table through enterprise nmanager
> I receive this error:
> [Microsoft][ODBC SQL Server Driver] Invalid cursor state
So why not use scripts in Query Analyzer? IMHO, there are only a few cases
where Enterprise Manager should be used...
http://www.aspfaq.com/2515
http://www.aspfaq.com/2455
--
http://www.aspfaq.com/
(Reverse address to reply.)|||enterprise manager is easy to use.
When I update or add a column, I can do this very quickly in enterprise
manager
using query analyzer is an overhead for me :-)
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23hCrneyyEHA.2624@.TK2MSFTNGP11.phx.gbl...
>> every time I save after a change in any table through enterprise nmanager
>> I receive this error:
>> [Microsoft][ODBC SQL Server Driver] Invalid cursor state
> So why not use scripts in Query Analyzer? IMHO, there are only a few
> cases
> where Enterprise Manager should be used...
> http://www.aspfaq.com/2515
> http://www.aspfaq.com/2455
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>|||This is over your head?
ALTER TABLE <tablename> ADD <columnname> <DATATYPE>
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:eat5rhyyEHA.4028@.TK2MSFTNGP15.phx.gbl...
> enterprise manager is easy to use.
> When I update or add a column, I can do this very quickly in enterprise
> manager
> using query analyzer is an overhead for me :-)
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:%23hCrneyyEHA.2624@.TK2MSFTNGP11.phx.gbl...
> >> every time I save after a change in any table through enterprise
nmanager
> >> I receive this error:
> >> [Microsoft][ODBC SQL Server Driver] Invalid cursor state
> >
> > So why not use scripts in Query Analyzer? IMHO, there are only a few
> > cases
> > where Enterprise Manager should be used...
> >
> > http://www.aspfaq.com/2515
> > http://www.aspfaq.com/2455
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
>|||yep
specially when you have a lot of columns to change/add/remove :-)
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ebp1VjyyEHA.2540@.TK2MSFTNGP09.phx.gbl...
> This is over your head?
> ALTER TABLE <tablename> ADD <columnname> <DATATYPE>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eat5rhyyEHA.4028@.TK2MSFTNGP15.phx.gbl...
>> enterprise manager is easy to use.
>> When I update or add a column, I can do this very quickly in enterprise
>> manager
>> using query analyzer is an overhead for me :-)
>>
>> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
>> news:%23hCrneyyEHA.2624@.TK2MSFTNGP11.phx.gbl...
>> >> every time I save after a change in any table through enterprise
> nmanager
>> >> I receive this error:
>> >> [Microsoft][ODBC SQL Server Driver] Invalid cursor state
>> >
>> > So why not use scripts in Query Analyzer? IMHO, there are only a few
>> > cases
>> > where Enterprise Manager should be used...
>> >
>> > http://www.aspfaq.com/2515
>> > http://www.aspfaq.com/2455
>> >
>> > --
>> > http://www.aspfaq.com/
>> > (Reverse address to reply.)
>> >
>> >
>>
>|||> yep
> specially when you have a lot of columns to change/add/remove :-)
Okay, so is there something especially painful about learning them? It
certainly can't HURT you to have this knowledge; surely someday you will
have to connect to SQL Server without using a GUI as a crutch...|||There are different combinations of service packs that lend
themselves to having this error more often - e.g between
8.00.0859 and 8.00.0875 you can get the error more often,
version 8.00.0927 or no SP3 version 8.00.0194 you don't,
etc.
The bottom line is what Aaron keeps telling you - you should
be using Query Analyzer for this type of thing. It was
designed more for this type of activity.
-Sue
On Mon, 15 Nov 2004 11:17:34 -0500, "Jéjé"
<willgart_A_@.hotmail_A_.com> wrote:
>yep
>specially when you have a lot of columns to change/add/remove :-)
>"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
>news:ebp1VjyyEHA.2540@.TK2MSFTNGP09.phx.gbl...
>> This is over your head?
>> ALTER TABLE <tablename> ADD <columnname> <DATATYPE>
>> --
>> http://www.aspfaq.com/
>> (Reverse address to reply.)
>>
>>
>> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
>> news:eat5rhyyEHA.4028@.TK2MSFTNGP15.phx.gbl...
>> enterprise manager is easy to use.
>> When I update or add a column, I can do this very quickly in enterprise
>> manager
>> using query analyzer is an overhead for me :-)
>>
>> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
>> news:%23hCrneyyEHA.2624@.TK2MSFTNGP11.phx.gbl...
>> >> every time I save after a change in any table through enterprise
>> nmanager
>> >> I receive this error:
>> >> [Microsoft][ODBC SQL Server Driver] Invalid cursor state
>> >
>> > So why not use scripts in Query Analyzer? IMHO, there are only a few
>> > cases
>> > where Enterprise Manager should be used...
>> >
>> > http://www.aspfaq.com/2515
>> > http://www.aspfaq.com/2455
>> >
>> > --
>> > http://www.aspfaq.com/
>> > (Reverse address to reply.)
>> >
>> >
>>
>>
>|||I've the version 859
what is the 927 version? SP4? intermediate release?
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:isshp0916fff78e8q6i0rn7n1lh5a0meen@.4ax.com...
> There are different combinations of service packs that lend
> themselves to having this error more often - e.g between
> 8.00.0859 and 8.00.0875 you can get the error more often,
> version 8.00.0927 or no SP3 version 8.00.0194 you don't,
> etc.
> The bottom line is what Aaron keeps telling you - you should
> be using Query Analyzer for this type of thing. It was
> designed more for this type of activity.
> -Sue
> On Mon, 15 Nov 2004 11:17:34 -0500, "Jéjé"
> <willgart_A_@.hotmail_A_.com> wrote:
>>yep
>>specially when you have a lot of columns to change/add/remove :-)
>>"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
>>news:ebp1VjyyEHA.2540@.TK2MSFTNGP09.phx.gbl...
>> This is over your head?
>> ALTER TABLE <tablename> ADD <columnname> <DATATYPE>
>> --
>> http://www.aspfaq.com/
>> (Reverse address to reply.)
>>
>>
>> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
>> news:eat5rhyyEHA.4028@.TK2MSFTNGP15.phx.gbl...
>> enterprise manager is easy to use.
>> When I update or add a column, I can do this very quickly in enterprise
>> manager
>> using query analyzer is an overhead for me :-)
>>
>> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
>> news:%23hCrneyyEHA.2624@.TK2MSFTNGP11.phx.gbl...
>> >> every time I save after a change in any table through enterprise
>> nmanager
>> >> I receive this error:
>> >> [Microsoft][ODBC SQL Server Driver] Invalid cursor state
>> >
>> > So why not use scripts in Query Analyzer? IMHO, there are only a few
>> > cases
>> > where Enterprise Manager should be used...
>> >
>> > http://www.aspfaq.com/2515
>> > http://www.aspfaq.com/2455
>> >
>> > --
>> > http://www.aspfaq.com/
>> > (Reverse address to reply.)
>> >
>> >
>>
>>
>|||> what is the 927 version? SP4? intermediate release?
Hotfix. Only certain ones are available without contacting PSS directly.
http://www.aspfaq.com/2160
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Hot fix for the following:
http://support.microsoft.com/?kbid=839688
But then you will be managing hot fixes based upon not
wanting to use Query Analyzer for writing T-SQL to maintain
your databases. Doesn't seem like a good path to go down.
So if another slammer comes out, would your company want you
to patch it and use T-SQL for table changes or would they
want you to leave the box vulnerable so you could use
Enterprise Manager to make all your table changes?
-Sue
On Mon, 15 Nov 2004 13:40:43 -0500, "Jéjé"
<willgart_A_@.hotmail_A_.com> wrote:
>I've the version 859
>what is the 927 version? SP4? intermediate release?
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:isshp0916fff78e8q6i0rn7n1lh5a0meen@.4ax.com...
>> There are different combinations of service packs that lend
>> themselves to having this error more often - e.g between
>> 8.00.0859 and 8.00.0875 you can get the error more often,
>> version 8.00.0927 or no SP3 version 8.00.0194 you don't,
>> etc.
>> The bottom line is what Aaron keeps telling you - you should
>> be using Query Analyzer for this type of thing. It was
>> designed more for this type of activity.
>> -Sue
>> On Mon, 15 Nov 2004 11:17:34 -0500, "Jéjé"
>> <willgart_A_@.hotmail_A_.com> wrote:
>>yep
>>specially when you have a lot of columns to change/add/remove :-)
>>"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
>>news:ebp1VjyyEHA.2540@.TK2MSFTNGP09.phx.gbl...
>> This is over your head?
>> ALTER TABLE <tablename> ADD <columnname> <DATATYPE>
>> --
>> http://www.aspfaq.com/
>> (Reverse address to reply.)
>>
>>
>> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
>> news:eat5rhyyEHA.4028@.TK2MSFTNGP15.phx.gbl...
>> enterprise manager is easy to use.
>> When I update or add a column, I can do this very quickly in enterprise
>> manager
>> using query analyzer is an overhead for me :-)
>>
>> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
>> news:%23hCrneyyEHA.2624@.TK2MSFTNGP11.phx.gbl...
>> >> every time I save after a change in any table through enterprise
>> nmanager
>> >> I receive this error:
>> >> [Microsoft][ODBC SQL Server Driver] Invalid cursor state
>> >
>> > So why not use scripts in Query Analyzer? IMHO, there are only a few
>> > cases
>> > where Enterprise Manager should be used...
>> >
>> > http://www.aspfaq.com/2515
>> > http://www.aspfaq.com/2455
>> >
>> > --
>> > http://www.aspfaq.com/
>> > (Reverse address to reply.)
>> >
>> >
>>
>>
>>
>|||ok ok...
I'll try to change my working method ;-)
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:9tuhp0p5ab2leg6t7527kfe6r68n014ia8@.4ax.com...
> Hot fix for the following:
> http://support.microsoft.com/?kbid=839688
> But then you will be managing hot fixes based upon not
> wanting to use Query Analyzer for writing T-SQL to maintain
> your databases. Doesn't seem like a good path to go down.
> So if another slammer comes out, would your company want you
> to patch it and use T-SQL for table changes or would they
> want you to leave the box vulnerable so you could use
> Enterprise Manager to make all your table changes?
> -Sue
> On Mon, 15 Nov 2004 13:40:43 -0500, "Jéjé"
> <willgart_A_@.hotmail_A_.com> wrote:
>>I've the version 859
>>what is the 927 version? SP4? intermediate release?
>>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>>news:isshp0916fff78e8q6i0rn7n1lh5a0meen@.4ax.com...
>> There are different combinations of service packs that lend
>> themselves to having this error more often - e.g between
>> 8.00.0859 and 8.00.0875 you can get the error more often,
>> version 8.00.0927 or no SP3 version 8.00.0194 you don't,
>> etc.
>> The bottom line is what Aaron keeps telling you - you should
>> be using Query Analyzer for this type of thing. It was
>> designed more for this type of activity.
>> -Sue
>> On Mon, 15 Nov 2004 11:17:34 -0500, "Jéjé"
>> <willgart_A_@.hotmail_A_.com> wrote:
>>yep
>>specially when you have a lot of columns to change/add/remove :-)
>>"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
>>news:ebp1VjyyEHA.2540@.TK2MSFTNGP09.phx.gbl...
>> This is over your head?
>> ALTER TABLE <tablename> ADD <columnname> <DATATYPE>
>> --
>> http://www.aspfaq.com/
>> (Reverse address to reply.)
>>
>>
>> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
>> news:eat5rhyyEHA.4028@.TK2MSFTNGP15.phx.gbl...
>> enterprise manager is easy to use.
>> When I update or add a column, I can do this very quickly in
>> enterprise
>> manager
>> using query analyzer is an overhead for me :-)
>>
>> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
>> news:%23hCrneyyEHA.2624@.TK2MSFTNGP11.phx.gbl...
>> >> every time I save after a change in any table through enterprise
>> nmanager
>> >> I receive this error:
>> >> [Microsoft][ODBC SQL Server Driver] Invalid cursor state
>> >
>> > So why not use scripts in Query Analyzer? IMHO, there are only a
>> > few
>> > cases
>> > where Enterprise Manager should be used...
>> >
>> > http://www.aspfaq.com/2515
>> > http://www.aspfaq.com/2455
>> >
>> > --
>> > http://www.aspfaq.com/
>> > (Reverse address to reply.)
>> >
>> >
>>
>>
>>
>|||Related question:
Because of this same problem I have started using the query analyzer for my
query changes. I cannot find a reference for how to use ALTER to
rearrange(MOVE) columns within a table. Can someone show me an example
syntax of how to do this in TSQL?
"Jéjé" wrote:
> ok ok...
> I'll try to change my working method ;-)
>
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:9tuhp0p5ab2leg6t7527kfe6r68n014ia8@.4ax.com...
> > Hot fix for the following:
> > http://support.microsoft.com/?kbid=839688
> >
> > But then you will be managing hot fixes based upon not
> > wanting to use Query Analyzer for writing T-SQL to maintain
> > your databases. Doesn't seem like a good path to go down.
> > So if another slammer comes out, would your company want you
> > to patch it and use T-SQL for table changes or would they
> > want you to leave the box vulnerable so you could use
> > Enterprise Manager to make all your table changes?
> >
> > -Sue
> >
> > On Mon, 15 Nov 2004 13:40:43 -0500, "Jéjé"
> > <willgart_A_@.hotmail_A_.com> wrote:
> >
> >>I've the version 859
> >>what is the 927 version? SP4? intermediate release?
> >>
> >>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> >>news:isshp0916fff78e8q6i0rn7n1lh5a0meen@.4ax.com...
> >> There are different combinations of service packs that lend
> >> themselves to having this error more often - e.g between
> >> 8.00.0859 and 8.00.0875 you can get the error more often,
> >> version 8.00.0927 or no SP3 version 8.00.0194 you don't,
> >> etc.
> >> The bottom line is what Aaron keeps telling you - you should
> >> be using Query Analyzer for this type of thing. It was
> >> designed more for this type of activity.
> >>
> >> -Sue
> >>
> >> On Mon, 15 Nov 2004 11:17:34 -0500, "Jéjé"
> >> <willgart_A_@.hotmail_A_.com> wrote:
> >>
> >>yep
> >>specially when you have a lot of columns to change/add/remove :-)
> >>
> >>"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> >>news:ebp1VjyyEHA.2540@.TK2MSFTNGP09.phx.gbl...
> >> This is over your head?
> >>
> >> ALTER TABLE <tablename> ADD <columnname> <DATATYPE>
> >>
> >> --
> >> http://www.aspfaq.com/
> >> (Reverse address to reply.)
> >>
> >>
> >>
> >>
> >> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
> >> news:eat5rhyyEHA.4028@.TK2MSFTNGP15.phx.gbl...
> >> enterprise manager is easy to use.
> >> When I update or add a column, I can do this very quickly in
> >> enterprise
> >> manager
> >>
> >> using query analyzer is an overhead for me :-)
> >>
> >>
> >> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> >> news:%23hCrneyyEHA.2624@.TK2MSFTNGP11.phx.gbl...
> >> >> every time I save after a change in any table through enterprise
> >> nmanager
> >> >> I receive this error:
> >> >> [Microsoft][ODBC SQL Server Driver] Invalid cursor state
> >> >
> >> > So why not use scripts in Query Analyzer? IMHO, there are only a
> >> > few
> >> > cases
> >> > where Enterprise Manager should be used...
> >> >
> >> > http://www.aspfaq.com/2515
> >> > http://www.aspfaq.com/2455
> >> >
> >> > --
> >> > http://www.aspfaq.com/
> >> > (Reverse address to reply.)
> >> >
> >> >
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
>
>|||you have to copy your table in a new one which has the right order
then delete the first table and rename the temporary table to the right name
(all in a transaction)
or you can use enterprise manager to change the order and ask to generate
the SQL statement instead-of saving the change. then execute this syntax.
"Don" <Don@.discussions.microsoft.com> wrote in message
news:140DD312-365C-45C3-9280-8082FAE8F62C@.microsoft.com...
> Related question:
> Because of this same problem I have started using the query analyzer for
> my
> query changes. I cannot find a reference for how to use ALTER to
> rearrange(MOVE) columns within a table. Can someone show me an example
> syntax of how to do this in TSQL?
> "Jéjé" wrote:
>> ok ok...
>> I'll try to change my working method ;-)
>>
>> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>> news:9tuhp0p5ab2leg6t7527kfe6r68n014ia8@.4ax.com...
>> > Hot fix for the following:
>> > http://support.microsoft.com/?kbid=839688
>> >
>> > But then you will be managing hot fixes based upon not
>> > wanting to use Query Analyzer for writing T-SQL to maintain
>> > your databases. Doesn't seem like a good path to go down.
>> > So if another slammer comes out, would your company want you
>> > to patch it and use T-SQL for table changes or would they
>> > want you to leave the box vulnerable so you could use
>> > Enterprise Manager to make all your table changes?
>> >
>> > -Sue
>> >
>> > On Mon, 15 Nov 2004 13:40:43 -0500, "Jéjé"
>> > <willgart_A_@.hotmail_A_.com> wrote:
>> >
>> >>I've the version 859
>> >>what is the 927 version? SP4? intermediate release?
>> >>
>> >>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>> >>news:isshp0916fff78e8q6i0rn7n1lh5a0meen@.4ax.com...
>> >> There are different combinations of service packs that lend
>> >> themselves to having this error more often - e.g between
>> >> 8.00.0859 and 8.00.0875 you can get the error more often,
>> >> version 8.00.0927 or no SP3 version 8.00.0194 you don't,
>> >> etc.
>> >> The bottom line is what Aaron keeps telling you - you should
>> >> be using Query Analyzer for this type of thing. It was
>> >> designed more for this type of activity.
>> >>
>> >> -Sue
>> >>
>> >> On Mon, 15 Nov 2004 11:17:34 -0500, "Jéjé"
>> >> <willgart_A_@.hotmail_A_.com> wrote:
>> >>
>> >>yep
>> >>specially when you have a lot of columns to change/add/remove :-)
>> >>
>> >>"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
>> >>news:ebp1VjyyEHA.2540@.TK2MSFTNGP09.phx.gbl...
>> >> This is over your head?
>> >>
>> >> ALTER TABLE <tablename> ADD <columnname> <DATATYPE>
>> >>
>> >> --
>> >> http://www.aspfaq.com/
>> >> (Reverse address to reply.)
>> >>
>> >>
>> >>
>> >>
>> >> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
>> >> news:eat5rhyyEHA.4028@.TK2MSFTNGP15.phx.gbl...
>> >> enterprise manager is easy to use.
>> >> When I update or add a column, I can do this very quickly in
>> >> enterprise
>> >> manager
>> >>
>> >> using query analyzer is an overhead for me :-)
>> >>
>> >>
>> >> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
>> >> news:%23hCrneyyEHA.2624@.TK2MSFTNGP11.phx.gbl...
>> >> >> every time I save after a change in any table through
>> >> >> enterprise
>> >> nmanager
>> >> >> I receive this error:
>> >> >> [Microsoft][ODBC SQL Server Driver] Invalid cursor state
>> >> >
>> >> > So why not use scripts in Query Analyzer? IMHO, there are only
>> >> > a
>> >> > few
>> >> > cases
>> >> > where Enterprise Manager should be used...
>> >> >
>> >> > http://www.aspfaq.com/2515
>> >> > http://www.aspfaq.com/2455
>> >> >
>> >> > --
>> >> > http://www.aspfaq.com/
>> >> > (Reverse address to reply.)
>> >> >
>> >> >
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >
>>

[Microsoft][ODBC SQL Server Driver] Invalid cursor stateevery time I save in enterpris

Hi,
every time I save after a change in any table through enterprise nmanager
I receive this error:
[Microsoft][ODBC SQL Server Driver] Invalid cursor state
If I generate a script instead-of saving directly
and if I execute this script through the query analyzer all works fine!
My windows 2003 is english
my SQL Server is french
my default language is french
I've found the same error on another server which is in the same config.
any idea?
thanks.
Jerome.> every time I save after a change in any table through enterprise nmanager
> I receive this error:
> [Microsoft][ODBC SQL Server Driver] Invalid cursor state
So why not use scripts in Query Analyzer? IMHO, there are only a few cases
where Enterprise Manager should be used...
http://www.aspfaq.com/2515
http://www.aspfaq.com/2455
http://www.aspfaq.com/
(Reverse address to reply.)|||enterprise manager is easy to use.
When I update or add a column, I can do this very quickly in enterprise
manager
using query analyzer is an overhead for me :-)
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23hCrneyyEHA.2624@.TK2MSFTNGP11.phx.gbl...
> So why not use scripts in Query Analyzer? IMHO, there are only a few
> cases
> where Enterprise Manager should be used...
> http://www.aspfaq.com/2515
> http://www.aspfaq.com/2455
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>|||This is over your head?
ALTER TABLE <tablename> ADD <columnname> <DATATYPE>
http://www.aspfaq.com/
(Reverse address to reply.)
"Jj" <willgart_A_@.hotmail_A_.com> wrote in message
news:eat5rhyyEHA.4028@.TK2MSFTNGP15.phx.gbl...
> enterprise manager is easy to use.
> When I update or add a column, I can do this very quickly in enterprise
> manager
> using query analyzer is an overhead for me :-)
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:%23hCrneyyEHA.2624@.TK2MSFTNGP11.phx.gbl...
nmanager[vbcol=seagreen]
>|||yep
specially when you have a lot of columns to change/add/remove :-)
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ebp1VjyyEHA.2540@.TK2MSFTNGP09.phx.gbl...
> This is over your head?
> ALTER TABLE <tablename> ADD <columnname> <DATATYPE>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eat5rhyyEHA.4028@.TK2MSFTNGP15.phx.gbl...
> nmanager
>|||> yep
> specially when you have a lot of columns to change/add/remove :-)
Okay, so is there something especially painful about learning them? It
certainly can't HURT you to have this knowledge; surely someday you will
have to connect to SQL Server without using a GUI as a crutch...|||There are different combinations of service packs that lend
themselves to having this error more often - e.g between
8.00.0859 and 8.00.0875 you can get the error more often,
version 8.00.0927 or no SP3 version 8.00.0194 you don't,
etc.
The bottom line is what Aaron keeps telling you - you should
be using Query Analyzer for this type of thing. It was
designed more for this type of activity.
-Sue
On Mon, 15 Nov 2004 11:17:34 -0500, "Jj"
<willgart_A_@.hotmail_A_.com> wrote:

>yep
>specially when you have a lot of columns to change/add/remove :-)
>"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
>news:ebp1VjyyEHA.2540@.TK2MSFTNGP09.phx.gbl...
>|||I've the version 859
what is the 927 version? SP4? intermediate release?
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:isshp0916fff78e8q6i0rn7n1lh5a0meen@.
4ax.com...
> There are different combinations of service packs that lend
> themselves to having this error more often - e.g between
> 8.00.0859 and 8.00.0875 you can get the error more often,
> version 8.00.0927 or no SP3 version 8.00.0194 you don't,
> etc.
> The bottom line is what Aaron keeps telling you - you should
> be using Query Analyzer for this type of thing. It was
> designed more for this type of activity.
> -Sue
> On Mon, 15 Nov 2004 11:17:34 -0500, "Jj"
> <willgart_A_@.hotmail_A_.com> wrote:
>
>|||> what is the 927 version? SP4? intermediate release?
Hotfix. Only certain ones are available without contacting PSS directly.
http://www.aspfaq.com/2160
http://www.aspfaq.com/
(Reverse address to reply.)|||Hot fix for the following:
http://support.microsoft.com/?kbid=839688
But then you will be managing hot fixes based upon not
wanting to use Query Analyzer for writing T-SQL to maintain
your databases. Doesn't seem like a good path to go down.
So if another slammer comes out, would your company want you
to patch it and use T-SQL for table changes or would they
want you to leave the box vulnerable so you could use
Enterprise Manager to make all your table changes?
-Sue
On Mon, 15 Nov 2004 13:40:43 -0500, "Jj"
<willgart_A_@.hotmail_A_.com> wrote:

>I've the version 859
>what is the 927 version? SP4? intermediate release?
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:isshp0916fff78e8q6i0rn7n1lh5a0meen@.
4ax.com...
>

[LOG] Unable to read local eventlog (reason: The parameter is incorrect) - FLOOD

[LOG] Unable to read local eventlog (reason: The parameter is incorrect)

I just had two seperate SQL Server 2005 Enterprise Edition machines suddently throw thousands of these errors within the last 24 hours. In both cases the the SQL agent and application event logs are just being flooded with a new entry every couple of seconds.

While the errors are being logged the Agent continues to run jobs (e.g. scheduled backups, etc.) without error.

A restart of the agent stops the errors and everything seems to be back to normal.

There is no commonality between the two machines, they are on different networks, domains, etc.

Both machines have been up >30 days and have not previously logged this error.

Anybody else seen this?

Thanks,

Joe

See this post Joe:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=124086&SiteID=1

HTH,

[help] SQL Error - I/O Error 2 (The system cannot find the file specified)

Windows 2000 Server SP4 + SQL Server 2000 Enterprise Editon SP3,RAID5.

the windows event log give the following error information:

I/O error 2(The system cannot find the file specified) detected during write at offset 0x0000010c6c4000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL\data\GJSZBANK_Data.MDF'.

I have searched microsoft knowledge base and got this article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;828339

but don't understand some contents in the topic:

For example, if you encounter the following error message in the SQL Server Errorlog file, SQL Server encountered operating system error 2 when it uses a Windows API call to write to the tempdb primary database file:

Error: 823, Severity: 24, State: 4
I/O error 2(The system cannot find the file specified.) detected during write at offset 0x00000000284000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL\data\tempdb.mdf'

Because SQL Server has already successfully opened the file and did not receive an Invalid Handle error, the error is likely being raised in a lower-level kernel software component, such as the file system or a device driver. This problem does not indicate a problem in SQL Server, and it must be investigated as an issue with the file system or a device driver that is associated with the file.

Does that mean this is not a SQL Server error?
Does that mean something wrong with my operating system? or something wrong with my hard disk?Are there any errors in the SQL errorlog? Or is it only in the NT Event log?