Showing posts with label message. Show all posts

Monday, March 26, 2012

Fetch within a fetch

Is it possible to have fetch within a fetch? I am getting this error message "A cursor with the name 'crImgGrp' does not exist." So i separate the process into two stored procedures?

CREATE PROCEDURE TrigSendPreNewIMAlertP2
@.REID int

Declare @.RRID int
Declare @.ITID int

Declare @.intIMEmail varchar(300)

Declare crReqRec cursor for
select RRID from RequestRecords where REID = @.REID and RRSTatus = 'IA' and APID is not null
open crReqRec
fetch next from crReqRec
into
@.RRID

Declare crImpGrp cursor for
select ITID from RequestRecords where RRID = @.RRID
open crImpGrp
fetch next from crImgGrp
into
@.ITID
while @.@.fetch_status = 0

EXEC TrigSendNewIMAlertP2 @.ITID

FETCH NEXT FROM crImpGrp
into
@.ITID

close crImpGrp
deallocate crImpGrp

while @.@.fetch_status = 0

FETCH NEXT FROM crReqRec
into
@.RRID

close crReqRec
deallocate crReqRec
GO... I'd re-think a different solution than what you want to do.

Wednesday, March 21, 2012

Hello,
We got a SQL Server (no SP) running on Win 2k SP4. Recently been getting
this error message in event viewer and at the same time the program that
access SQL Server crashes.
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 64 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Does anyone have any idea what it is please. Thanks
Andrew> We got a SQL Server (no SP) running on Win 2k SP4.
If this is SQL2000, apply SQL2000 sevice pack 4 + AWE memory hotfix first.
If this SQL2005, open a support case with Microsoft. But I'd strongly
suggest that you run SQL2005 on Windows 2003 SP1.
Linchi
"Huy (Andrew) V Nguyen" <andrew.nv@.gmail.com> wrote in message
news:%234ZSg%23cLGHA.3756@.TK2MSFTNGP10.phx.gbl...
> Hello,
> We got a SQL Server (no SP) running on Win 2k SP4. Recently been getting
> this error message in event viewer and at the same time the program that
> access SQL Server crashes.
> Error: 0, Severity: 19, State: 0
> SqlDumpExceptionHandler: Process 64 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> Does anyone have any idea what it is please. Thanks
> Andrew|||Thank you for your reply. I already applied SP4 still the same message.
Where can I obtain AWE hotfix please.
Andrew
Linchi Shea wrote:
>> We got a SQL Server (no SP) running on Win 2k SP4.
> If this is SQL2000, apply SQL2000 sevice pack 4 + AWE memory hotfix first.
> If this SQL2005, open a support case with Microsoft. But I'd strongly
> suggest that you run SQL2005 on Windows 2003 SP1.
> Linchi
> "Huy (Andrew) V Nguyen" <andrew.nv@.gmail.com> wrote in message
> news:%234ZSg%23cLGHA.3756@.TK2MSFTNGP10.phx.gbl...
>> Hello,
>> We got a SQL Server (no SP) running on Win 2k SP4. Recently been getting
>> this error message in event viewer and at the same time the program that
>> access SQL Server crashes.
>> Error: 0, Severity: 19, State: 0
>> SqlDumpExceptionHandler: Process 64 generated fatal exception c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
>> Does anyone have any idea what it is please. Thanks
>> Andrew
>|||You can get the AWE fix here :
http://www.microsoft.com/downloads/details.aspx?FamilyId=7C407047-3F1F-48B8-9E4C-DC32875E1961&displaylang=en
But you will need to log a case with Microsoft CSS , because the error you
posted is not sufficient enough , we need at least the stack output from the
AV , and if there was any mini dump created in the log folder during this
time...
So as linchi said please log a case with Microsoft CSS for speedy resolution
HTH
"Huy (Andrew) V Nguyen" <andrew.nv@.gmail.com> wrote in message
news:uVHDk9cMGHA.3264@.TK2MSFTNGP11.phx.gbl...
> Thank you for your reply. I already applied SP4 still the same message.
> Where can I obtain AWE hotfix please.
> Andrew
> Linchi Shea wrote:
>> We got a SQL Server (no SP) running on Win 2k SP4.
>> If this is SQL2000, apply SQL2000 sevice pack 4 + AWE memory hotfix
>> first. If this SQL2005, open a support case with Microsoft. But I'd
>> strongly suggest that you run SQL2005 on Windows 2003 SP1.
>> Linchi
>> "Huy (Andrew) V Nguyen" <andrew.nv@.gmail.com> wrote in message
>> news:%234ZSg%23cLGHA.3756@.TK2MSFTNGP10.phx.gbl...
>> Hello,
>> We got a SQL Server (no SP) running on Win 2k SP4. Recently been getting
>> this error message in event viewer and at the same time the program that
>> access SQL Server crashes.
>> Error: 0, Severity: 19, State: 0
>> SqlDumpExceptionHandler: Process 64 generated fatal exception c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
>> Does anyone have any idea what it is please. Thanks
>> Andrew

Monday, March 19, 2012

Fatal error 682 - what is it and how do you fix it?

