User is getting timeout errors when they try to backup a 2000 database using
a db backup and restore utility I wrote. The problem has just started
occurring w/in the last few days. I'd like to avoid driving to the site,
over 200-miles away, and changing the .ConnectionTimeout and .CommandTimeout
property of the db connection object building another distribution. Is there
a way to accomplish thisi via some "SET" command in Enterprise Mgr.?
TIATimeouts occur on the client side, not on the server, so there is no EM
setting. I hope you enjoy your trip :-)
pe this helps.
Dan Guzman
SQL Server MVP
"PKSpence" <patrick@.NOSPAMpkspence.com> wrote in message
news:u673qFGxFHA.3000@.TK2MSFTNGP12.phx.gbl...
> User is getting timeout errors when they try to backup a 2000 database
> using a db backup and restore utility I wrote. The problem has just
> started occurring w/in the last few days. I'd like to avoid driving to the
> site, over 200-miles away, and changing the .ConnectionTimeout and
> .CommandTimeout property of the db connection object building another
> distribution. Is there a way to accomplish thisi via some "SET" command in
> Enterprise Mgr.?
> TIA
>
>|||thanks ;o(
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:eBzkJGIxFHA.2252@.TK2MSFTNGP09.phx.gbl...
> Timeouts occur on the client side, not on the server, so there is no EM
> setting. I hope you enjoy your trip :-)
>
> pe this helps.
> Dan Guzman
> SQL Server MVP
> "PKSpence" <patrick@.NOSPAMpkspence.com> wrote in message
> news:u673qFGxFHA.3000@.TK2MSFTNGP12.phx.gbl...
>> User is getting timeout errors when they try to backup a 2000 database
>> using a db backup and restore utility I wrote. The problem has just
>> started occurring w/in the last few days. I'd like to avoid driving to
>> the site, over 200-miles away, and changing the .ConnectionTimeout and
>> .CommandTimeout property of the db connection object building another
>> distribution. Is there a way to accomplish thisi via some "SET" command
>> in Enterprise Mgr.?
>> TIA
>>
>
Showing posts with label utility. Show all posts
Showing posts with label utility. Show all posts
Friday, March 16, 2012
"Timeout expired" errors
User is getting timeout errors when they try to backup a 2000 database using
a db backup and restore utility I wrote. The problem has just started
occurring w/in the last few days. I'd like to avoid driving to the site,
over 200-miles away, and changing the .ConnectionTimeout and .CommandTimeout
property of the db connection object building another distribution. Is there
a way to accomplish thisi via some "SET" command in Enterprise Mgr.?
TIATimeouts occur on the client side, not on the server, so there is no EM
setting. I hope you enjoy your trip :-)
pe this helps.
Dan Guzman
SQL Server MVP
"PKSpence" <patrick@.NOSPAMpkspence.com> wrote in message
news:u673qFGxFHA.3000@.TK2MSFTNGP12.phx.gbl...
> User is getting timeout errors when they try to backup a 2000 database
> using a db backup and restore utility I wrote. The problem has just
> started occurring w/in the last few days. I'd like to avoid driving to the
> site, over 200-miles away, and changing the .ConnectionTimeout and
> .CommandTimeout property of the db connection object building another
> distribution. Is there a way to accomplish thisi via some "SET" command in
> Enterprise Mgr.?
> TIA
>
>|||thanks ;o(
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:eBzkJGIxFHA.2252@.TK2MSFTNGP09.phx.gbl...
> Timeouts occur on the client side, not on the server, so there is no EM
> setting. I hope you enjoy your trip :-)
>
> pe this helps.
> Dan Guzman
> SQL Server MVP
> "PKSpence" <patrick@.NOSPAMpkspence.com> wrote in message
> news:u673qFGxFHA.3000@.TK2MSFTNGP12.phx.gbl...
>
a db backup and restore utility I wrote. The problem has just started
occurring w/in the last few days. I'd like to avoid driving to the site,
over 200-miles away, and changing the .ConnectionTimeout and .CommandTimeout
property of the db connection object building another distribution. Is there
a way to accomplish thisi via some "SET" command in Enterprise Mgr.?
TIATimeouts occur on the client side, not on the server, so there is no EM
setting. I hope you enjoy your trip :-)
pe this helps.
Dan Guzman
SQL Server MVP
"PKSpence" <patrick@.NOSPAMpkspence.com> wrote in message
news:u673qFGxFHA.3000@.TK2MSFTNGP12.phx.gbl...
> User is getting timeout errors when they try to backup a 2000 database
> using a db backup and restore utility I wrote. The problem has just
> started occurring w/in the last few days. I'd like to avoid driving to the
> site, over 200-miles away, and changing the .ConnectionTimeout and
> .CommandTimeout property of the db connection object building another
> distribution. Is there a way to accomplish thisi via some "SET" command in
> Enterprise Mgr.?
> TIA
>
>|||thanks ;o(
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:eBzkJGIxFHA.2252@.TK2MSFTNGP09.phx.gbl...
> Timeouts occur on the client side, not on the server, so there is no EM
> setting. I hope you enjoy your trip :-)
>
> pe this helps.
> Dan Guzman
> SQL Server MVP
> "PKSpence" <patrick@.NOSPAMpkspence.com> wrote in message
> news:u673qFGxFHA.3000@.TK2MSFTNGP12.phx.gbl...
>
"Timeout expired" errors
User is getting timeout errors when they try to backup a 2000 database using
a db backup and restore utility I wrote. The problem has just started
occurring w/in the last few days. I'd like to avoid driving to the site,
over 200-miles away, and changing the .ConnectionTimeout and .CommandTimeout
property of the db connection object building another distribution. Is there
a way to accomplish thisi via some "SET" command in Enterprise Mgr.?
TIA
Timeouts occur on the client side, not on the server, so there is no EM
setting. I hope you enjoy your trip :-)
pe this helps.
Dan Guzman
SQL Server MVP
"PKSpence" <patrick@.NOSPAMpkspence.com> wrote in message
news:u673qFGxFHA.3000@.TK2MSFTNGP12.phx.gbl...
> User is getting timeout errors when they try to backup a 2000 database
> using a db backup and restore utility I wrote. The problem has just
> started occurring w/in the last few days. I'd like to avoid driving to the
> site, over 200-miles away, and changing the .ConnectionTimeout and
> .CommandTimeout property of the db connection object building another
> distribution. Is there a way to accomplish thisi via some "SET" command in
> Enterprise Mgr.?
> TIA
>
>
|||thanks ;o(
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:eBzkJGIxFHA.2252@.TK2MSFTNGP09.phx.gbl...
> Timeouts occur on the client side, not on the server, so there is no EM
> setting. I hope you enjoy your trip :-)
>
> pe this helps.
> Dan Guzman
> SQL Server MVP
> "PKSpence" <patrick@.NOSPAMpkspence.com> wrote in message
> news:u673qFGxFHA.3000@.TK2MSFTNGP12.phx.gbl...
>
a db backup and restore utility I wrote. The problem has just started
occurring w/in the last few days. I'd like to avoid driving to the site,
over 200-miles away, and changing the .ConnectionTimeout and .CommandTimeout
property of the db connection object building another distribution. Is there
a way to accomplish thisi via some "SET" command in Enterprise Mgr.?
TIA
Timeouts occur on the client side, not on the server, so there is no EM
setting. I hope you enjoy your trip :-)
pe this helps.
Dan Guzman
SQL Server MVP
"PKSpence" <patrick@.NOSPAMpkspence.com> wrote in message
news:u673qFGxFHA.3000@.TK2MSFTNGP12.phx.gbl...
> User is getting timeout errors when they try to backup a 2000 database
> using a db backup and restore utility I wrote. The problem has just
> started occurring w/in the last few days. I'd like to avoid driving to the
> site, over 200-miles away, and changing the .ConnectionTimeout and
> .CommandTimeout property of the db connection object building another
> distribution. Is there a way to accomplish thisi via some "SET" command in
> Enterprise Mgr.?
> TIA
>
>
|||thanks ;o(
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:eBzkJGIxFHA.2252@.TK2MSFTNGP09.phx.gbl...
> Timeouts occur on the client side, not on the server, so there is no EM
> setting. I hope you enjoy your trip :-)
>
> pe this helps.
> Dan Guzman
> SQL Server MVP
> "PKSpence" <patrick@.NOSPAMpkspence.com> wrote in message
> news:u673qFGxFHA.3000@.TK2MSFTNGP12.phx.gbl...
>
"The specified module could not be found", Server Network Utility
Has any body had a problem whereby when you try and load the Server Network
Utility you get the error "The specified module could not be found". I have
SQL Server 2000 developer installed on my machine and 3 instances of MSDE and
2 of wMSDE. I have reinstalled sql server sp4, this has had no effect. Any
ideas anybody?
This issue is typically caused by a damaged installation of client tools. I
suggest that you reinstall the client tools through the following steps:
1. Insert the SQL Server 2000 compact disc into your CD-ROM drive. If the
compact disc does not autorun, double-click Autorun.exe in the root
directory of the compact disc.
2. Select SQL Server 2000 Components, select Install Database Server, and
then click Next at the Welcome screen of the SQL Server Installation Wizard.
3. In Computer Name dialog box, Local Computer is the default option, and
the local computer name appears in the edit box. Click Next.
4. In the Installation Selection dialog box, click Create a new instance of
SQL Server, or install Client Tools, and then click Next.
5. Follow the directions on the User Information, Software License
Agreement, and related screens.
6. In the Installation Definition dialog box, click Client tools only, and
then click Next.
7. In the Select Components dialog box, accept the defaults or select the
components you want, and then click Next.
8. In the Start Copying Files dialog box, click Next to complete the
installation of the client tools.
9. Check whether the Server Network Utility works correctly. If it works,
reapply SP4.
If the issue persists, I'd like to use the Dependency Walker tool to track
the module that cannot be loaded. To do so, follow these steps:
1) Download Dependency Walker utility from www.dependencywalker.com.
2) Create a new folder on your system and extract the files from this
executable into the folder.
3) Start Dependency Walker utility by double-clicking depends.exe.
4) From the File menu, click Open and choose the file C:\Program
Files\Microsoft Sql Server\80\Tools\Binn\svrnetcn.exe.
5) Click menu option Profile -> Start Profiling.
6) Select all checkboxes on the "Profile Module" dialog box.
7) Click OK to start profiling.
8) After the profiling finished, go to File-Save As-> save as svrnetcn.dwi.
9) Zip the .dwi file and e-mail it to me at v-rxwang@.microsoft.com.
Third-Party Link Disclaimer
===========
This response contains a reference to a third-party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.
If anything is unclear, feel free to let me know.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: "The specified module could not be found", Server Network
Utility
>thread-index: AcV5tMB8B0i7JmcNRia3obumQYfDXQ==
>X-WBNR-Posting-Host: 213.152.39.142
>From: "=?Utf-8?B?bmlja25hbWU=?=" <nickname@.online.nospam>
>Subject: "The specified module could not be found", Server Network Utility
>Date: Sat, 25 Jun 2005 11:36:08 -0700
>Lines: 5
>Message-ID: <02512271-F9D5-4CE4-8FE7-F9F92D841595@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.tools
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSF TNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.tools:4640
>X-Tomcat-NG: microsoft.public.sqlserver.tools
>Has any body had a problem whereby when you try and load the Server
Network
>Utility you get the error "The specified module could not be found". I
have
>SQL Server 2000 developer installed on my machine and 3 instances of MSDE
and
>2 of wMSDE. I have reinstalled sql server sp4, this has had no effect. Any
>ideas anybody?
>
Utility you get the error "The specified module could not be found". I have
SQL Server 2000 developer installed on my machine and 3 instances of MSDE and
2 of wMSDE. I have reinstalled sql server sp4, this has had no effect. Any
ideas anybody?
This issue is typically caused by a damaged installation of client tools. I
suggest that you reinstall the client tools through the following steps:
1. Insert the SQL Server 2000 compact disc into your CD-ROM drive. If the
compact disc does not autorun, double-click Autorun.exe in the root
directory of the compact disc.
2. Select SQL Server 2000 Components, select Install Database Server, and
then click Next at the Welcome screen of the SQL Server Installation Wizard.
3. In Computer Name dialog box, Local Computer is the default option, and
the local computer name appears in the edit box. Click Next.
4. In the Installation Selection dialog box, click Create a new instance of
SQL Server, or install Client Tools, and then click Next.
5. Follow the directions on the User Information, Software License
Agreement, and related screens.
6. In the Installation Definition dialog box, click Client tools only, and
then click Next.
7. In the Select Components dialog box, accept the defaults or select the
components you want, and then click Next.
8. In the Start Copying Files dialog box, click Next to complete the
installation of the client tools.
9. Check whether the Server Network Utility works correctly. If it works,
reapply SP4.
If the issue persists, I'd like to use the Dependency Walker tool to track
the module that cannot be loaded. To do so, follow these steps:
1) Download Dependency Walker utility from www.dependencywalker.com.
2) Create a new folder on your system and extract the files from this
executable into the folder.
3) Start Dependency Walker utility by double-clicking depends.exe.
4) From the File menu, click Open and choose the file C:\Program
Files\Microsoft Sql Server\80\Tools\Binn\svrnetcn.exe.
5) Click menu option Profile -> Start Profiling.
6) Select all checkboxes on the "Profile Module" dialog box.
7) Click OK to start profiling.
8) After the profiling finished, go to File-Save As-> save as svrnetcn.dwi.
9) Zip the .dwi file and e-mail it to me at v-rxwang@.microsoft.com.
Third-Party Link Disclaimer
===========
This response contains a reference to a third-party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.
If anything is unclear, feel free to let me know.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: "The specified module could not be found", Server Network
Utility
>thread-index: AcV5tMB8B0i7JmcNRia3obumQYfDXQ==
>X-WBNR-Posting-Host: 213.152.39.142
>From: "=?Utf-8?B?bmlja25hbWU=?=" <nickname@.online.nospam>
>Subject: "The specified module could not be found", Server Network Utility
>Date: Sat, 25 Jun 2005 11:36:08 -0700
>Lines: 5
>Message-ID: <02512271-F9D5-4CE4-8FE7-F9F92D841595@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.tools
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSF TNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.tools:4640
>X-Tomcat-NG: microsoft.public.sqlserver.tools
>Has any body had a problem whereby when you try and load the Server
Network
>Utility you get the error "The specified module could not be found". I
have
>SQL Server 2000 developer installed on my machine and 3 instances of MSDE
and
>2 of wMSDE. I have reinstalled sql server sp4, this has had no effect. Any
>ideas anybody?
>
Thursday, February 9, 2012
"Attempt to repair any minor problems." What is the point?
I have done a maintenance plan and I have this error:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged=20
on to SQL Server 'Cluster instance' as 'User' (trusted)
Starting maintenance plan 'DB Maintenance Plan5' on=20
31/05/2004 18:59:00
[1] Database xxxxxx: Index Rebuild (leaving 10%% free=20
space)...
Rebuilding indexes for table 'AccessStatusMap'
......................
Rebuilding indexes for table 'TransactionPropertyMap'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628:=20
[Microsoft][ODBC SQL Server Driver][SQL Server]A floating=20
point exception occurred in the user process. Current=20
transaction is canceled.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC=20
execution completed. If DBCC printed error messages,=20
contact your system administrator.
=BFDo Anybody know, why is it the cause of this error?
Sincerely,
Ignacio
=20
>--Original Message--
>What is the point of having this checkbox on the Database=20
Mainenance Plan
>properties (Integrity tab) window?
>
>For the plan to fix minor problems, it requires the db to=20
be in Single User
>Mode.
>"[Microsoft][ODBC SQL Server Driver][SQL Server]Repair=20
statement not
>processed. Database needs to be in single user mode."
>For the plan to execute it requires SQLAgent to be=20
running.
>For SqlAgent to be running, it requires NOT Single User=20
Mode.
>
>.
>
My guess is you have some invalid float data in the table/index. Turn on
trace flag 2570 and run DBCC CHECKTABLE on the table in question. 2570
switches on some extra data range value checking of things like floats and
dates. FYI: this functionality is controlled by documented T-SQL in SQL
Server 2005 rather than a trace flag.
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ignacio" <anonymous@.discussions.microsoft.com> wrote in message
news:1bfe01c44737$1dc83550$3501280a@.phx.gbl...
I have done a maintenance plan and I have this error:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged
on to SQL Server 'Cluster instance' as 'User' (trusted)
Starting maintenance plan 'DB Maintenance Plan5' on
31/05/2004 18:59:00
[1] Database xxxxxx: Index Rebuild (leaving 10%% free
space)...
Rebuilding indexes for table 'AccessStatusMap'
......................
Rebuilding indexes for table 'TransactionPropertyMap'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628:
[Microsoft][ODBC SQL Server Driver][SQL Server]A floating
point exception occurred in the user process. Current
transaction is canceled.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC
execution completed. If DBCC printed error messages,
contact your system administrator.
Do Anybody know, why is it the cause of this error?
Sincerely,
Ignacio
>--Original Message--
>What is the point of having this checkbox on the Database
Mainenance Plan
>properties (Integrity tab) window?
>
>For the plan to fix minor problems, it requires the db to
be in Single User
>Mode.
>"[Microsoft][ODBC SQL Server Driver][SQL Server]Repair
statement not
>processed. Database needs to be in single user mode."
>For the plan to execute it requires SQLAgent to be
running.
>For SqlAgent to be running, it requires NOT Single User
Mode.
>
>.
>
Microsoft (R) SQLMaint Utility (Unicode), Version Logged=20
on to SQL Server 'Cluster instance' as 'User' (trusted)
Starting maintenance plan 'DB Maintenance Plan5' on=20
31/05/2004 18:59:00
[1] Database xxxxxx: Index Rebuild (leaving 10%% free=20
space)...
Rebuilding indexes for table 'AccessStatusMap'
......................
Rebuilding indexes for table 'TransactionPropertyMap'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628:=20
[Microsoft][ODBC SQL Server Driver][SQL Server]A floating=20
point exception occurred in the user process. Current=20
transaction is canceled.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC=20
execution completed. If DBCC printed error messages,=20
contact your system administrator.
=BFDo Anybody know, why is it the cause of this error?
Sincerely,
Ignacio
=20
>--Original Message--
>What is the point of having this checkbox on the Database=20
Mainenance Plan
>properties (Integrity tab) window?
>
>For the plan to fix minor problems, it requires the db to=20
be in Single User
>Mode.
>"[Microsoft][ODBC SQL Server Driver][SQL Server]Repair=20
statement not
>processed. Database needs to be in single user mode."
>For the plan to execute it requires SQLAgent to be=20
running.
>For SqlAgent to be running, it requires NOT Single User=20
Mode.
>
>.
>
My guess is you have some invalid float data in the table/index. Turn on
trace flag 2570 and run DBCC CHECKTABLE on the table in question. 2570
switches on some extra data range value checking of things like floats and
dates. FYI: this functionality is controlled by documented T-SQL in SQL
Server 2005 rather than a trace flag.
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ignacio" <anonymous@.discussions.microsoft.com> wrote in message
news:1bfe01c44737$1dc83550$3501280a@.phx.gbl...
I have done a maintenance plan and I have this error:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged
on to SQL Server 'Cluster instance' as 'User' (trusted)
Starting maintenance plan 'DB Maintenance Plan5' on
31/05/2004 18:59:00
[1] Database xxxxxx: Index Rebuild (leaving 10%% free
space)...
Rebuilding indexes for table 'AccessStatusMap'
......................
Rebuilding indexes for table 'TransactionPropertyMap'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628:
[Microsoft][ODBC SQL Server Driver][SQL Server]A floating
point exception occurred in the user process. Current
transaction is canceled.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC
execution completed. If DBCC printed error messages,
contact your system administrator.
Do Anybody know, why is it the cause of this error?
Sincerely,
Ignacio
>--Original Message--
>What is the point of having this checkbox on the Database
Mainenance Plan
>properties (Integrity tab) window?
>
>For the plan to fix minor problems, it requires the db to
be in Single User
>Mode.
>"[Microsoft][ODBC SQL Server Driver][SQL Server]Repair
statement not
>processed. Database needs to be in single user mode."
>For the plan to execute it requires SQLAgent to be
running.
>For SqlAgent to be running, it requires NOT Single User
Mode.
>
>.
>
"Attempt to repair any minor problems." What is the point?
I have done a maintenance plan and I have this error:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged=20
on to SQL Server 'Cluster instance' as 'User' (trusted)
Starting maintenance plan 'DB Maintenance Plan5' on=20
31/05/2004 18:59:00
[1] Database xxxxxx: Index Rebuild (leaving 10%% free=20
space)...
Rebuilding indexes for table 'AccessStatusMap'
.....................
Rebuilding indexes for table 'TransactionPropertyMap'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628:=20
[Microsoft][ODBC SQL Server Driver][SQL Server]A floating=20
point exception occurred in the user process. Current=20
transaction is canceled.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC=20
execution completed. If DBCC printed error messages,=20
contact your system administrator.
=BFDo Anybody know, why is it the cause of this error?
Sincerely,
Ignacio
=20
>--Original Message--
>What is the point of having this checkbox on the Database=20
Mainenance Plan
>properties (Integrity tab) window?
>
>For the plan to fix minor problems, it requires the db to=20
be in Single User
>Mode.
>"[Microsoft][ODBC SQL Server Driver][SQL Server]Repair=20
statement not
>processed. Database needs to be in single user mode."
>For the plan to execute it requires SQLAgent to be=20
running.
>For SqlAgent to be running, it requires NOT Single User=20
Mode.
>
>.
>My guess is you have some invalid float data in the table/index. Turn on
trace flag 2570 and run DBCC CHECKTABLE on the table in question. 2570
switches on some extra data range value checking of things like floats and
dates. FYI: this functionality is controlled by documented T-SQL in SQL
Server 2005 rather than a trace flag.
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ignacio" <anonymous@.discussions.microsoft.com> wrote in message
news:1bfe01c44737$1dc83550$3501280a@.phx.gbl...
I have done a maintenance plan and I have this error:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged
on to SQL Server 'Cluster instance' as 'User' (trusted)
Starting maintenance plan 'DB Maintenance Plan5' on
31/05/2004 18:59:00
[1] Database xxxxxx: Index Rebuild (leaving 10%% free
space)...
Rebuilding indexes for table 'AccessStatusMap'
.....................
Rebuilding indexes for table 'TransactionPropertyMap'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628:
[Microsoft][ODBC SQL Server Driver][SQL Server]A floating
point exception occurred in the user process. Current
transaction is canceled.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC
execution completed. If DBCC printed error messages,
contact your system administrator.
Do Anybody know, why is it the cause of this error?
Sincerely,
Ignacio
>--Original Message--
>What is the point of having this checkbox on the Database
Mainenance Plan
>properties (Integrity tab) window?
>
>For the plan to fix minor problems, it requires the db to
be in Single User
>Mode.
>"[Microsoft][ODBC SQL Server Driver][SQL Server]Repair
statement not
>processed. Database needs to be in single user mode."
>For the plan to execute it requires SQLAgent to be
running.
>For SqlAgent to be running, it requires NOT Single User
Mode.
>
>.
>
Microsoft (R) SQLMaint Utility (Unicode), Version Logged=20
on to SQL Server 'Cluster instance' as 'User' (trusted)
Starting maintenance plan 'DB Maintenance Plan5' on=20
31/05/2004 18:59:00
[1] Database xxxxxx: Index Rebuild (leaving 10%% free=20
space)...
Rebuilding indexes for table 'AccessStatusMap'
.....................
Rebuilding indexes for table 'TransactionPropertyMap'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628:=20
[Microsoft][ODBC SQL Server Driver][SQL Server]A floating=20
point exception occurred in the user process. Current=20
transaction is canceled.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC=20
execution completed. If DBCC printed error messages,=20
contact your system administrator.
=BFDo Anybody know, why is it the cause of this error?
Sincerely,
Ignacio
=20
>--Original Message--
>What is the point of having this checkbox on the Database=20
Mainenance Plan
>properties (Integrity tab) window?
>
>For the plan to fix minor problems, it requires the db to=20
be in Single User
>Mode.
>"[Microsoft][ODBC SQL Server Driver][SQL Server]Repair=20
statement not
>processed. Database needs to be in single user mode."
>For the plan to execute it requires SQLAgent to be=20
running.
>For SqlAgent to be running, it requires NOT Single User=20
Mode.
>
>.
>My guess is you have some invalid float data in the table/index. Turn on
trace flag 2570 and run DBCC CHECKTABLE on the table in question. 2570
switches on some extra data range value checking of things like floats and
dates. FYI: this functionality is controlled by documented T-SQL in SQL
Server 2005 rather than a trace flag.
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ignacio" <anonymous@.discussions.microsoft.com> wrote in message
news:1bfe01c44737$1dc83550$3501280a@.phx.gbl...
I have done a maintenance plan and I have this error:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged
on to SQL Server 'Cluster instance' as 'User' (trusted)
Starting maintenance plan 'DB Maintenance Plan5' on
31/05/2004 18:59:00
[1] Database xxxxxx: Index Rebuild (leaving 10%% free
space)...
Rebuilding indexes for table 'AccessStatusMap'
.....................
Rebuilding indexes for table 'TransactionPropertyMap'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628:
[Microsoft][ODBC SQL Server Driver][SQL Server]A floating
point exception occurred in the user process. Current
transaction is canceled.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC
execution completed. If DBCC printed error messages,
contact your system administrator.
Do Anybody know, why is it the cause of this error?
Sincerely,
Ignacio
>--Original Message--
>What is the point of having this checkbox on the Database
Mainenance Plan
>properties (Integrity tab) window?
>
>For the plan to fix minor problems, it requires the db to
be in Single User
>Mode.
>"[Microsoft][ODBC SQL Server Driver][SQL Server]Repair
statement not
>processed. Database needs to be in single user mode."
>For the plan to execute it requires SQLAgent to be
running.
>For SqlAgent to be running, it requires NOT Single User
Mode.
>
>.
>
Subscribe to:
Posts (Atom)