When trying to improve my app, I actually broke it (as you do) and came up with the error message reproduced herein. Any help in understanding the nature of the error and how to go about resolving it would be more than handy Crying [:'(]

Server Error in '/' Application.

Warning: Fatal error 682 occurred at Feb 3 2006 9:26PM. Note the error and time, and contact your system administrator.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Warning: Fatal error 682 occurred at Feb 3 2006 9:26PM. Note the error and time, and contact your system administrator.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Warning: Fatal error 682 occurred at Feb 3 2006 9:26PM. Note the error and time, and contact your system administrator.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857242 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734854 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlDataReader.HasMoreRows() +150 System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +214 System.Data.SqlClient.SqlDataReader.Read() +9 System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +156 System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +153 System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +172 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +175 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.GridView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69 System.Web.UI.Control.EnsureChildControls() +87 System.Web.UI.Control.PreRenderRecursiveInternal() +41 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360

Thank you in advance.

Tailwag wrote:
Warning: Fatal error 682 occurred at Feb 3 2006 9:26PM. Note the error and time, and contact your system administrator.

I have been digging deeper and found out that the error message number is for ERROR_LONGJUMP of course doing a Google on that turned up zip and MSDN only tell you its name, nothing about it or how to fix it.

Any 'code athletes' out there who know how to '_LONGJUMP'

Tia

|||Sounds like there is something SERIOUSLY wrong with your SQL Server. Check the system event logs, and the SQL Logs, and see what it has to say happened at the time. I'm guessing there was one or more events listed in one or both of those places.|||

Good thinking Big Smile [:D] the server is remotely hosted and I have written to the support guys, who are always helpful.

Cheers.

|||

Tailwag wrote:
Warning: Fatal error 682 occurred at Feb 3 2006 9:26PM. Note the error and time, and contact your system administrator.

Okay, by way of feedback, here is an update onFatal error 682.Seeing there is Zero information on it on Google or MSDN other than to give it a name of LONGJUMP, which also turns up nothing, I decided to resolve the issue myself.

Essentially (I thought), okay the remote server is telling me it is broken, so I simply deleted the offending table, imported a new one, and that fixed the problem.

Of course, its nice to have it fixed, but why the crummy error message that really says nothing, and how is it that there is no information on this type of error? I feel that there was corruption in one record, which occurred for whatever reason and from that time onwards, that table was cactus and non-responsive. Strangely however I could access other records from within the same table, just not specific records...anyway, the moral to the story is almost the same as fixing broken hardware.

Reboot the computer - Golden Rule #1

Taking this analogy further with databases, the #1 rule seems to be:

Delete and reinstall from a backup Stick out tongue [:P]

Friday, February 24, 2012

Failure when installing SQL 2005 SP1 on Windows 2003 Server

Hello.

When I installed SQL 2005 SP1 on Windows 2003 Server, I received the following message:

"A recently applied update, KB913090, failed to install."

At the end, "Database Services" was marked as "Failure".

I have tried everything I could find in the knowledge base and on the forums, but still

was not able to install SP1.

For example:

http://support.microsoft.com/default.aspx?scid=kb;en-us;918357

Any insights would be greatly appreciated.

Can you search your hotfix logs (%WINDIR%/hotfix directory) for the text string "value 3" and include the 10-20 lines above it? That should give us a more descriptive error.

Thanks,
Sam Lester (MSFT)|||

MSI (s) (B0!C0) [22:08:08:355]: Note: 1: 2262 2: _sqlAction 3: -2147287038
MSI (s) (B0!C0) [22:08:08:355]: Transforming table _sqlAction.

MSI (s) (B0!C0) [22:08:08:355]: Note: 1: 2262 2: _sqlAction 3: -2147287038
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: CommitSqlUpgrade
PerfTime Start: CommitSqlUpgrade : Sat Sep 23 22:08:08 2006
<Func Name='ComponentUpgrade'>
There was a failure during installation search up in this log file for this message:
SQL Server Setup failed to parse the SQL script "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Upgrade\procsyst.sql". The error code is The system cannot find the file specified.
. To continue, correct the problem, and then run SQL Server Setup again.
<EndFunc Name='ComponentUpgrade' Return='2' GetLastError='0'>
PerfTime Stop: CommitSqlUpgrade : Sat Sep 23 22:08:08 2006
Gathering darwin properties for failure handling.
<EndFunc Name='LaunchFunction' Return='2' GetLastError='0'>
MSI (s) (B0:A8) [22:08:09:370]: Transforming table InstallExecuteSequence.

MSI (s) (B0:A8) [22:08:09:370]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (B0:A8) [22:08:09:370]: Transforming table InstallExecuteSequence.

MSI (s) (B0:A8) [22:08:09:370]: Transforming table InstallExecuteSequence.

MSI (s) (B0:A8) [22:08:09:370]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (B0:A8) [22:08:09:370]: Transforming table InstallExecuteSequence.

MSI (s) (B0:A8) [22:08:09:370]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
Action ended 22:08:09: CommitSqlUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.

|||

It seams there was a failure during previous upgrade. At this point I would suggest that you go to AddRemove Programs select MS SQL Server 2005 and Change. Then you select the SQL instance that failed and Database Engine. Proceed to Change or Remove Instance dialog and I assume there is an option Complete the suspended installation so select that one.

It is possible that setup needs access to the original installation media so if you installed from CD insert it before launching the setup.

|||

That did the trick!

Many thanks for the help.

|||

I ran into this issue and resolved it by changing the registry. Under: Software\Policies\Microsoft\Windows\Installer, I found that DisableMSI was not set to 0. For some reason it was set to 2. After changing this to 0, SP1 installed fine.

What's strange is there is nothing that should've set this to registry entry to 2.

Failure when installing SQL 2005 SP1 on Windows 2003 Server

Hello.

When I installed SQL 2005 SP1 on Windows 2003 Server, I received the following message:

"A recently applied update, KB913090, failed to install."

At the end, "Database Services" was marked as "Failure".

I have tried everything I could find in the knowledge base and on the forums, but still

was not able to install SP1.

For example:

http://support.microsoft.com/default.aspx?scid=kb;en-us;918357

Any insights would be greatly appreciated.

Can you search your hotfix logs (%WINDIR%/hotfix directory) for the text string "value 3" and include the 10-20 lines above it? That should give us a more descriptive error.

Thanks,
Sam Lester (MSFT)|||

MSI (s) (B0!C0) [22:08:08:355]: Note: 1: 2262 2: _sqlAction 3: -2147287038
MSI (s) (B0!C0) [22:08:08:355]: Transforming table _sqlAction.

MSI (s) (B0:A8) [22:08:09:370]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (B0:A8) [22:08:09:370]: Transforming table InstallExecuteSequence.

MSI (s) (B0:A8) [22:08:09:370]: Transforming table InstallExecuteSequence.

MSI (s) (B0:A8) [22:08:09:370]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (B0:A8) [22:08:09:370]: Transforming table InstallExecuteSequence.

MSI (s) (B0:A8) [22:08:09:370]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
Action ended 22:08:09: CommitSqlUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.

|||

It is possible that setup needs access to the original installation media so if you installed from CD insert it before launching the setup.

|||

That did the trick!

Many thanks for the help.

|||

What's strange is there is nothing that should've set this to registry entry to 2.

Failure when installing SQL 2005 SP1 on Windows 2003 Server

Hello.

When I installed SQL 2005 SP1 on Windows 2003 Server, I received the following message:

"A recently applied update, KB913090, failed to install."

At the end, "Database Services" was marked as "Failure".

I have tried everything I could find in the knowledge base and on the forums, but still

was not able to install SP1.

For example:

http://support.microsoft.com/default.aspx?scid=kb;en-us;918357

Any insights would be greatly appreciated.

Can you search your hotfix logs (%WINDIR%/hotfix directory) for the text string "value 3" and include the 10-20 lines above it? That should give us a more descriptive error.

Thanks,
Sam Lester (MSFT)|||

MSI (s) (B0!C0) [22:08:08:355]: Note: 1: 2262 2: _sqlAction 3: -2147287038
MSI (s) (B0!C0) [22:08:08:355]: Transforming table _sqlAction.

MSI (s) (B0:A8) [22:08:09:370]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (B0:A8) [22:08:09:370]: Transforming table InstallExecuteSequence.

MSI (s) (B0:A8) [22:08:09:370]: Transforming table InstallExecuteSequence.

MSI (s) (B0:A8) [22:08:09:370]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (B0:A8) [22:08:09:370]: Transforming table InstallExecuteSequence.

MSI (s) (B0:A8) [22:08:09:370]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
Action ended 22:08:09: CommitSqlUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.

|||

It is possible that setup needs access to the original installation media so if you installed from CD insert it before launching the setup.

|||

That did the trick!

Many thanks for the help.

|||

What's strange is there is nothing that should've set this to registry entry to 2.

Failure to start up SQL Server

SQL fails to start up - no error message is given- in SQL Server Service
Manager or in Enterprise Manager
The problem first occurred when starting up my computer and SQL failed to
start automatically (Auto start service when OS starts check box is ticked)
Leonard wrote:
> SQL fails to start up - no error message is given- in SQL Server Service
> Manager or in Enterprise Manager
> The problem first occurred when starting up my computer and SQL failed to
> start automatically (Auto start service when OS starts check box is ticked)
and the error message is:??
|||Have alook in the event log of WIndows to see where the problem is.
Jens Suessmeyer,
"Leonard" <Leonard@.discussions.microsoft.com> schrieb im Newsbeitrag
news:8664BBA4-F8CC-417C-B732-B4E9DEE008C9@.microsoft.com...
> SQL fails to start up - no error message is given- in SQL Server Service
> Manager or in Enterprise Manager
> The problem first occurred when starting up my computer and SQL failed to
> start automatically (Auto start service when OS starts check box is
> ticked)
|||Check SQL errorlogs as well.
Adrian
"Leonard" <Leonard@.discussions.microsoft.com> wrote in message
news:8664BBA4-F8CC-417C-B732-B4E9DEE008C9@.microsoft.com...
> SQL fails to start up - no error message is given- in SQL Server Service
> Manager or in Enterprise Manager
> The problem first occurred when starting up my computer and SQL failed to
> start automatically (Auto start service when OS starts check box is
> ticked)
|||I too have this problem. There is no error message. After installing sp4,
the system reboots and starts the Service Manager but it doesn't
automatically load my server\instance name. I have to do that manually.
Event viewer logs do not show any errors.
Have you found a solution yet?

Failure to start up SQL Server

SQL fails to start up - no error message is given- in SQL Server Service
Manager or in Enterprise Manager
The problem first occurred when starting up my computer and SQL failed to
start automatically (Auto start service when OS starts check box is ticked)Leonard wrote:[vbcol=seagreen]
> SQL fails to start up - no error message is given- in SQL Server Service
> Manager or in Enterprise Manager
> The problem first occurred when starting up my computer and SQL failed to
> start automatically (Auto start service when OS starts check box is ticked)[/vbcol
]
and the error message is:'?|||Have alook in the event log of WIndows to see where the problem is.
Jens Suessmeyer,
"Leonard" <Leonard@.discussions.microsoft.com> schrieb im Newsbeitrag
news:8664BBA4-F8CC-417C-B732-B4E9DEE008C9@.microsoft.com...
> SQL fails to start up - no error message is given- in SQL Server Service
> Manager or in Enterprise Manager
> The problem first occurred when starting up my computer and SQL failed to
> start automatically (Auto start service when OS starts check box is
> ticked)|||Check SQL errorlogs as well.
Adrian
"Leonard" <Leonard@.discussions.microsoft.com> wrote in message
news:8664BBA4-F8CC-417C-B732-B4E9DEE008C9@.microsoft.com...
> SQL fails to start up - no error message is given- in SQL Server Service
> Manager or in Enterprise Manager
> The problem first occurred when starting up my computer and SQL failed to
> start automatically (Auto start service when OS starts check box is
> ticked)|||I too have this problem. There is no error message. After installing sp4,
the system reboots and starts the Service Manager but it doesn't
automatically load my server\instance name. I have to do that manually.
Event viewer logs do not show any errors.
Have you found a solution yet?

Failure to start up SQL Server

SQL fails to start up - no error message is given- in SQL Server Service
Manager or in Enterprise Manager
The problem first occurred when starting up my computer and SQL failed to
start automatically (Auto start service when OS starts check box is ticked)Leonard wrote:
> SQL fails to start up - no error message is given- in SQL Server Service
> Manager or in Enterprise Manager
> The problem first occurred when starting up my computer and SQL failed to
> start automatically (Auto start service when OS starts check box is ticked)
and the error message is:'?|||Have alook in the event log of WIndows to see where the problem is.
Jens Suessmeyer,
"Leonard" <Leonard@.discussions.microsoft.com> schrieb im Newsbeitrag
news:8664BBA4-F8CC-417C-B732-B4E9DEE008C9@.microsoft.com...
> SQL fails to start up - no error message is given- in SQL Server Service
> Manager or in Enterprise Manager
> The problem first occurred when starting up my computer and SQL failed to
> start automatically (Auto start service when OS starts check box is
> ticked)|||Check SQL errorlogs as well.
Adrian
"Leonard" <Leonard@.discussions.microsoft.com> wrote in message
news:8664BBA4-F8CC-417C-B732-B4E9DEE008C9@.microsoft.com...
> SQL fails to start up - no error message is given- in SQL Server Service
> Manager or in Enterprise Manager
> The problem first occurred when starting up my computer and SQL failed to
> start automatically (Auto start service when OS starts check box is
> ticked)|||I too have this problem. There is no error message. After installing sp4,
the system reboots and starts the Service Manager but it doesn't
automatically load my server\instance name. I have to do that manually.
Event viewer logs do not show any errors.
Have you found a solution yet?

Failure to Connect Locally when Offline

Hi guys,
I sent this same message to the connection newsgroup, but I thought it
wouldn't hurt to post it here too.
We use replication, so a few clients connect to the network database,
and sometimes to MSDE on their computer when outside the office. They use
their domain Windows account to connect to both.
Here what is happening, they are able to connect fine to MSDE when they
are in their office, but when they leave the office, they can no longer
connect locally. They still use their domain account when they are offline.
Any idea why this would happen?
Thanks,
Maer
Is there a chance that MSDE cannot verify the domain account when they are
offline?
S
"Maer" <maer@.auditleverage.com> wrote in message
news:uwwU2Sq3HHA.5212@.TK2MSFTNGP04.phx.gbl...
> Hi guys,
> I sent this same message to the connection newsgroup, but I thought it
> wouldn't hurt to post it here too.
> We use replication, so a few clients connect to the network database,
> and sometimes to MSDE on their computer when outside the office. They use
> their domain Windows account to connect to both.
> Here what is happening, they are able to connect fine to MSDE when they
> are in their office, but when they leave the office, they can no longer
> connect locally. They still use their domain account when they are
> offline.
> Any idea why this would happen?
> Thanks,
> Maer
>
|||what is the connection error that they are getting?
relevantNoise - dedicated to mining blogs for business intelligence.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Maer" <maer@.auditleverage.com> wrote in message
news:uwwU2Sq3HHA.5212@.TK2MSFTNGP04.phx.gbl...
> Hi guys,
> I sent this same message to the connection newsgroup, but I thought it
> wouldn't hurt to post it here too.
> We use replication, so a few clients connect to the network database,
> and sometimes to MSDE on their computer when outside the office. They use
> their domain Windows account to connect to both.
> Here what is happening, they are able to connect fine to MSDE when they
> are in their office, but when they leave the office, they can no longer
> connect locally. They still use their domain account when they are
> offline.
> Any idea why this would happen?
> Thanks,
> Maer
>

Failure setting security rights on user account SQLServer2005BrowserUser${computerName}

I'm trying to install SQL Server 2005 Express on a Windows 2000 server, but I'm getting the following error message:

"Failure setting security rights on user account SQLServer2005BrowserUser${computerName}"

Can anyone help me please?

Help!! Need to get the sql server installed so I can demo to my client!

Failure sending mail: The transport lost its connection to the server

More and more often, I am seeing this error message in RS subscriptions. I would assume it means the IIS server can't connect to the corporate exchange server. However I was wondering if there is some timeout setting/configuration in RS or the IIS server (or any other kind of setting) I can change to help alleviate this problem.

Has anyone else experienced this? Or know how to fix it?

Thanks,

Jeff

UPDATE: After looking closer at the subscriptions, I have noticed that subscriptions set up by a RS Admin (who is also a server admin) seem to be working fine. It is the subscriptions that are set up by ordinary users that are failing...

We are getting this error for large reports being sent as Excel files. I think it's actually doing what it says: it's losing it's connection to the Exchange Server. I would think that makes it an Exchange configuration problem. Not sure tho. Any ideas?
|||I checked the log on this. It's an actual "no response" from the email server (0x800ccc13).

Error sending email. System.Runtime.InteropServices.COMException (0x80040211): The message could not be sent to the SMTP server. The transport error code was 0x800ccc13. The server response was not available at ReportingServicesCDOInterop.MessageClass.Send() at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)

|||

This looks like an email server availability issue. Have you checked with your IT folks about the availability of the server?

There should be no difference between subscriptions created by administrators and those created by end users. All E-mail messages are sent to the email server using the same account.

-Lukasz

|||It's not the email server - according the the logs. It appears to be a problem exporting huge reports to Excel. The email server is not even receiving a HELO request. Reports scheduled just before and after are being sent, and if we reduce the date span or switch the format to CSV, it sends successfully.
|||

There are a number of threads on exporting large reports to excel and other formats.

For a run down of some of the solution vectors you can look at the posts from Brian and Bruce on this thread:

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

Hope that helps,

-Lukasz

|||Thanks, but none of them actually provide a solution...that works.
|||

Are you able to make the export to excel fail when you render the report interactively? How much data are you putting in your excel file?

-Lukasz

|||I have the same problem, I have a large report that renders 26,301 rows for Excel. When I setup the subscription in Report Services with the Excel render option, I get the status message - 'Failure sending mail: The transport lost its connection to the server', even though it renders the report interactively just fine. Any idea on what is causing this problem or how to fix it?|||

Check the email server your using for timeouts on sending messages or size restrictions on outbound messages. It could be that your 20K+ row excel doc maxes out the email server capability. You may be able to find information in the email server logs related to the request. From the error, it appears report server was successfully communicating with the email server, but then the connection was lost part way through the send.

-Lukasz

Failure sending mail: The transport lost its connection to the server

Has anyone else experienced this? Or know how to fix it?

Thanks,

Jeff

Error sending email. System.Runtime.InteropServices.COMException (0x80040211): The message could not be sent to the SMTP server. The transport error code was 0x800ccc13. The server response was not available at ReportingServicesCDOInterop.MessageClass.Send() at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)

|||

This looks like an email server availability issue. Have you checked with your IT folks about the availability of the server?

There should be no difference between subscriptions created by administrators and those created by end users. All E-mail messages are sent to the email server using the same account.

-Lukasz

There are a number of threads on exporting large reports to excel and other formats.

For a run down of some of the solution vectors you can look at the posts from Brian and Bruce on this thread:

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

Hope that helps,

-Lukasz

|||Thanks, but none of them actually provide a solution...that works.
|||

Are you able to make the export to excel fail when you render the report interactively? How much data are you putting in your excel file?

-Lukasz

Failure sending mail: The transport lost its connection to the server

Has anyone else experienced this? Or know how to fix it?

Thanks,

Jeff

Error sending email. System.Runtime.InteropServices.COMException (0x80040211): The message could not be sent to the SMTP server. The transport error code was 0x800ccc13. The server response was not available at ReportingServicesCDOInterop.MessageClass.Send() at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)

|||

This looks like an email server availability issue. Have you checked with your IT folks about the availability of the server?

There should be no difference between subscriptions created by administrators and those created by end users. All E-mail messages are sent to the email server using the same account.

-Lukasz

There are a number of threads on exporting large reports to excel and other formats.

For a run down of some of the solution vectors you can look at the posts from Brian and Bruce on this thread:

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

Hope that helps,

-Lukasz

|||Thanks, but none of them actually provide a solution...that works.
|||

Are you able to make the export to excel fail when you render the report interactively? How much data are you putting in your excel file?

-Lukasz

Sunday, February 19, 2012

Failure Audit - Event ID: 18456

Hi I'm using SQL Server 2005 and ,
I keep getting the following message in the Event Viewer:
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 1/21/2008
Time: 8:32:00 AM
User: domain\sqladmin
Computer: TCLG-MOSS-DB
Description:
Login failed for user 'domain\sqladmin'. [CLIENT: <local machine>]
Can someone please shed some light on this......
Thanks,
ShelleyYou have audit login set either to "Failed logins only" or "Both failed and
successful logins". You can change the setting vai SQL Server 2005 Management
Studio. Right click on the server instance and pick Properties. Select
Security, and you'll see the audit options. You need to restart the SQL
instance for the audit level cahnge to take effect.
Linchi
"Shelley" wrote:
> Hi I'm using SQL Server 2005 and ,
> I keep getting the following message in the Event Viewer:
> Event Type: Failure Audit
> Event Source: MSSQLSERVER
> Event Category: (4)
> Event ID: 18456
> Date: 1/21/2008
> Time: 8:32:00 AM
> User: domain\sqladmin
> Computer: TCLG-MOSS-DB
> Description:
> Login failed for user 'domain\sqladmin'. [CLIENT: <local machine>]
> Can someone please shed some light on this......
> Thanks,
> Shelley
>
>|||Hi, thanks for the reply.
This error basically happens with unsuccessful attempts to log on to the
server?
Would like to know the cause of the error.....
Thanks,
Shelley
"Linchi Shea" wrote:
> You have audit login set either to "Failed logins only" or "Both failed and
> successful logins". You can change the setting vai SQL Server 2005 Management
> Studio. Right click on the server instance and pick Properties. Select
> Security, and you'll see the audit options. You need to restart the SQL
> instance for the audit level cahnge to take effect.
> Linchi
> "Shelley" wrote:
> > Hi I'm using SQL Server 2005 and ,
> > I keep getting the following message in the Event Viewer:
> >
> > Event Type: Failure Audit
> > Event Source: MSSQLSERVER
> > Event Category: (4)
> > Event ID: 18456
> > Date: 1/21/2008
> > Time: 8:32:00 AM
> > User: domain\sqladmin
> > Computer: TCLG-MOSS-DB
> > Description:
> > Login failed for user 'domain\sqladmin'. [CLIENT: <local machine>]
> >
> > Can someone please shed some light on this......
> >
> > Thanks,
> > Shelley
> >
> >
> >|||Correct.
Linchi
"Shelley" wrote:
> Hi, thanks for the reply.
> This error basically happens with unsuccessful attempts to log on to the
> server?
> Would like to know the cause of the error.....
> Thanks,
> Shelley
> "Linchi Shea" wrote:
> > You have audit login set either to "Failed logins only" or "Both failed and
> > successful logins". You can change the setting vai SQL Server 2005 Management
> > Studio. Right click on the server instance and pick Properties. Select
> > Security, and you'll see the audit options. You need to restart the SQL
> > instance for the audit level cahnge to take effect.
> >
> > Linchi
> >
> > "Shelley" wrote:
> >
> > > Hi I'm using SQL Server 2005 and ,
> > > I keep getting the following message in the Event Viewer:
> > >
> > > Event Type: Failure Audit
> > > Event Source: MSSQLSERVER
> > > Event Category: (4)
> > > Event ID: 18456
> > > Date: 1/21/2008
> > > Time: 8:32:00 AM
> > > User: domain\sqladmin
> > > Computer: TCLG-MOSS-DB
> > > Description:
> > > Login failed for user 'domain\sqladmin'. [CLIENT: <local machine>]
> > >
> > > Can someone please shed some light on this......
> > >
> > > Thanks,
> > > Shelley
> > >
> > >
> > >

Fails to restore db

SQL2K, Win2K Advaced Server, Win2Kpro wkstation
I get the following message when I try to restore from a backup to any db on
my server.
In this case the backup is for the db tcaPlant_Grimes and I am trying to
restore it to tcaPlant_Hays.
I have done this successfully hundreds of times in the recent past.
Under the options tab I set ...
- Force restore over ON (b/c the db already exists)
- Restore As = full absolute pathname of the MDF
- Restore As = full absolute pathname of the LDF
I know the backup is good b/c I can create and restore using the same backup
on another server in the same network!
This has been happening for a week or so.
begin 666 clip_image002.jpg
M_]C_X `02D9)1@.`!`0$`8 !@.``#_VP!#``H'!P@.'!@.H(" @.+"@.H+#A@.0#@.T-
M#AT5%A$8(Q\E)"(?(B$F*S<O)BDT*2$B,$$Q-#D[/CX^)2Y$24,\2#<]/CO_
MVP!#`0H+"PX-#AP0$!P[*"(H.SL[.SL[.SL[.SL[.SL[.SL[.SL[.SL[.SL[
M.SL[.SL[.SL[.SL[.SL[.SL[.SL[.SO_P `1" ">`C\#`2(``A$!`Q$!_\0`
M'P```04!`0$!`0$```````````$"`P0%!@.<("0H+_\0`M1 ``@.$#`P($`P4%
M! 0```%]`0(#``01!1(A,4$&$U%A!R)Q%#*!D:$((T*QP152T? D,V)R@.@.D*
M%A<8&1HE)B<H*2HT-38W.#DZ0T1%1D=(24I35%565UA96F-D969G:&EJ<W1U
M=G=X>7J#A(6&AXB)BI*3E)66EYB9FJ*CI*6FIZBIJK*SM+6VM [BYNL+#Q,7&
MQ\C)RM+3U-76U]C9VN'BX^3EYN?HZ>KQ\O/T]?;W^/GZ_\0`'P$``P$!`0$!
M`0$!`0````````$"`P0%!@.<("0H+_\0`M1$``@.$"! 0#! <%! 0``0)W``$"
M`Q$$!2$Q!A)!40=A<1,B,H$(%$*1H;'!"2,S4O 58G+1"A8D-.$E\1<8&1HF
M)R@.I*C4V-S@.Y.D-$149'2$E*4U155E=865IC9&5F9VAI:G-T=79W>'EZ@.H.$
MA8:'B(F*DI.4E9:7F)F:HJ.DI::GJ*FJLK.TM;:WN+FZPL/$Q<;'R,G*TM/4
MU=;7V-G:XN/DY>;GZ.GJ\O/T]?;W^/GZ_]H`# ,!``(1`Q$`/P"_XX\<:KX:
MUR*PL8;-HFMHY"98=QR<YYS[5SW_``MCQ#_S[:;_`. __P!>NB\2VFC77C6Y
M_MR(-;#2H%63=M\EGD"!\^VZN<\/>%+6VU.]M->@.$\OV>X^S1AB!^[7/FGV.
M1M]<YKT*<:7(G*.IA)SYM&.'Q7\0'I;Z;_X#_P#UZ7_A:OB#_GWT[ _P'_P#K
MTFO^'88Y9]4U*YV6<%O;1C[';JKR2N@.8+MS@.<<ECUJC+X;TBV\.VNK3ZS/NO
M?/6VC2VR)'1L+D_P@.]\^M:J%%KX2&Y]S1_X6IX@._Y]]._P# ?_Z]*/BGK_\`
MS[Z=_P" _P#]>JC^#H$U"70EOI3KD-MYS1^6/(+!=QC#=<A>^,9I;_P6]GIM
MM<1F[F:XBB=;A8E-L6<X";@.=P/(Y(Q1R4.P7J=RW_P`+2U__`)]]._\``?\`
M^O2_\+2UW./(T[/IY'_UZI3>%+;S]0TVTOI9-4TV$RSH\86%]H_>!&ZY&1C/
M6NMLK'0IM0\/:,;>5K:\TL7#0F&/;*=K-N=_OALC/!QP.U3*-%+2(TYOJ8'_
M``M#7O\`GWT__P`!_P#Z]*/B?KW_`#[Z?_X#_P#UZYB%--?58DDGN(=/:0!Y
M74>8J=S@.<5UNIZ$BV\ZC1[%;>>2.*QNK&?S&B);"O+SRI'MUJ I4Z2:7*2I3?
M4C'Q.UW_`)]]/_\``?\`^O2_\+-UW_GAI_\`X#__`%ZADM]'M_%P\.-IRM:"
MX6V>?)^T;R<9#YP!N(XQTXIGBC0[?1=&TI$C3[49KJ*XF7/[W9)M!Y]J7)2N
MER[CYI]RU_PLO7/^>%A_X#__`%Z4?$K7/^>%A_WX_P#KU@.V6C7TRV]V;0M:-
M(NY]ZX*[@.#QG-='/8:9=>.+GPV--M[>$R-%;RP!E=7"Y4L23D=<C%#ITE]D2
ME-]1@.^).N?\`/"P_[\?_`%Z7_A9&M_\`/"P_[\?_`%Z;J'AVVNM*LAI42+J%
MND27J[N'#@.8EYZ+G()J^/#NB3:1IU_'"YMX;*YN+IE8J]P8V"C&>@.W<@.>E3R
MT?Y1WGW*8^(^M_\`/"P_[\?_`%Z7_A8VM=X+#_OQ_P#7K/M8+;6M)U.86D%I
M=6$(G4VX*HR9PP().3Z&G>&H8DMM6U62))GT^V#11NH*[G.T-SZ53ITK/W1<
MT^Y?'Q%UK_GA8_\`?C_Z]+_PL36O^>%C_P!^/_KU2O8+70M/TUFM(;NZOK?[
M3*TX+*%8G:% (P<=>U;-UHNFZ5H^H:C#9Q7"M%:3VJW67,:R9# X(R<@._I2<
M*2^R/FGW*@.^(>L_\\+'_`+\?_7IP^(6L_P#/&Q_[\?\`UZL:%HNG:FMIJ36D
M026.X26!R1&)44$,.>%]LU5?2H+_`$6)HXK!;Q[Z.$2:>Q:-%8 ?/R<<GBER
MTKVY0O/N/_X6!K'_`#QLO^_'_P!>E'C_`%C_`)XV7_?C_P"O5>\FT;2]<N=.
METM9K*W9XF<G]^6 (R&SC[W3CI53P];V5SJ)CO"C-L)MXI6V1S2=E9NPJO9T
M[7Y1<TKVN:@.\?:O_`,\;+_OQ_P#7IW_">ZO_`,\;+_OQ_P#7J 4:#'/>6MK?:
M?';.B2S32V;_`+J:-1]U3DX<'%4-.AM-=BO85M(K6:"W:XMWB! (7J'Y.3C&
M,=ZGDI?RCYI]RV/'FK_\\;+_`+\?_7I?^$[U;_GC9?\`?C_Z]4?%5G;6'B*>
MVM8A# JQD*O.,H"?YUK2:99I;&>UT^VOM,%OD312YNF..7QGC!ZC' %')2LG
MR[BYIWM<@._X3K5O^>-G_`-^/_KTH\<ZK_P`\;/\`[\U#J6G6`T_119QS"YO(
M020H(<[L$D YS]*M0^&H(6L[F<7 A:^2VEAF"9;/0C:>G8YYHY:-KV"\^XW_
M`(3C5?\`GC9_]^:7_A-]5_YY6?\`WYHD\/V]WJVJ?9/.2TL79710N\L6(54R
M<8XZDU5O='L[&>XBDU `K;+-`IQN=C_RS..,CVH4*+Z Y3[EL>-=4_YY6G_?
MFE'C35/^>5I_WYJCHUI!);ZA>SQB864(=86.%<DXYQS@.=:GO+>S6PTW5 /LH4
M76]);>-RJDJ<9!Y(SUQ0Z=*]N4.:=KW+'_"9ZG_SRM/^_-._X3+4_P#GE:?]
M^14EQHMG+XXDTU(_)M5 ?8A[! Q&?>FZ=I]IK]NLOV=+)DNTB/D9PR-SSGN,
M=:GEI6ORCO/:X@.\8ZE_SRM/^_(I?^$PU+_GE:?\`?D4MO96>KB^B2UCLS:2H
M$>+))4OLPV3SZYXJ1[&RN+K5=.2T2'[!$[Q3*278IP=V>#N_# %'+2_E"\^Y&
M/%^HG_EG:?\`?D4H\7:C_P`\K7_OR*@.NHTN?#=G?E%2:.9K9BH \P 9!/N.E
M90JU2IOH2YR74W?^$MU'_GE:_P#?D4[_`(2S4?\`GG:_]^16$*<*?L:?87M)
M=S<'BK4/^>=K_P!^12CQ3J'_`#SMO^_(K$%.%+V-/L'M)=S:'BB__P">=M_W
MZ%+_`,)/?_\`/.V_[]"L84X4>QI]@.]I+N;/_``DU_P#\\[;_`+]"E'B6^_YY
MVW_?H5CBE%'L:?8/:2[FQ_PDE]_SSM_^_0I?^$CO?^>=O_WZ%9 IPH]C3[![
M27<UO^$BO?\`GG;_`/?H4[_A(;S_`)YV_P#WZ%9 IXH]C3[![27<U?\`A(+S
M_GG;_P#?H4O]O7G]R#_OT*RQ2BE[*'8/:3[FH-=N_P"Y!_WZ%+_;EW_<@._[]
M"LP4X4>RAV#VD^YIC6[K^Y!_WZ%+_;5U_<@._[]"LT4X4>RAV#VD^YH_VS=?W
M(?\`OT*7^V+G^Y#_`-^A6>*<*7LH=@.]I/N7_`.U[G^Y#_P!^Q2C5KC^[#_W[
M%4!3A1[*'8/:3[E\:I<?W8?^_8I1J=Q_=A_[]BJ(IPH]E#L'M)]R[_:4_P#=
MB_[]BE&HS_W8O^_8JF*<*/90[![2?<MC4)O[L7_?L4X7\W]V+_OV*J"G"E[*
M'8/:3[EV&YFFDV#R5X)),8[?A4VZ3_GO;_\`?G_ZU5;+_7-_US;^5<=XFU*[
M\&:M_;,5R;RSU [9=.DD^8.!PT7H/45RUK0E9(Z*5Y1NV=WND_Y[V_\`WY_^
MM7'>,-4_M#PG,\1 C%R(\A N[:Q'Y9%6/!\-W<VSZ]?ZB+N?4@.&$<+YA@.0=%
M4>H[FL35?^1%E_Z_7_\`1C5FG=/0MJS6I1^*%ZUMXAFM@.BLMYIL$;D]5`?Q
M_P!\XKF=/\2W]EJ7V^5OM<HM&M%\X_=C*X &/0=*]>UWPIHVN7ZW6H6S2S+"
MB!A*R\ 9Z ^YK-_X5[X8_P"?"3_P(?\`QKKIXFE&"BT9RIR;NC@.;GQE<7S31
MWUA!<6<\42-;%V4!HQA9%8<AL<52U'7IM1TJPTYK:&".QDE>,Q9&?,;)&.P'
M:O3/^%?>&?\`GQD_[_O_`(T?\*^\,_\`/C)_W_?_`!JUBJ*V3_KYB]E-]3@.F
M\8W3R/>BS@.75I(/(?4@.Q\PC&"VW[H8K\NZHX/%$]II4UE9VJ6[W$:QR2K*Y
M"G/RH3M4Y'45Z%_PK_PU_P`^,G_?]_\`&C_A`/#7_/C)_P!_W_QI?6J/9_U\
MP]E/N<%/XLGE6ZFBL;>WU"]B$5S>QEMTB_Q84\*6XR1Z4Z+Q?>PZII.H16\*
MR:7:K:HO)$B $'/H2&/2N\_X0'PW_P`^4G_?]_\`&C_A`O#?_/E)_P!_W_QH
M^M4>S_KYA[*?<\QAOQ:ZK'?V=M'"(I Z0N3(HQV.[J*O3Z^#:W<&GZ=%IWVY
M]US)%(S-(,YV@.G[JYYP*]!_X0/PY_P`^4G_?]_\`&C_A!/#G_/D__?\`?_&F
M\72?1_U\Q>QF<EI?B&VNM2>_OUAM=76/-MJ#@.F$.!@."2,<<CC=Z\U5GU^.73
M[;3+_3X+];%I?+G6YD7>7;<QR.M=Q_P@.OAW_`)\G_P"_[_XT?\(-X=_Y\G_[
M_O\`XU/UFC>]G_7S'[*9Y>DB1WBW$<2KLD$BIG.,'(&>M;MQXJ:74;G4[;3H
M;6_N0PDG$K/PPP<*> <#J.E=I_P@._A[_`)\W_P"_S_XT?\(1X?\`^..._^_S_
M`.-4\72>Z?\`7S%[&://&U>[\T20R&!C:+:/L/WXPH!!SZXYJ];^*+ZUM=-@.
MMXXD&GI+&I(W"59#E@.P/%=M_PA/A_P#Y\W_[_-_C1_PA6@.?\^;_]_F_QI/%4
M7T8>RGW."DU<"PEL;&T2SM[@.@.S 2-(SD=/F;D#V[U:\/7MM%%J.G7DH@.AU"W
M\OSB/N.IW+GV)X)KM/\`A"M _P"..._\`O\W^-'_"%Z#_`,^C_P#?YO\`&AXJ
ME:UF'LIG#1ZQNLH+*_M([V*UR("9&0IDY/(^\/0'I5S_`(2JXGBOH]0M(KM+
MXQEP&

+Y?W0NWH*Z[_A#-!_Y]'_`._S?XT?$;H7_/H_P#W^;_&E]9I=G_7
MS#V4^YR-IXGGM+F%X[6+[/;PR0Q6^YL!7^]ENI/N:@.;6%CL)+/3[-+%)R#,Z
M2L[R`=%R>@.!YXKMO^$.T+_GT?_O\W^-'_"'Z'_SZ/_W^;_&CZS2[/^OF'LIG
M*)XE;[<=2ETZWEU J1Y[$[<D;<^7]TG%4M.U#[ \X:VBN8KB(Q21R<9!]".0
M?<5W/_"(:'_SZO\`]_6_QH_X1'1/^?5_^_K?XT?6J79_U\P]E,Y$:_<PM:"P
MBCLX;,EHH5RZECP6;/WB<]ZMQWUG)H]TEDT6G74W%RDC,PG3J/+/$SU'?(K
MI/\`A$M$_P"?5_\`OZW^-'_")Z+_`,^K_P#?UO\`&D\32[,/93.5U+7(=6N9
M+N?2XUN9% \Q9WP"!@.';T["I'\0L9YKR"P@.M[Z>/8US&QRHP`2J]%) KI_\`
MA%-%_P"?5_\`OZW^-'_"*Z-_S[/_`-_6_P`:/K-+:S_KYA[*9R]OK\\"Z>RV
M\9FT[B"4D_<[J5Z'Z]:?_;YCM!;V=C%;`7:W>[>SDR#Z]JZ;_A%=&_Y]G_[^
MM_C2_P#"+:/_`,^S?]_6_P`:/K-+L_Z^8>RGW.9?7C)=7<C641@.ON;FW+L5=
MLY# ]5(/3%0Q:DD*W20V,"1W$/DA>24&<[@.3U/O76?\`"+Z/_P`^S?\`?UO\
M:/\`A&-(_P"?9O\`OZW^-'UFEV?]?,/93.2T_4)+!I0$6:&=-DT+_=D';IT(
M/.:FGU07!MHWM4%I; B.V5R!D]26ZDD\YKJ/^$9TG_GW;_OXW^-'_"-:3_S[
MM_W\;_&G]:I7O9A[&9S]UX@.FGUA=5A@.2WN1]\JQ97& ,$'M@.8I#K4L2*FGP)
M8*)?.(C8MN8=,D]AV%=%_P`(WI7_`#[M_P!_&_QH_P"$<TK_`)]V_P"_C4OK
M%+LP]E/N<_)K3^7*MI;1V;3N'E>)B2Q'( ST&><"GRZY)(MP\=M%#<72[9YT
M)RX[X'09[XK>_P"$=TO_`)]V_P"_C4O_``CVE_\`/!O^_AI?6*79A[*?<P;J
MZ@.CT&TTZ&02N9#<3$=$8C 4?AUK.%=?_`,(]IG_/!O\`OX:7_A'],_YX-_W\
M--8JFNXG1DSD13A76?V!IO\`SP;_`+[-']@.Z;_SP;_OLT_K=/S#V$CE13A74
M_P!A:=_SQ;_OLTO]AZ?_`,\6_P"^S1];AYA["1RXIPKIO[$T_P#YXM_WV:7^
MQ;#_`)XM_P!]FCZU#S#V$CFA2BND_L:P_P">+?\`?9I?['L?^>3?]]FCZU#S
M#V$CG!3A70_V18_\\C_WV:7^R++_`)Y'_OLTOK4/,/82.>%/%;W]DV7_`#R/
M_?9I?[*L_P#GF?\`OHT?6H>8O82,(4HK<_LNS_YYG_OHTO\`9 EI_SS/_`'T:
M/K4/,/82,04X5L_V;:?\\S_WT:7^SK7_`)YG_OHT?6H>8>PD8XIPK6_L ^U_Y
MYG_OHTOV"V_N'_OHT?6H>8>PD90IPK3^PV_]P_\`?1I?L5O_`'#_`-]&E]:@.
M'L)&8*<*T?L<']P_F:7[)!_</YT?68!["1GBG"KWV6'^Z?SI?LL/]T_G1]9A
MYA["12%.%6_LT7]T_G2_9XO[I_.CZS /82*HIPJQY$?]W]:7R8_3]:/K, ]A
M(BCN8+023W,R0Q+&V7<X`XKGX6\-)XAGUR?5X[JZ=0D(F8%;=<<A![^M=(8(
MF&&0,/0\TGV2W_YX1_\`?(KGJ3A-W-J<905CG=(?PUH=[>36.L)';W;!S:;_
M`-U$W=E],^E9&ILK^ W96#*UXQ!'0_.U=S]DM_\`GA'_`-\BN>\=1I'X98(H
M4>:G`J$XI.Q;4FU<ZJX_U@._W%_D*CJ2X_P!8/]Q?Y"HZR+"BL?Q!XDMM!C16
MC,]S*"4B!QQ_>)],\?G7#7'B[7KB0/\`V@.8,#&V!`H_7/-8U*\*;LSU<'E.*
MQD>>FK+NSU&BO-]-\;:M9RJ+N3[;!NRZN '(]FKO=+U.VU>Q2[M6RC<,IZHW
M=3[TZ=6-3X3+&Y;B,&U[5:/JMBW1116IYX445G3:Y:0SRPI%=7)@.8K.UO 76
M`CDASV..>] &C14?VB#S(X_/C$DJ[HT+@.,X]0.IIIN[595A-U )'.%0RKN8Y
MQP,Y//% $U%0_:[7SEA^U0>:_P!V/S5W-VX&<GH:?YT/G^1YT?G;=WE[QOQZ
MXZXH`?156ZU.RL[6ZN9KF/9:*6G"N"R8[$9X/M2PZC9W'F&&XC=(D#O*KJ4`
M.>I!XQCF@."S147VFW\D3?

?*8$B3S!M('4@.YQ56ZUJTMC;B-9KPW._RA9IY
MV=N-W0]LB@."_15>UOH+NT-U&Q2-2P?S!M,94X8-GH00<T\W5L+?[2;F$0?\`
M/7S!LZX^]G'6@."6BHY+FVA1'GN884?[KR2!5;Z$GFHM,ODU33H+Z)&1)UW* I
M()ZD=OI0!9HJA8:S;:A-(D0=55!+'(PPLT9)&]?;(/X8/<4B:YI\NFRZC'*S
MP1':VU"6)XP`.^001Z@.B@.#0HI@.G@.9F59XF95W,%<' ]3[>],^V6AA$WVN#RC
MDB3S5V\<'G..X_.@.":BHGNK:.(2O<PI&5W!VD 4CUSGIR.?<4KSPQ0^?)-&D
M6 ?,9P%YZ<GCF@."2BH+B^M;2!YIIXU5$+D;AD@.+NX'?CFJ]CK-O?2I$(+NW>
M1/,B%S"8_-48R5]<9&?J* +]%,6:%IV@.6:-ID&6C#@.LH]2.HZC\Z2.>"7?Y4
M\4GEG#['!V'T..G0]: )**H+K5B][-;I<1.D%K]IDG2161%R00<=",9^E-M]
M6-PQC^Q2QS/$9K:.1@.#<(,<C^Z>1D'IN'K0!HT5#9W<5]:K<0$E&)&&&"K D
M,I'J""#[BIJ "BBB@. HHHH **** "BBB@. HHHH **** "BBB@. HHHH ****
M"BBB@. HHHH **** "BBB@. HHHH **** "BBB@. HHHH *YOQ[_P`BRW_75*Z2
MN;\>_P#(LM_UU2FMP.HN/]8/]Q?Y"F 9('K3[C_6#_<7^0I@..&!]#2 \CU34
M#J&MSWDRLZ&8[8W;H@./W<^GTKMKKP]I7C72(;_PZL5I>0JL<MLQP,#CGW]#W
M_EP^HV+6.LW%E*^W9,1YCJ0"I.0V.N.:[M]7TGP!I$5KI)BU#4;I5DEF)RI7
MJ"<=L'@.>^3[^;"W-+VFW7_@.'W]>ZH8?ZI?GM[MMK65^;I;\;E'Q+::!X9\/_
M`-AI$MYJ<I#R39P8SZ^WLOXFL3P9J;V&NK 6Q#=+M<'H".0?KVK=\4C0_$FA
M_P#"26EPEI>J0D\#GF1L=/KCH>X'/3CEO#EO)<:Y"8P28R/Q)/3\N:J-_;KE
MV\NQSUN5Y34=6_/?7F_FTVZ6[6Z'J]%*>II*] ^(%4X8'K@.U@.:?IH=H=.OH
MKD312R>6ZPLXN@.6+!E*@.X/./F(Z>E;U4+C7=/M9GA:=V:,XE\F)Y!$?]LJ"%
MXYYQQ0!C74?[O4+:>VD;5[J5WLI3$6(!_P!41(.$V=QD8P>O> ,:6B>$M6D^P
MJ;YY;IP_E9D+>8V"IQGTQCZUU8<$#:X(89&#]X>HHW#=C<,^F>:8'*#3(X_!
MMW(M@.!>--*^X1?O<^>>0>HX]*@.73;PW#027]P-66:650EHH&XAMC&?&2G*]^
MPXXKL]PR?F&1UYZ4;P%^^-OUXHN!R\UO8WVA7EA9Z6_V];"2-PUOM(<KT9CP
MQ+#(.3TZBJJBVGUJ2[M;1O[,A2W^UHMJR!\++_ 5&_:Q0G /X]*ZN"]CN;FZ
MMU#[K1U1\]"64,,?@.14^_+8W@.GTSS0!R:6,=[XBLYTL\Z4\SO#&\15 XB(9]
MA'R@.G;U R1T]4DT^Z_X30K8L]A"N2LL=NK(N84R "-O)_45U4L\<,4LLL@."1
M*7<YZ #)-$,\=Q"DL4@.:-U#J0>Q&0: .7N;.\32TLG>6.2"[-Q?RI")%G1MQ
M+JAX(WX)3J,'@.\9C5(8;=%\R9[>>X>87DNG A7"JH2. # SSRP`X;N0:Z_..
M_3GK1O\`XMXP>^:+@.<?H"K96\<NN6DLR2)LM5EMC(4(D?<FT` A"?E/ICOBM#
M3[:Y;X?"UBADCN6LI42+&UPQW8'L>16S:WT=VUP(]P^SSF!R>[ `\>W(J<G'
M)./<T <UJ;SFPTO4]&C\]GMS:QE4RB"55PY'H'1 ?0$GM21Z5)9:Y9Z5;0.-
M.:6&\\W[WE-"N.6/]XK$,>FXUT%O;P6GF>3A%E<N5W?+D]<#MGKQWS4NX<_,
M..O/2@.#E[.V2Q\(`_P!GJ)+B5Q<,T1)13*WSLH^9@.,#Y1ZCMFLFU-G!XF2;4
MEDFM-\K0-)8%`_[J+D1(N,=>WUYKO]P^]N'US43V\4EW#=L"9H%=8VW'@.-C=
M_P"@.BBX'(9L+?Q';7-_;XL)$N'L8GMV?8I\D$^6 =H+;R 1W[=*?+9W*SI=R
M326FD>9*UNAM!.(MVW;F(@.[0</C@.XW#IGC=N]2TNVU19)))9+RWC:-A!&\IB
M5MK'>$!VYV@.C/I5JSU*WOC,T$F1#+Y6_(PYVJV5/<884`<Q8Z3'#8ZXWV::9
MQ8JL$MQ#B1@.8G/ [')Z#D<#VK1L[2]L;BPN[ZYDO8UMA#&PA"-;,X7.X+]Y3
MA1GJI'OQT!;!`)Y[#/-07MY'865Q=RY*6\32NJ\MM R<"@.#D]/M+BS>)IY+J
M\U.S2226V2S5/,<H0=TV/G4[LCD]1P.T$=M-+J*FU\VXLEMT-PL5E]G1T652
M\:C +G'][DCN>:[E7W(I!X(!`I2Q/4Y_&BX'&ZB;>YFU"XTVT:*V6PB+R+;F
M%7VW`9^"!G"@.YR.GK6]J;+-JNBK;X+&X:8;>/W(C8$_3+IQ[CTK4+ G#,#GL
M3UJE!I-E:I,L*NGFJ4+"4YC7^ZAS\@.&3@.#I0!3TJX5+R^*I(T5WJ#K"R+ E1M
MC4,3_=&Y''N?K6S3(8XK>%((%6.-% 5%Z "G%E'5@./J:0"T49&0"1D]!GDU#
M;7=O=JS02JX21HVQV93AA^8H`FHHR/6D!!Z$''7F@.!:*KK>Q-J+V(SYB0"<M
MQMVEBO7UR#5B@. HJO]NA_M%+$$F5X6F!&"H4,%/XY85."",@.@.CU!H 6BD!!&
M00<^AI<@.=2/SH **,CU'3/6DR,D9&1U&>E "T5%<74%K:S7,TJK%`A>1NNT`
M9/2GAT*A@.Z[3T.: '456?4+5)9X3)F2V"&1%4D@.-G;P.O0]*LY&[;D9],T %
M%)N7.-PSZ9I:`"BBB@.`HHHH`****`"BBB@.`HHHH`****`"BBB@.`HHHH` *YOQ
M[_R++?\`75*Z2N;\>_\`(LM_UU2FMP.HN/\`6#_<7^0J.I+C_6#_`'%_D*CI
M`8/B?PTNNQ+-#((KR%2J,W*N.NT^G/>O/;O3-0L9FAN;*977^ZNX?F.*]@.IK
MHDB[9$5QUPPR*PJ4(5'=GKX+.,3@.X\D+./9GD-MIMY=.%6%T4G!9AT_X#U-=
M_P"&?#O]E1^9.H\SJH/)!/5O8^U;R0Q1$F.)$)X)50*?54Z4*?PF6.S/$8VR
MJ/1=%L%%%%:GFBJ0&!/(S7)G4)]'TJ6S%W%::C%),W^DV[/]N8DE2AR,YX7/
M/3%=6!DX%4+77M+O+G[+:WZ22DD!0&&2.H!(P3P?RH YIK>>?5-VI7L-M?O<
MJ\,7V,O/Y>00L;AN%QD-@.<...G/-/M=,M[7PGH]Y:VBI?L]K^_P!N9?F=006/
M.,'&.F..E=EA@.,8/-&&W8P<T[@.>=7-HYTN8SWT;ZBENWVR&"S9)F8X!\V3<<
M@.'E>W3&.*Z+78=/M7M]-\BUMK?YI5>X@.,T;OG&T1@.C?(>N3SSQDFNCPV=N#D
M=J &P2 <=Z+@.<MX(:9].NWG,AD80EFD!!)\A?6JUKID%IX3T6\M+54U!FM09
M]O[WYF (+'G&#C!XQQTKLB#P2#STH(8'!!R:+@.<-9:<;F-XKBZAN-0-G,MW:
MQV165Y#&1B5RQW#=@.KQ@.G&,<4OV6U^Q6"Z'%`ANH5L+\0*%W, 0IVOZ' ER?U
MZ5V274<EY/9@.MYMNJ-(", !P2N/7H:1KVV%XEF;F/[2ZEEAW?.0,9./3D47
MY.TBO'M?M>IAFA2=+:\/_3"-&# @.=5$IR3W&>JTXVEI>ZW8QVT*OHCW!,2("
M(F<0R;\#^X?DR/NDY]Z[$ D\`FC#$XY)HN!RUC&+35;V>YC/]GQ:@.ZQ!1A;>
M3:@.#L.XQP#_#^.:M^*(YG-GOGAAL%9_M33P^;'G V;U!'&<]>,XSVK> 8G@.$
MD4 -DX!R/TI <?HFEVKZE/)(1>K%9*]O(T)2-<RS$;$)( `P%/8=.M.LK"VM
M/#>BR/ %LI(HWU-F!)<>5\ID[E0Q&0> .O%=<0<9.<>M5+O48[.:.$Q7$\T@.
M+".WCWL%! +'T ) S[TP.:CL[:]U^RCC@.$FBL\K6T>"(B1$-^!_<+8X^Z><"
MNIAN(9)IK>+(:V*JXVD`94$`>O&.E3D-GG//ZT$$<&D!@.6>I6FBRWMOJ<OV:
M9[J219I5(6X5CE=K?Q;5(4CMC'3%58=-L;V/7[VXL5DE\^1HC/%\T>(4(V@._
M=.?3N/:NCGNDM9;:*0NK74ACCP."P4MSZ<*:=<31VENUQ<.(HHQEG;H! _DTP
M.(@.@.GN9(6U/44ANI# UMNM&DN&CPA'EONXS\V[ SR<YJ>[%C_85['=QY\0?9
M9_/*J3+G8W)(ZQXQC^'ICM7:E7!*D,".HJ"UNX[R.1X"Q6&9X6R,8 93@._K1<
M#.T8&"62"\!-^ZAVF/29!P"OH%SC;V)[YR:NI17-O?RV%J=L6MG[^1^Z<#]Z
M0#US&,]NG')KH<'&<'%0/91M?1WKAC*D9C0$_* 2"2!Z\8SZ<4@..:NHK2 7U
MO/%C5 S+I0P3((P,0B,]@."/F_'=4%QJ$-GX8UG3KN4C49&NC]G52TC;B2& '
M8@.YSZ<UV9W+P<CVJM;:E;74GE0RGS-\J!"""3&P5\>P)'YTP,KPM8V\-E+=^
M0!<RW-P&E89;;YK8`)Z+QG X[U5_LNSN(/$5W<6:37"7,YB>1-Q3$2D%,].>
MX[_2NH(.,D''K5>^OK;3;<7%[,((MP4,P/)/0#'-`''0P3SW,+:CJ,<5Y(\+
MVP:T,EPT7RD>6^[@.'D-@.<9;.:>+73=/ANY;6VM[?5K&_EN<)&!*EOYIR1QR#
M&QP/<8[5U$>M6$T4,D%QYJ7$X@.0JI^^02 0<$< ]:O88`<'':BX'$6EEKH2>
MV(/VJSMGGA"L/EFE5>0>Y)^T<=LCVI=92PEL)%T!-L'E[;_RE*G[Z; W?S,Y
MY^]UR:[*XFCM+=Y[EQ%%&-SNW11ZU(VY3AL@.CUHN!R]_IRP>(7AM+7_08[%#
M<6T(P9E\U\@.'N>Y'5O7L=359)+G1!+8,SQNT;,8<AFAW#?M[Y V9Z<^E7TGBE
MEEACD#20D"11U0D9&?J.:6":.Z5G@.<2A79&*\X93AA^!&* .,G737UE&\/V\
M8M?LO^F/9Q;0\7G)O (`R=O8<\U:E$+S,^C*/[#_`'?VT6RXC;YCOV@.?[.-V
MW\:ZTDGKFEPQ.<'KC-%P.56YT6RU6QOK-H[?346='F12L =A'@.+VYVGIW![U
M71;;6-94M&\MI-K)/S*RK(HM.ONIQ]"*ZJRO8K^SBO+=F,4R[D+#!QTZ?A5>
M]UBWLKE8)$N)'(4N88BXB#'"ER.@.)!Y]C0!SVG6SP#3)K5&6ZFEOHRY)R0HD
M$:DGH@.*K@.=!BLR:SW:>WF7R27BQJMW#!:-'*6,D>...?<22#G:?RQ7?6MPE[9
MQ7<&XQ31K(I(P=I&1G\*2XNX[9K=92V;B98(P!G+D$CZ=#1<# F?$6C6L3RV>
MGZ=&HN=.N]\<,0_>NH39G'5@.2<9YR356_FT.6W%MIR:?%%'$70FU,JS2D8*Q
MQ@.@.&08&6ZC(`ZFNRMYH[JWCGMW$L,HW(Z]&'J*E^<DCDGO0!YW=0:>EC/<:A
M!%]NN[&Q:WEECS++( -Y4XSNZ9[UL +A4"C_`(2?[0"[8_>8\SDD]/+\O_@./
M3O6VVOZ7'...8M?HMPK[&0AN&]"<8!Y'?O5JVNH[SSA#N/D3-"X*XPZ]?YT <
MI::9:VWA/2[Z"T5;TRVV9]O[T!I5##<>0-I(QTQQTKJ[>YBNXS+"24#NG*D<
MJQ4]?<&I@.K'D`FHUFC>>2!7#2Q*K.@.ZJK9P3]=I_*D ^B@.D`$D@.`<DGM5*#6
M=-N;S['!>QR3Y("KG!QZ'&#^!H NT4TNJS)"21(ZEE7!Y QG^8I^T^A]: $H
MI<$C(!P*""!D@.X- "45'-/#;H'FD6-6=4!;NS'"C\20*DP2<#K0`44N#G&#G
MTJ&YN8[22WCFW*US+Y4?R]6VEN?3A30!+12@.$] 3]* I/0$_A0`E%-ED2")Y
M97"1QJ7=CT4`9)/X50L];M;VZ6U6*ZAF8,RK/"4W* IR/48=<4 :-%*01U!'
MUJ!KRU2[CM&N(Q<2@.E(=PWD`9)QZ8H FKF_'O_(LM_UU2NDKF_'O_(LM_P!=
M4IK<#J+C_6#_`'%_D*CJ2X_U@._W%_D*CI %%%% !1110`4444 .3_6+]17+Z
M!97VHZ':6]S/;#3O.9U6-6\X[96(&XG Y[@.9QQW-=-0``, `#T% '(Z?`D7A
MC3;IFDV7CJ-1G:1B?)^?C/\`"N=HX[$]N:<[Q)<&WM)1_P`(X9$$\B2$QJ2K
M[E#YSLW>5G!Q\QY'..KVKMV[1MQC&.*0(@.38$4)C&T*,?E3N! R=^MNS6UO8W
M5F-%Q(6-W(YMS*",*'5AQC)'.,Y[\4R(06TEE-=ZBNH2JL2J%9XYERQ :$'[
MR],C!.,\UUYCC,?EF-"G]S:-OY4I1"RL44LOW25&5^GI1<#C&=[6.[CTRY6Y
MOG3<UU"SEMGF*',Z9RKA22" .^!D4MM&D+%/M]E)I,LJ"[6Q9_*C7:_+.S'&
MYM@.;!X YP#FNR5%5F9456;EB``3]?6D$<:H46-%0]5"@.`_A1<# \.IIT>M:P
MNE>7]F"V^#&Q92VU\D$YS]1Q3]1N]/M_%^E"2XM8K@.Q3J^YU5SE4V@.]^>WZ5
MNJBH,(BJ/11BFM%$S;FBC9O[Q0$_G2 PM>%@.VO:9'JERL-JUO<%EDG\I)&!C
MP&Y&?7'M5&:XBDM_L$DD(L6N&:SEO)66!H55>"00S_,6VC/09Y YZ6;3X+B_
M@.O)1O>"-XU5@."I#E22<]_E'ZU.T<;*%:-&5>@.*@.@.?2F!QNB2VE]9P_\`"23(
MULL8^R"9V1'P[A\<@.EAA0 ?FQVK/M!<W.E0K<WUG:Q):K]A>\\S>#SEX]K#<
MX;'!R> ,5W%]IQO&C9+R:V*9!$04A@.?9@.<'_`&A@.^]3PVEO;P1010HL4(Q&N
M,[?IGO[T7 Y^Q^S0^(ANN5N[F:1QYB.PG3@.DK*AX\OC"G Z+US3/$%H7U\75
MI;^9?Q:7(\!&20ZRI@.@.9QD FNGV*'+[%WD8+8&3^-+@.9S@.9]>] '%ZT;.*R=
M= N6:"1,WKQ3%BOSIL9B3\KDD^A]173W-LVG:1=0Z3%B9(Y&@.0G=NDP<9SUR
M:MB.-00L: ,<D!0,GWIU(#C+B;0K._TJ\LR;B[5Y)+@.Q,TDQQ!(6W#LV>Q /
MY&L^[B2XAU*SC>UN8I-.,[):2O+F02IAG<DAG )R5P.3D=*]!$:*Q98T#$Y)
M"@.$GUH6..,82-$'HJ@.4[@.<9KL^DI:W,6DS621V4+R1,\[NK2$9!A56RS# RW
M(' (IEDUB=-OKE+M7UT7$S6R>?F42$_*`@./1B>>,')[5VHAA&,0QC;TP@.X^E
M`BB#[Q%&'_O!!G\Z+@.<=J5ZKZM#=13PP7'VV*W96=VNE&X*^U 0=J(><9'.<@.
M_,!30YM[.:#3+F.65O+-Q=PN[(T1;#M*N<I+ZXP<%L 8KM/+3>7\M-QZMM&3
M^-*J(N[:BKN.6PH&?KZT7 Q?#40ACNQ'>6<\)D79'9;C#%\O(#,3DGJ<'BJF
MLZ9HZ:]8S7L$$4#0W):21RB&0LC#)R!DDL?GTKI5147:BJBCLHP*'1)% VNB
MN.N&`(I <S87.G6MHM_<RRMK*P,UW%"Y,Q8+\RE.P';@.#A<$\9Q#)-'K5I;V
M%S8,7E@.E'DR22Q^;YF,R-GYFP3DKCKT%>@.A$#EPBAB,%@.!D_C2+%&@.`6-% Z
M84#%.X'-ZK!-9W5CJVH.LUS]LC5EM8VV[$CD( 4G+,>>OL!Q6#=2AK^"&WO(
M52\V/,;.X=Y,_

0/,DSM+@.,WW<=3D<BO1,#@.XZ<CVIJQ1J,+$BC.>% YHN!
MR'B/2K2VCO+"SMBL,VF23-"C,V]TEC"MC/4`M^==-IL>FQVA726A:VWG!AD\
MQ<]^<GVJW@.9S@.9Z9Q5"YT:VN9?,\Z\@.XQLMKIX4_[Y4@.9]Z ,^&UO;CQ%K)M
M=4>S420!E6W23<?*'.6Z5A^;$=/DLKJ>W:2"XNY3)>%D24^:X&Q$(+/P>!TS
MT.X5VMI:QV<`AC>5P#G=-(9'/U8\FI#'&2"8T)4Y!*C@.^HHN!REI/J*:;:Q1
MN\LFN6L3),YSY4I11*QSU&SYL#&-I[FK$,=E8^(HD6X^T2>

H\2M]H@.`7 5
ME)^:+ ^]CODDUNO91R7\-VQ8F"-DCCXVJ6QE@./7&1]":GV)OW[%WXQNP,X],
MT 01&TLC;Z?$$AW(QAA4?PKC=CZ;A^=<IX@.L[9=?O+P1[;A5L<2! B#\TKJ>_
M< "NN-K"UXMVRYF1#&I)X4$Y.!V)XR>^!Z5(54]5!^HI`<!9I=3V5M]IO[*S
M>."W%BTPD\Y8_+3YHE4X8D[@.>"?7M7>W%K;W95+B%9$5]RAOX3R,C\"?SI2B
M$J2BDI]T[1\OT]*=0!PVC6^DV^GZ;;RF&&W:%AJ2F8KME!'EK+SE!]_@.X&0/
M:K6KSZ<]I':VT\!AMX6EB:\ED*/DD 1!2&D88.",@. CKN!KK3%$=V8D._P"]
M\H^;Z^M!CC.W,:'9]W*CY?IZ4[@.<CX<35=4TJ\C-U;?9;J4?:&D1FF8M#%N(
MYVY.>X]ZB+6JK<Z;(T")'?7#@.WTKB)@."%"X4AI'XZ Y&<\YKM H4850![#%(
M8T;&Z-#@.Y&5!P?7ZT7 XWPO90:Y8W-UJGF7DJK#M\R1L*?(0D@.`C!/\`04_0
M8=/FU2WO]1,9O+FPLY(99I"K2RX;<5Y^8_=R![>M=@.%5>B@.?08J.>VBN(3$ Z
MX!& R':R?[I'*GZ47 JZ[%<3:%>QVV...

X`ZD9!8?BN1^-8&MZVO]EM;Z6]
M@.UFUNZK:J&6YM0(G.XKGY-I&.@.QFMZWT6WMITF2[U%V0Y"RWTCJ?J"<&KWEQ
M[V?RTW-]YMHR?J>](#C]9MDTZR*6SRIYNC7<LCF5BSOB+YR<]?>C4[2.R&LF
M"6=38VL%Q!F9CMF8MND]V.T<_I78E5/50>,<CM054YRH.>N1UIW Y+44NIM=
MNC<WUE:2Q72BS\T2><L65P8U4X;=\P/!/K5O1/LD.LO%'.+J:59&:>*1MQPW
M2=#]UN>#@.9YXKHBBLP8HI9?NL1DCZ&HI[6*XADC.^/S?O/"QC<_\"'- &?XF
MD2'2HI976.-+VV+.YP%'G+R3VJ'4]0LKT6JQWL$VFF8K?/#,"JKM.P,RGY5+
M``_K5RWT6VMYA*+B^FQ_!/=R2H?JK$@.U=6&)%*K%&JM]X! `?KZT@..7WQ_:?
MLYE_XIKS=OF>8?+SLSMWYSLW^^/>K7AZWTV2]U062(]M;W<;V^&+*C>2`64D
M^[<C@.YK9N[07-KY"2O;X(*M$!QC_`&2,$>Q&*2QL8[&)E5FDDD.Z65P`TAQC
M)QP,#@.`<`=*8&7J?V*35VBUN1([!8%:V\R3RT:3+;SD$98#;@. >YQGFJ.B6 U
MG4[K^VDEN#'%!LCE=E&TM)M8@.$?,4"\]>3FNJ9$D&'17`.<,`>:7`R3CD]3Z
MT@..;0_;?AS.;DF;-E/DL>3MW[?RVC\JP#'/8ZG+#I ,3)!\H!9O+5H[8R,!G
M/0L>.?3FO0MHQMVC'ICB@.*H.0H!]0.:=P,+PS"D,MWY%[8SP$1[8K$NT<;...
MD[F)^8\9&>,#CFC5KO3[?Q1HWG7%K%/F8,7=5?!CPN<\X)Z5NHB1C:B*@.SG"
M@. 4UHHG;<\4;-ZL@.)I )#<0W'F>2X?RI&B?'\+KU'X5S_CW_`)%EO^NJ5T@.`
M'0`9YKF_'O\`R++?]=4IK<#J+C_6#_<7^0J.I+C_`%@._W%_D*CI %%%%`!11
M10`4444`%%%%`!1110`4444`%%%%`!1110`4444`%%%%`!111 0`4444`%%%%
M`!112,RHI9V"JHR23@.`4`+153^U]+_Z"EE_X$I_C1_:^E_\`04LO_ E/\: +
M=%5/[7TO_H*67_@.2G^-']KZ7_P!!2R_\"4_QH MT54_M?2_^@.I9?^!*?XT?V
MOI?_`$%++_P)3_&@."W153^U]+_Z"EE_X$I_C1_:^E_\`04LO_ E/\: +=%5/
M[7TO_H*67_@.2G^-']KZ7_P!!2R_\"4_QH MT54_M?2_^@.I9?^!*?XT#5=,8X
M&IV1)["Y3_&@."W1110`4444`%%%%`!1110`4444`%%%%`!111 0`4444`%%%%
M`!1110`4444`%%%%`!1110`4444`%<WX]_Y%EO\`KJE=)7-^/?\`D66_ZZI3
M6X'47'^L'^XO\A4=27'^L'^XO\A4=( HHHH`****`"BBB@.`HHHH`****`"BB
MB@.`HHHH`****`"BBB@.`HHHH`****`"BBB@.`HHHH`*S?$?/AC50?^?.7_`- -
M:59OB/\`Y%G5/^O.7_T`T 230C[<UO;6.G)''&C$R6H).3T&!CH#W/)'3N@.M
M+C S;:1GO_H@.]O\`Z_Z5.!_Q.+DXZPQ<XZ\MWQ_4_0=[%.X%#[)<8_X]M(S_
M`->@._P`^E!M+CG%MI'?&;0>^/_9?U]JOT47 HFTN.=MMI/?&;0>^/_9?U]J#
M:3YXMM)Q_P!>@._SZ?K3]6O3IVD7=ZJ;V@.B9PN>IK-N[:ZT6S74CJ5S=3PO&;
MI7/[NX4L`0J=(^O!7T[T`7Q:3Y&;;2?_1![?_7_`$H%I<<;K;2>V <6@.]L_^
MS?I[UD>'[ZXU>T@.M7N)H_LPWSR/E9+@.[SC:3_ ,8+#KC'KGI: * M+CC-MI'
M;.+0>V?_`&;]/>C[)<8_X]M(S_UZ"K]%%P*!M+C!Q;:1GMFT'O\`_6_6N8\>
M_+X=O+=[>R4CRVS#;JIP6;&3U_A'ISG\.VKB_B&?^)1>+GHD) QG_`&G[9_H/
MJ>PF#.THHHI %%%%`!1110`4444`%%%%`!1110`4444`%%%%`!1110`4444`
M%%%%`!1110`4444`%%%%`!7-^/?^19;_`*ZI725S?CW_`)%EO^NJ4UN!U%Q_
MK!_N+_(5'4EQ_K!_N+_(5'2 ****`"BBB@.`HHHH`****`"BBB@.`HHHH`****
M`"BBB@.`HHHH`****`"BBB@.`HHHH`****`"LWQ'_R+.J?]><O_H!K2JKJEHVH
M:3>62.J-<0/$K,,A2RD9/YT`!9(]8N6=E3,$0RV!G[W?']3]!WG\Z'_GM'_W
MV*Y6?1/&%S*TLVJZ,[-P<VK'CD8Y'3D_F:C/A[Q:>NIZ-_X"'_#W/YTP.N\Z
M'_GM'_WV*/.A/_+:/_OL?Y[C\ZY'_A'O%N<_VGHW_@.(?\*!X>\6C&-3T88Z8
MM#QT]O8?D/2BP'6M)!(A1I8F5A@.C>.0?_P!?ZUFV^CZ?;R6^+R66"T97M;>2
MX!CA(Z$=SC_

ZUB#P[XL&,:EHPQTQ:'CI[>P_(>E'_".^+,8 _M+1O\`P$/^
M'M0!OQ:;8065K;1W&W[&2891*N]<DDC/H>01Z?3-7S/#S^^C'_ Q_GL?RKD?
M^$=\6'KJ6C?^`A_P]S^=!\/>+#G.IZ,<]<VAYZ^WN?S/K0!UWG0CK-'_`-]C
M_/8_E1YT/_/:/_OL5R)\/>+3G.IZ,<]<VAYZ^WN?S/K1_P`(]XMSG^T]&_\`
M`0_X46 Z[SH?^>T?_?8KC?B#*DFCWH217 2$X5LXRS^_]!]3VD'A[Q:,8U/1
MN/\`IT/M[>P_(5!?>$O%&HV#V,^JZ4('()6.!EY'`/ ]!B@.#N****0!1110`
M4444`%%%% !1110`4444`%%%% !1110`4444`%%%% !1110`4444`%%%% !1
M110`5S?CW_D66_ZZI725S?CW_D66_P"NJ4UN!U%Q_K!_N+_(5 '7(3?$JS:4E
M=/GP``,N,G Q3/\`A9%I_P! ^;_OL4687.RHKC?^%D6G_0/F_P"^Q1_PLBT_
MZ!\W_?8HLPN=E17&_P#"R+3_`*!\W_?8H_X61:?]`^;_`+[%%F%SLJ*XW_A9
M%I_T#YO^^Q1_PLBT_P"@...._WV*+,+G945QO_``LBT_Z!\W_?8H_X61:?] ^;
M_OL4687.RHKC?^%D6G_0/F_[[%'_``LBT_Z!\W_?8HLPN=E17&_\+(M/^@....
M_P!]BC_A9%I_T#YO^^Q19A<[*BN-_P"%D6G_`$#YO^^Q1_PLBT_Z!\W_`'V*
M+,+G945QO_"R+3_H'S?]]BC_`(61:?\`0/F_[[%%F%SLJ*XW_A9%I_T#YO\`
MOL4?\+(M/^@...._WV*+,+G945QO\`PLBT_P"@...._WV*/^%D6G_0/F_P"^Q19A
M<[*BN-_X61:?] ^;_OL4?\+(M/\`H'S?]]BBS"YV5%<;_P`+(M/^@...._WV*/
M^%D6G_0/F_[[%%F%SLJ*XW_A9%I_T#YO^^Q1_P`+(M/^@...._WV*+,+G945QO
M_"R+3_H'S?\`?8H_X61:?] ^;_OL4687.RHKC?\`A9%I_P! ^;_OL4?\+(M/
M^@...._P!]BBS"YV5%<;_PLBT_Z!\W_?8H_P"%D6G_`$#YO^^Q19A<[*BN-_X6
M1:?]`^;_`+[%'_"R+3_H'S?]]BBS"YV5%<;_`,+(M/\`H'S?]]BC_A9%I_T#
MYO\`OL4687.RHKC?^%D6G_0/F_[[%'_"R+3_`*!\W_?8HLPN=E17&_\`"R+3
M_H'S?]]BC_A9%I_T#YO^^Q19A<[*BN-_X61:?] ^;_OL4?\`"R+3_H'S?]]B
MBS"YV5%<;_PLBT_Z!\W_`'V*/^%D6G_0/F_[[%%F%SLJ*XW_`(61:?\`0/F_
M[[%'_"R+3_H'S?\`?8HLPN=E17&_\+(M/^@...._WV*/\`A9%I_P! ^;_OL468
M7.RHKC?^%D6G_0/F_P"^Q1_PLBT_Z!\W_?8HLPN=E17&_P#"R+3_`*!\W_?8
MH_X61:?]`^;_`+[%%F%SLJ*XW_A9%I_T#YO^^Q1_PLBT_P"@...._WV*+,+G94
M5QO_``LBT_Z!\W_?8H_X61:?] ^;_OL4687.RHKC?^%D6G_0/F_[[%'_``LB
MT_Z!\W_?8HLPN=E17&_\+(M/^@...._P!]BC_A9%I_T#YO^^Q19A<[*BN-_P"%
MD6G_`$#YO^^Q1_PLBT_Z!\W_`'V*+,+G945QO_"R+3_H'S?]]BC_`(61:?\`
M0/F_[[%%F%SLJ*XW_A9%I_T#YO\`OL4?\+(M/^@...._WV*+,+G945QO\`PLBT
M_P"@...._WV*/^%D6G_0/F_P"^Q19A<[*N;\>_\BRW_75*H_\`"R+3_H'S?]]B
8LOQ%XQM];TIK..TDB8NK!F8$<4)!<__9
`
end
Perhaps you could try the workaround suggested in
http://support.microsoft.com/default...;en-us;827452, although you
are not using Win2003.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Sydney Lotterby" <sydney@.infosearch.com> wrote in message
news:OPWp2wlpEHA.3300@.TK2MSFTNGP12.phx.gbl...
> SQL2K, Win2K Advaced Server, Win2Kpro wkstation
> --
> I get the following message when I try to restore from a backup to any db
on
> my server.
> In this case the backup is for the db tcaPlant_Grimes and I am trying to
> restore it to tcaPlant_Hays.
> I have done this successfully hundreds of times in the recent past.
> Under the options tab I set ...
> - Force restore over ON (b/c the db already exists)
> - Restore As = full absolute pathname of the MDF
> - Restore As = full absolute pathname of the LDF
> I know the backup is good b/c I can create and restore using the same
backup
> on another server in the same network!
> This has been happening for a week or so.
>
>
>

Monday, March 26, 2012

Fetch within a fetch

Wednesday, March 21, 2012

Fatal Exception in SQL Server

Fatal Exception in SQL Server

Fatal Exception in SQL Server

Monday, March 19, 2012

Fatal error 682 - what is it and how do you fix it?

Server Error in '/' Application.

Warning: Fatal error 682 occurred at Feb 3 2006 9:26PM. Note the error and time, and contact your system administrator.

Warning: Fatal error 682 occurred at Feb 3 2006 9:26PM. Note the error and time, and contact your system administrator.

Warning: Fatal error 682 occurred at Feb 3 2006 9:26PM. Note the error and time, and contact your system administrator.

Friday, February 24, 2012

Failure when installing SQL 2005 SP1 on Windows 2003 Server

Failure when installing SQL 2005 SP1 on Windows 2003 Server

Failure when installing SQL 2005 SP1 on Windows 2003 Server

Failure to start up SQL Server

Failure to start up SQL Server

Failure to start up SQL Server

Failure to Connect Locally when Offline

Failure setting security rights on user account SQLServer2005BrowserUser${computerName}

Failure sending mail: The transport lost its connection to the server

Failure sending mail: The transport lost its connection to the server

Failure sending mail: The transport lost its connection to the server

Sunday, February 19, 2012

Failure Audit - Event ID: 18456

Fails to restore db

Footer rows to skip

Blog Archive

About Me