Will the database get locked if my ASP.Net application that is calling a stored procedure in which a HOLDLOCK for table1 is issued to SQL Server, suddenly crashes just after the stored procedure is called?
I have an application that manage an sql srever compact edition database it worked OK until I got the following problem:
Only when debuging the application ("Start Debugging" from visual studio). In the first call to an sql server routine I get an exception "Unspecified error [ sqlceqp30.dll ]"
My code:
this.usersTableAdapter.Fill(this.nessDBDataSet.Users);
The line with the exception:
[global:ystem.Diagnostics.DebuggerNonUserCodeAttribute()]
[global:ystem.ComponentModel.DataObjectMethodAttribute(global:ystem.ComponentModel.DataObjectMethodType.Fill, true)]
public virtual int Fill(NessDBDataSet.UsersDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable); //Here I get the exception
return returnValue;
}
The Exception:
Unspecified error [ sqlceqp30.dll ]
Again if I do "Run Without Debugging" Evrything is working.
Can any one help me with this
Thanks
Ofer
Hi,
I'm writing an application with Visual Studio 2005 (Visual Basic .NET 2.0) which uses a SQL Compact Edition 3.5 database. On my HTC Touch with Windows Mobile 6.1 installed the application crashes, without any error message, if I try to open a connection. But...On the Windows Mobile 6 Pro emulator the connection opens normaly. The whole application runs perfect.
On both "devices" are the same dll's, of version 3.5.0.0.
I'm using the following code to open the connection:
Code Snippet
Private mySQLce_strConnection As String = "Data Source ='" & App_Path() & "MControl_SQLce.sdf" & "';"
Dim localConnection As New SqlCeConnection(mySQLce_strConnection)
localConnection.Open()
I tried so many things but without any success. But...I'm able to open the database (MControl_SQLce.sdf) with the Query Analyzer 3.5 on the Mobile. No problem.
This is my configuration:
Dev PC:
Windows XP SP2
Visual Studio 2005 Pro
.NET Framework 2.0 SP1
.NET Compact Framework 2.0
SQL Server Compact Edition 3.5 (this version I reference to in my VS project)
Mobile Device (HTC Touch):
Windows Mobile 6.1
SQL Server Compact Edition 3.5
Any suggestions? I can't figure this out.
I use Microsof Visual Studio 2005 to write a c# aplication for my compact device (Dell Axim).
I also use Sql Server Compact Edition to handle my database.
Everything worked OK but suddenly I get an exception on the first call to fill command of a table in my database (Any table) This exception is happenning only when I debug the application if i run the application without debug everything is workink OK.
The exception details are :
System.Data.SqlServerCe.SqlCeException was unhandled
Message="Unspecified error [ sqlceqp30.dll ]"
HResult=-2147467259
NativeError=25123
Source="SQL Server Compact Edition ADO.NET Data Provider"
StackTrace:
at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen()
at System.Data.Common.DbDataAdapter.FillInternal()
at System.Data.Common.DbDataAdapter.Fill()
at System.Data.Common.DbDataAdapter.Fill()
at Ness300.NessDBDataSetTableAdapters.UsersTableAdapter.Fill()
at Ness300.LoginPanel.DoLogin()
at Ness300.LoginPanel.OKButton_Click()
at NL300Controls.BmpButton.L300Button_MouseUp()
at System.Windows.Forms.Control.OnMouseUp()
at System.Windows.Forms.Control.WnProc()
at System.Windows.Forms.ContainerControl.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at Ness300.Program.Main()
I tried to run the application from the mobile device in order to connect to it doing "Attch to running process" from visual studio.
But just running the application on the device with the resgistry value:
HKEY_LOCAL_MACHINESOFTWAREMicrosoft.NETCompactFrameworkManaged DebuggerAttachEnabled
set to 1 caused the crash when I set it back to 0 everything works fine.
It worked for me before I do not know what happened.
Is it a security problem ?
Can any one helpi me with this because this problem do not give me a way to debug my application.
I have a sql server ce db file that I use in my pocket pc application. It seems to be working until I try to edit my .sdf file in SQL Server (2005) Managment Studio. After this I cannot open modified file in my application.
I receive native exception error when I call Open method for Connection object:
ExceptionCode: 0xc0000005
ExceptionAddress: 0x03f8aaac
Reading: 0x00000010
When I edit .sdf file in another pc it's all working.
My config is:
windows vista business
.net compact framework 2.0 sp2
sql server 2005
sql server 2005 compact edition
sql server 2005 compact edition server tools
sql server 2005 compact edition tools for visual studio 2005
Best regards
just see same kind of two sql statement
BEGIN TRAN
SELECT *
FROM authors AU
WITH (HOLDLOCK, ROWLOCK)
WHERE AU.au_id = '274-80-9391'
COMMIT TRAN
BEGIN TRANSELECT *
FROM authors AU
WITH (UPDLOCK, ROWLOCK)
WHERE AU.au_id = '274-80-9391'COMMIT TRAN
i like to know what is the difference between HOLDLOCK and UPDLOCK in sql server. explain with example to better understand.
Hi,
Has anybody encountered this situation before? DB on SQL Server 2000 SP4 with trunc log on chkpt option turned on. Checkpoint trace flags were turned on but noticing no checkpoints are being done on one specific DB resulting into growing transaction log. No open transactions.
Any ideas?
Thanks.
We have a pair of SQL 2005 SP2 with Rollups clusters. We have a series of DB's that we are migrating from an existing SQL 2000 cluster. I have scripted the process, however on one of the test DB's, it goes to "In Recovery" as soon as I issue the Set Partner statement. There are other DB's on the same cluster mirrored with no problems. As we have a bunch of DB's to migrate, I want to figure out what would cause it to start a recovery. After the initial restores are done, it is in "Restoring" for a status so everything works up to that point.
Thanks
Jon Macy
I do know Profiler can capture the sql scripts ADO.Net generated and do know can Capture SQL Scripts using SMO
but how do i get the sql scripts when the command failed in order to do loging and bug fixing?
eg:
private DataSet GetData()
{
try
{
SqlCommand command = new System.Data.SqlClient.SqlCommand("dbo.Test_TestParameters");
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@p1", 1);
command.Parameters.AddWithValue("@p2", 2);
command.Connection = new SqlConnection("data source=localhost;initial catalog=Test;user id=sa;password=;Connect Timeout=60");
command.CommandTimeout = 0;
SqlDataAdapter dataAdapter = new SqlDataAdapter();
dataAdapter.SelectCommand = command;
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
return dataSet;
}
catch (System.Exception e)
{
string issuedSql = GetIssuedSqlScripts(command); // !!! HERER can be command or connection
Trace.WriteLine(issuedSql);
throw e;
}
}
how can i implement GetIssuedSqlScripts ???
Every time I execute DBCC DBREINDEX (Table_Name, '',0)WITH NO_INFOMSGS the server hangs. No error messages in windows 2000 logs or in the SQL 7.0 logs.
The table is about 2 gig in size and the index is a clustered index on two fields.
The server has 1 gig of memory and the cache hit ratio, and cache flushes both look good. Any ideas? Any help would be greatly appreciated.
Hi.. My Finance user create a microsoft Excel OLAP file that connect to our SQL server. And I have created the same ODBC setting for every PCs.
But for a few PCs, I encountered the following error "Client Safety Options do not allow pass through statement to be issued to the data source" When trying to connect the OLAP file to SQL server after entering the same SQL account.
Any idea what is the isssue ??
Hi
I am trying to install SQL Server 2005 Express on my machine, which has Windows Server 2003 with Service Pack 1. I could not able to install properly and i am getting error always.
Here is the Error I am getting always "The certificate chain was issued by an authority that is not trusted" . I am trying for past few days i could not able to resolve.
Please help
Thanks
Here is the Error message from Summary.txt
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows Server 2003 family, Service Pack 1 (Build 3790)
Time : Tue Sep 05 12:31:18 2006
--------------------------------------------------------------------------------
Machine : SERVIDORCC
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Archivos de programaMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_SERVIDORCC_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}SSL Provider: The certificate chain was issued by an authority that is not trusted.
Error Number : 29515
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Tue Sep 05 17:12:41 2006
We have 2 servers when you try to change something in a transfer for sql to a text file, it crashes and kicks you out of enterprise manager. I have seen this before. MS recommends applying sp4 or
MS03-031: Cumulative Security Patch for SQL Server (815495)
This is on a cluster. Has anyone seen this before
When we migrated from SQL 6.5 to 7.0 our users that had DBO privileges moved fine. When we went in and added a new user and tried to give them the same priviledges as the old user, the user looks different and does not have the same priviliges. When the user tries to run the SETUSER stored procedure it tell the user that was newly setup that they do not have the rights to perform the operation. Any help with be greatly appreciated.
View 1 Replies View RelatedWe are network admins at a college, with no database experience at all. We use an Altiris product which uses SQL to maintain a database. Our database is OK, but the transaction log has grown to 24 Gb and has caused a slowdown. When we try to back up the database in preparation for shrinking it to the recommended 100 Mb, the server seems to start the backup but crashes (restarts) after a few minutes. Has the situation got out of hand i.e. with files so big, is our server never going to be able to work with it? Or are we missing something obvious?
Any information on resolving the situation gratefully received, thanks in advance.
Denis
PS
I have a report that runs fine, but as soon as I add a sub-report to it, it crashes.
It makes no sense, there are two lists (One inside another, to group the invoices) which I think may be causing this crash, but all it tells me is
"A error occured during local report processing. A internal error occurred on the report server. See the error log for more details"
Where is this error log, I am running the report from vs2005, not off a report server.
Any help would be appriciated
Code Snippet<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
; <DataSources>
<DataSource Name="SPProduction">
<ConnectionProperties>
<IntegratedSecurity>true</IntegratedSecurity>
<ConnectString>Data Source=DELL4400SQL;Initial Catalog=SpProductionDB</ConnectString>
<DataProvider>SQL</DataProvider>
</ConnectionProperties>
<rd:DataSourceID>1cde06a1-b276-4548-85bc-8a6a541faa3d</rd:DataSourceID>
</DataSource>
<DataSource Name="SPProduction1">
<DataSourceReference>SPProduction</DataSourceReference>
<rd:DataSourceID>1a5e7133-9291-42e3-a7bf-fb505900eb56</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>0.1in</BottomMargin>
<RightMargin>0.2in</RightMargin>
<ReportParameters>
<ReportParameter Name="InvoiceID">
<DataType>String</DataType>
<Nullable>true</Nullable>
<Prompt>InvoiceID</Prompt>
</ReportParameter>
<ReportParameter Name="BatchID">
<DataType>Integer</DataType>
<Nullable>true</Nullable>
<Prompt>BatchID</Prompt>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>false</rd:SnapToGrid>
<Body>
<ReportItems>
<List Name="Body_MainGroup">
<Left>0.19792in</Left>
<ReportItems>
<Rectangle Name="rectangle9">
<ReportItems>
<Rectangle Name="rectangle8">
<Left>0.03125in</Left>
<PageBreakAtStart>true</PageBreakAtStart>
<ReportItems>
<Textbox Name="textbox86">
<Left>5.67708in</Left>
<Top>0.37708in</Top>
<ZIndex>12</ZIndex>
<Width>1.54167in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
</Style>
<Value>=First(Fields!EmployerName.Value)</Value>
</Textbox>
<Textbox Name="textbox87">
<Left>5.67708in</Left>
<Top>0.04167in</Top>
<ZIndex>11</ZIndex>
<Width>1.54167in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Employer Name</Value>
</Textbox>
<Line Name="line30">
<Top>0.305in</Top>
<ZIndex>10</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Textbox Name="textbox88">
<Left>3.53125in</Left>
<Top>0.375in</Top>
<ZIndex>9</ZIndex>
<Width>1.125in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=First(Fields!EmployerID.value)</Value>
</Textbox>
<Textbox Name="textbox89">
<Left>4.66667in</Left>
<Top>0.375in</Top>
<ZIndex>8</ZIndex>
<Width>1in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
</Style>
<Height>0.25in</Height>
<Value>=Fields!EmployerCode.Value</Value>
</Textbox>
<Textbox Name="textbox90">
<Left>3.53125in</Left>
<Top>0.05in</Top>
<ZIndex>7</ZIndex>
<Width>1.125in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Employer ID</Value>
</Textbox>
<Textbox Name="textbox91">
<Left>1.01042in</Left>
<Top>0.375in</Top>
<ZIndex>6</ZIndex>
<Width>0.875in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
<Format>d</Format>
</Style>
<Height>0.25in</Height>
<Value>=First(Fields!DueDate.value)</Value>
</Textbox>
<Textbox Name="textbox92">
<Left>0.125in</Left>
<Top>0.05in</Top>
<ZIndex>5</ZIndex>
<Width>0.875in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Printed Date</Value>
</Textbox>
<Textbox Name="textbox93">
<Left>0.125in</Left>
<Top>0.375in</Top>
<ZIndex>4</ZIndex>
<Width>0.875in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
<Format>d</Format>
</Style>
<Height>0.25in</Height>
<Value>=Now()</Value>
</Textbox>
<Textbox Name="textbox94">
<Left>4.66667in</Left>
<Top>0.05in</Top>
<ZIndex>3</ZIndex>
<Width>1in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Employer Code</Value>
</Textbox>
<Textbox Name="textbox95">
<Left>1.01042in</Left>
<Top>0.05in</Top>
<ZIndex>2</ZIndex>
<Width>0.875in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Due Date</Value>
</Textbox>
<Textbox Name="textbox96">
<Left>1.89583in</Left>
<Top>0.375in</Top>
<ZIndex>1</ZIndex>
<Width>1.625in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontSize>9pt</FontSize>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=First(Fields!InvoiceStartdate.Value & " - " & Fields!InvoiceEndDate.Value)</Value>
</Textbox>
<Textbox Name="textbox97">
<Left>1.89583in</Left>
<Top>0.05in</Top>
<Width>1.625in</Width>
<Style>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.1875in</Height>
<Value>Periods Billed</Value>
</Textbox>
</ReportItems>
<Top>0.04167in</Top>
<ZIndex>4</ZIndex>
<Width>7.25416in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>3pt</Default>
</BorderWidth>
</Style>
<Height>0.75in</Height>
</Rectangle>
<Rectangle Name="rectangle7">
<Left>0.05521in</Left>
<ReportItems>
<Textbox Name="textbox39">
<Left>0.84375in</Left>
<ZIndex>16</ZIndex>
<Width>1in</Width>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<Color>MidnightBlue</Color>
<TextDecoration>Underline</TextDecoration>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15625in</Height>
<Value>*Status Codes</Value>
</Textbox>
<Textbox Name="textbox40">
<Left>0.35417in</Left>
<Top>1.45833in</Top>
<ZIndex>15</ZIndex>
<Width>1.625in</Width>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<FontSize>8pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Value>(Include New Enrollment Cards)</Value>
</Textbox>
<Textbox Name="textbox41">
<Left>0.35417in</Left>
<Top>1.20833in</Top>
<ZIndex>14</ZIndex>
<Width>1.35417in</Width>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Times New Roman</FontFamily>
<FontSize>8pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>(Include Enrollment Cards)</Value>
</Textbox>
<Textbox Name="textbox42">
<Left>0.10417in</Left>
<Top>1.33333in</Top>
<ZIndex>13</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>R = Reinstated</Value>
</Textbox>
<Textbox Name="textbox56">
<Left>0.10417in</Left>
<Top>1.08333in</Top>
<ZIndex>12</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>N = New Employee</Value>
</Textbox>
<Textbox Name="textbox74">
<Left>0.10417in</Left>
<Top>0.83333in</Top>
<ZIndex>11</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<TextDecoration>Underline</TextDecoration>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Additions</Value>
</Textbox>
<Textbox Name="textbox75">
<Left>0.10417in</Left>
<Top>0.70833in</Top>
<ZIndex>10</ZIndex>
<Width>1.27083in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>SL = Sick Leave</Value>
</Textbox>
<Textbox Name="textbox76">
<Left>0.10417in</Left>
<Top>0.58333in</Top>
<ZIndex>9</ZIndex>
<Width>1.38542in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>LO = Layoff</Value>
</Textbox>
<Textbox Name="textbox77">
<Left>0.10417in</Left>
<Top>0.43333in</Top>
<ZIndex>8</ZIndex>
<Width>1.42708in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>LA = Leave of Absensce</Value>
</Textbox>
<Textbox Name="textbox78">
<Left>1.71875in</Left>
<Top>1.08333in</Top>
<ZIndex>7</ZIndex>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>TM = Transfer/Management</Value>
</Textbox>
<Textbox Name="textbox79">
<Left>1.71875in</Left>
<Top>0.95833in</Top>
<ZIndex>6</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>TS = Seniority Loss</Value>
</Textbox>
<Textbox Name="textbox80">
<Left>1.71875in</Left>
<Top>0.83333in</Top>
<ZIndex>5</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>TR = Retired</Value>
</Textbox>
<Textbox Name="textbox81">
<Left>1.71875in</Left>
<Top>0.70833in</Top>
<ZIndex>4</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>TQ = Quit</Value>
</Textbox>
<Textbox Name="textbox82">
<Left>1.71875in</Left>
<Top>0.58333in</Top>
<ZIndex>3</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>TF = Fired</Value>
</Textbox>
<Textbox Name="textbox83">
<Left>1.71875in</Left>
<Top>0.43333in</Top>
<ZIndex>2</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Left</TextAlign>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>9pt</FontSize>
<Color>MidnightBlue</Color>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>TD = Deceased</Value>
</Textbox>
<Textbox Name="textbox84">
<Left>0.10417in</Left>
<Top>0.18333in</Top>
<ZIndex>1</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<TextDecoration>Underline</TextDecoration>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Off-Temporarily</Value>
</Textbox>
<Textbox Name="textbox85">
<Left>1.96875in</Left>
<Top>0.18333in</Top>
<Width>1.125in</Width>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Times New Roman</FontFamily>
<FontWeight>700</FontWeight>
<TextDecoration>Underline</TextDecoration>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Termination</Value>
</Textbox>
</ReportItems>
<Top>0.96875in</Top>
<ZIndex>3</ZIndex>
<Width>3.35833in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>1.60833in</Height>
</Rectangle>
<CustomReportItem Name="customReportItem1">
<Style>
<TextAlign>Center</TextAlign>
<FontFamily>Tahoma</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>6pt</FontSize>
<BackgroundColor>White</BackgroundColor>
<Color>DarkSlateBlue</Color>
</Style>
<Top>1.209in</Top>
<ZIndex>2</ZIndex>
<CustomData>
<DataRowGroupings>
<DataGroupings>
<DataGrouping>
<Static>true</Static>
</DataGrouping>
</DataGroupings>
</DataRowGroupings>
<DataSetName>SpProductionData</DataSetName>
<DataRows>
<DataRow>
<DataCell>
<DataValue>
<Value />
</DataValue>
</DataCell>
</DataRow>
</DataRows>
<DataColumnGroupings>
<DataGroupings>
<DataGrouping>
<Static>true</Static>
</DataGrouping>
</DataGroupings>
</DataColumnGroupings>
</CustomData>
<Height>0.39583in</Height>
<CustomProperties>
<CustomProperty>
<Name>LicenseOwner</Name>
<Value />
</CustomProperty>
<CustomProperty>
<Name>LicenseKey</Name>
<Value />
</CustomProperty>
<CustomProperty>
<Name>AutoSize</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>BarHeight</Name>
<Value>0.5in</Value>
</CustomProperty>
<CustomProperty>
<Name>BarWidth</Name>
<Value>0.01in</Value>
</CustomProperty>
<CustomProperty>
<Name>BarRatio</Name>
<Value>1</Value>
</CustomProperty>
<CustomProperty>
<Name>Rotate</Name>
<Value>None</Value>
</CustomProperty>
<CustomProperty>
<Name>CodabarStartChar</Name>
<Value>A</Value>
</CustomProperty>
<CustomProperty>
<Name>CodabarStopChar</Name>
<Value>B</Value>
</CustomProperty>
<CustomProperty>
<Name>DisplayStartStopChar</Name>
<Value>True</Value>
</CustomProperty>
<CustomProperty>
<Name>AddChecksum</Name>
<Value>True</Value>
</CustomProperty>
<CustomProperty>
<Name>GuardBar</Name>
<Value>True</Value>
</CustomProperty>
<CustomProperty>
<Name>GuardBarHeight</Name>
<Value>0.55in</Value>
</CustomProperty>
<CustomProperty>
<Name>Code128CharSet</Name>
<Value>Auto</Value>
</CustomProperty>
<CustomProperty>
<Name>PostnetHeightTallBar</Name>
<Value>0.135in</Value>
</CustomProperty>
<CustomProperty>
<Name>PostnetHeightShortBar</Name>
<Value>0.06in</Value>
</CustomProperty>
<CustomProperty>
<Name>PlanetHeightTallBar</Name>
<Value>0.135in</Value>
</CustomProperty>
<CustomProperty>
<Name>PlanetHeightShortBar</Name>
<Value>0.06in</Value>
</CustomProperty>
<CustomProperty>
<Name>Symbology</Name>
<Value>Pdf417</Value>
</CustomProperty>
<CustomProperty>
<Name>QuietZoneWidth</Name>
<Value>0.1in</Value>
</CustomProperty>
<CustomProperty>
<Name>DisplayCode</Name>
<Value>True</Value>
</CustomProperty>
<CustomProperty>
<Name>TopMargin</Name>
<Value>0in</Value>
</CustomProperty>
<CustomProperty>
<Name>BottomMargin</Name>
<Value>0in</Value>
</CustomProperty>
<CustomProperty>
<Name>Code16kMode</Name>
<Value>Mode0</Value>
</CustomProperty>
<CustomProperty>
<Name>Extended</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>DataMatrixModuleSize</Name>
<Value>0.04in</Value>
</CustomProperty>
<CustomProperty>
<Name>DataMatrixFormat</Name>
<Value>Auto</Value>
</CustomProperty>
<CustomProperty>
<Name>DataMatrixEncoding</Name>
<Value>Auto</Value>
</CustomProperty>
<CustomProperty>
<Name>EanUpcSupplement</Name>
<Value>None</Value>
</CustomProperty>
<CustomProperty>
<Name>EanUpcSupplementCode</Name>
<Value />
</CustomProperty>
<CustomProperty>
<Name>EanUpcSupplementSeparation</Name>
<Value>0.15in</Value>
</CustomProperty>
<CustomProperty>
<Name>EanUpcSupplementTopMargin</Name>
<Value>0.15in</Value>
</CustomProperty>
<CustomProperty>
<Name>UpcESystem</Name>
<Value>System0</Value>
</CustomProperty>
<CustomProperty>
<Name>Pdf417Columns</Name>
<Value>5</Value>
</CustomProperty>
<CustomProperty>
<Name>Pdf417Rows</Name>
<Value>0</Value>
</CustomProperty>
<CustomProperty>
<Name>Pdf417CompactionType</Name>
<Value>Binary</Value>
</CustomProperty>
<CustomProperty>
<Name>Pdf417ErrorCorrectionLevel</Name>
<Value>Level4</Value>
</CustomProperty>
<CustomProperty>
<Name>Code</Name>
<Value>="BarcodeVersion:1.0|Type:3|Category:Invoice|ID:" & Fields!EmployerID.Value &"|FileName:" & Fields!InvoiceGroup.Value</Value>
</CustomProperty>
<CustomProperty>
<Name>AntiAlias</Name>
<Value>True</Value>
</CustomProperty>
<CustomProperty>
<Name>Text</Name>
<Value />
</CustomProperty>
<CustomProperty>
<Name>DisplayChecksum</Name>
<Value>True</Value>
</CustomProperty>
<CustomProperty>
<Name>Pdf417Truncated</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>DataMatrixProcessTilde</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>ImageFormat</Name>
<Value>Png</Value>
</CustomProperty>
<CustomProperty>
<Name>FitBarsAreaToSizeWidth</Name>
<Value>3in</Value>
</CustomProperty>
<CustomProperty>
<Name>FitBarsAreaToSizeHeight</Name>
<Value>0.3in</Value>
</CustomProperty>
<CustomProperty>
<Name>BearerBarStyle</Name>
<Value>None</Value>
</CustomProperty>
<CustomProperty>
<Name>BearerBarWidth</Name>
<Value>0.05in</Value>
</CustomProperty>
<CustomProperty>
<Name>DisplayLightMarginIndicator</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>Dpi</Name>
<Value>300</Value>
</CustomProperty>
<CustomProperty>
<Name>Monochrome</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>Postal4StateAddStartStopChar</Name>
<Value>True</Value>
</CustomProperty>
<CustomProperty>
<Name>Postal4StateBarsSpacing</Name>
<Value>0.03in</Value>
</CustomProperty>
<CustomProperty>
<Name>Postal4StateTrackerBarHeight</Name>
<Value>0.08in</Value>
</CustomProperty>
<CustomProperty>
<Name>Postal4StateTrackerBarWidth</Name>
<Value>0.02in</Value>
</CustomProperty>
<CustomProperty>
<Name>QRCodeModuleSize</Name>
<Value>0.02in</Value>
</CustomProperty>
<CustomProperty>
<Name>QRCodeErrorCorrectionLevel</Name>
<Value>M</Value>
</CustomProperty>
<CustomProperty>
<Name>QRCodeEncoding</Name>
<Value>Auto</Value>
</CustomProperty>
<CustomProperty>
<Name>QRCodeVersion</Name>
<Value>Auto</Value>
</CustomProperty>
<CustomProperty>
<Name>UspsFimPattern</Name>
<Value>A</Value>
</CustomProperty>
<CustomProperty>
<Name>UspsHorizontalBarsCount</Name>
<Value>10</Value>
</CustomProperty>
<CustomProperty>
<Name>TelepenEncoding</Name>
<Value>Ascii</Value>
</CustomProperty>
<CustomProperty>
<Name>PharmacodeBarsSpacing</Name>
<Value>0.04in</Value>
</CustomProperty>
<CustomProperty>
<Name>PharmacodeThickBarWidth</Name>
<Value>0.06in</Value>
</CustomProperty>
<CustomProperty>
<Name>PharmacodeThinBarWidth</Name>
<Value>0.02in</Value>
</CustomProperty>
<CustomProperty>
<Name>BarColor</Name>
<Value>Black</Value>
</CustomProperty>
<CustomProperty>
<Name>CodeVerticalAlign</Name>
<Value>Bottom</Value>
</CustomProperty>
<CustomProperty>
<Name>CodeAlign</Name>
<Value>Center</Value>
</CustomProperty>
</CustomProperties>
<Type>NeodynamicBarcodeControl</Type>
<Left>4.48437in</Left>
<Width>2.72916in</Width>
</CustomReportItem>
<Rectangle Name="rectangle5">
<ReportItems>
<Textbox Name="textbox37">
<Left>5.19792in</Left>
<Top>0.08854in</Top>
<ZIndex>31</ZIndex>
<Width>2.04167in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Status Code * (PLEASE DATE)</Value>
</Textbox>
<Textbox Name="textbox34">
<Left>3.65104in</Left>
<Top>0.08854in</Top>
<ZIndex>30</ZIndex>
<Width>1.46875in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Date of Birth</Value>
</Textbox>
<Textbox Name="textbox31">
<Left>2.64583in</Left>
<Top>0.07813in</Top>
<ZIndex>29</ZIndex>
<Width>0.91667in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Hire Date</Value>
</Textbox>
<Textbox Name="textbox29">
<Left>1.40104in</Left>
<Top>0.08854in</Top>
<ZIndex>28</ZIndex>
<Width>1.13542in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Member L Name</Value>
</Textbox>
<Textbox Name="textbox28">
<Left>0.07292in</Left>
<Top>0.08333in</Top>
<rd:DefaultName>textbox28</rd:DefaultName>
<ZIndex>27</ZIndex>
<Width>1.22917in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Member F Name</Value>
</Textbox>
<Line Name="line29">
<Left>5.18229in</Left>
<ZIndex>26</ZIndex>
<Width>0in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>3in</Height>
</Line>
<Textbox Name="textbox24">
<Left>2.11458in</Left>
<Top>3.10417in</Top>
<rd:DefaultName>textbox24</rd:DefaultName>
<ZIndex>25</ZIndex>
<Width>3.28125in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>NEW UNION MEMBER INFORMATION</Value>
</Textbox>
<Line Name="line28">
<Left>3.625in</Left>
<ZIndex>24</ZIndex>
<Width>0in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>3in</Height>
</Line>
<Line Name="line27">
<Left>2.625in</Left>
<ZIndex>23</ZIndex>
<Width>0in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>3.02083in</Height>
</Line>
<Line Name="line25">
<Left>1.375in</Left>
<ZIndex>22</ZIndex>
<Width>0in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>2.98958in</Height>
</Line>
<Line Name="line24">
<Top>3.00521in</Top>
<ZIndex>21</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line26">
<Top>2.88021in</Top>
<ZIndex>20</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line19">
<Top>2.75521in</Top>
<ZIndex>19</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line20">
<Top>2.38021in</Top>
<ZIndex>18</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line21">
<Top>2.63021in</Top>
<ZIndex>17</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line22">
<Top>2.50521in</Top>
<ZIndex>16</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line23">
<Top>2.25521in</Top>
<ZIndex>15</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line14">
<Top>2.13021in</Top>
<ZIndex>14</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line15">
<Top>1.75521in</Top>
<ZIndex>13</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line16">
<Top>2.00521in</Top>
<ZIndex>12</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line17">
<Top>1.88021in</Top>
<ZIndex>11</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line18">
<Top>1.63021in</Top>
<ZIndex>10</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line9">
<Top>1.50521in</Top>
<ZIndex>9</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line10">
<Top>1.13021in</Top>
<ZIndex>8</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line11">
<Top>1.38021in</Top>
<ZIndex>7</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line12">
<Top>1.25521in</Top>
<ZIndex>6</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line13">
<Top>1.00521in</Top>
<ZIndex>5</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line8">
<Top>0.875in</Top>
<ZIndex>4</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line7">
<Top>0.5in</Top>
<ZIndex>3</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line6">
<Top>0.75in</Top>
<ZIndex>2</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line5">
<Top>0.625in</Top>
<ZIndex>1</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Line Name="line4">
<Top>0.375in</Top>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
</ReportItems>
<Top>2.80209in</Top>
<ZIndex>1</ZIndex>
<Width>7.30208in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Rectangle>
<Textbox Name="textbox13">
<Left>3.43541in</Left>
<Top>0.90559in</Top>
<Width>3.76458in</Width>
<Style>
<TextAlign>Right</TextAlign>
<FontFamily>Tahoma</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>12pt</FontSize>
<Color>DarkSlateBlue</Color>
</Style>
<Height>0.25in</Height>
<Value>="Invoice # " & Fields!InvoiceGroup.Value</Value>
</Textbox>
</ReportItems>
<Top>7.83333in</Top>
<ZIndex>4</ZIndex>
<Visibility>
<Hidden>=iif(countrows("Body_MainGroup_Details_Group")> 20,false,true)</Hidden>
</Visibility>
<Width>7.32291in</Width>
<Height>6.15626in</Height>
</Rectangle>
<Rectangle Name="rectangle6">
<Left>0.16146in</Left>
<ReportItems>
<Textbox Name="textbox25">
<Left>4.58854in</Left>
<Top>1.2284in</Top>
<ZIndex>5</ZIndex>
<Width>0.625in</Width>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
</Style>
<CanGrow>true</CanGrow>
<Height>0.15in</Height>
<Value>Date</Value>
</Textbox>
<Line Name="line2">
<Left>4.33854in</Left>
<Top>1.2284in</Top>
<ZIndex>4</ZIndex>
<Width>1.125in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Textbox Name="textbox27">
<Left>2.42187in</Left>
<Top>1.23882in</Top>
<ZIndex>3</ZIndex>
<Width>0.625in</Width>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Times New Roman</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
</Style>
<CanGrow>true</CanGrow>
<Value>Signature</Value>
</Textbox>
<Line Name="line3">
<Left>1.66146in</Left>
<Top>1.2284in</Top>
<ZIndex>2</ZIndex>
<Width>2.33333in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0in</Height>
</Line>
<Table Name="table3">
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox44">
<ZIndex>4</ZI
I am using the DTS wizard to import tables from an AS/400. Some of the tables in the job are quite large and Sql Server either hangs up or completely crashes. My current configuration is WIN NT, SP4.0 SQL Server 7.0 no Service pack. Any suggestions?
View 1 Replies View RelatedHi Folks,
I've jumped over from the sister site xtremevbtalk.com to ask the question:
Has anyone ever seen an issue where when installing MSDE, during the installation the pc reboots of its own accord?
After the MDAC is installed as part of the installation the pc reboots and upon boot up, MSDE is not in the program files directory. Instead it's sitting in the C: root. This occurs for a straight MSDE install or with an Instancename install.
There does exist a Microsoft SQL Server folder in the Program Files but it is incomplete. It's missing the Binn folder. Also, there is no reference to MSDE in the Add/Remove programs tool but ther MSDE service does show up in the Services. However I cannot start these as they are pointing to the correct location.
To date, I have tried removing the instance and installation from the registry. I have turned off all AntiVirus software. I have ensured I am using an Admin user profile. I have tried a blank sa passowrd for the installation. all of this is to no avail.
I am seriously stuck with this now and I am in dire need of a resolution so if anybody has any ideas or has seen this one before, I love some help.
Thanks,
Gb :)
I can open a single connection to the database engine successfully but if I try to open another connection ('New Query' or 'query with current connection') Management Studio just goes away without any errors.
I am utilizing a remote desktop connection to the server but if I open a connection from my desktop through Management Studio I can establish multiple connections (database engine, query, etc...) with no problems. There are no errors in the sql logs, event viewer or windows log.
Has anyone seen this? Any suggestions would be appreciated.
My application uses sqldmo to retrieve the list of sql servers in thenetwork, it works fine in some machines, but it is crashing theapplication in others, no error and no exception, it shuts down theapplication. It fails in the following line:SQLDMO.NameList sqlServers = sqlApp.ListAvailableSQLServers();any ideas?thanksmusachy
View 2 Replies View RelatedI was looking to improve the performance of an ASP.NET application bycreating the an indexed view that could be used instead of some of theroot tables.What I didn't realize is that it would affect any future conenctionsto the root tables.This of course crashed the application on any type of insert, update,or delte from the root tables.Funny thing is when I removed the indexed view -- it didn't help.I tried flipping the offending options to the opposite of way theywere set on the database and the errors wouldn't go away.I ended up restoring the database from before my mess up to fix it.I was hoping that the SQL experts out there might shed some light onmy problem before I try again.
View 1 Replies View RelatedCurrently we have SQL Server running on a single RAID5 array.The data and the logs are all written to this array. We don'thave huge volume of activity, but it is growing. Most activityis from our website that interacts a lot with the database.We have read that it is a good idea to separate the data filesfrom the log files, having each on separate disks (or in thecase of RAID, separate arrays). So, we are considering addinga separate SCSI hard drive, or maybe a RAID 1 system, and havesql server log to that instead.My question is, what happens if that secondary drive or arraycompletely fails. Let's say it melts. Assuming the OS doesn'tcrash (Windows 2003 Server), what will SQL Server 2000 do whenthe drive stops working and it is trying to write its datalogging to it? Will it continue to function and write alertevents? Will it shutdown? If it shuts down, how do we alter itsconfiguration to tell it to use another drive for the logs?Also, what kind of throughput would we need to be doing to seeany kind of benefit to making this change? It is easier tojustify the expense of another disk or RAID setup if it isactually going to matter. ;-)Thanks all!Thomas
View 3 Replies View RelatedI'm using SQL 2005 Reporting services on Windows 2003 server, my development machine is Windows XP Pro. Attempting to report from a Progress 10.0B database with the DataDirect 4.2 SQL92 driver.
A simple static query executes brilliantly (i.e. SELECT Col1 FROM Tab1 WHERE Col1 = 200) When I change the named parameter to an unnamed (i.e. SELECT Col1 FROM Tab1 WHERE Col1 = ?), then execute the query I'm prompted for the parameter value, I enter a valid value, then receive the error: "Attempted to read or write protected memory. this is often an indication that other memory is corrupt." Then VS crashes. obviously this is bothersome.
An ODBC trace shows the SQL statement (SELECT Col1 FROM Tab1 WHERE Col1 = ?), note: the parameter value I entered is not in the trace. Should it be?
Any thoughts would be greatly appreciated.
Hi ,
I have created a calculated data field for one of my data set. I use it for a table in my report.
But when I try to preview it, visual studio crashes and I get the following error message.
"An error occured during local report processing. An internal error occured on the report server.see the error log for more details."
I have not installd servers on my machine(only the sql tools). So I can not see error logs either.
Does any one know why this happenes?
Thanks
Every time I do a full backup of my databases, it will go through most of them, then get to the largest database I have (13 Gig) which is the Sharepoint database, and as it starts to back it up, the machine will then freeze up and need to be hard rebooted. I confirmed it was the backup by moving the backup to a different time, which is when the server crashed. Also, if I manually attempt to do a full backup on it, the machine will then crash.
I'm running Windows Server 2003, SP2, fully patched, SQL server 2005 SP2 (32-bit) fully patched. 4 Gigs memory. Have tried setting it to use 3 Gig itself, with and without AWE, but it didn't make a difference. This machine is a dedicated SQL Server machine. Microsoft has had us run perfmon and send them perfmon reports and dumps. They don't see anything that would cause our issues. Nothing shows up in the event viewer. This server has been running just fine since last June when we installed SQL 2005. The problems started occurring on March 8 of this year. I don't see any patches that correspond to that date.
Hardware is all reporting fine according to the Gateway Hardware tool.
I'm the Sharepoint Admin, we have no SQL Admin, so now this is another job of mine. So any advice, anything I should look for, would be extremely helpful.
Thanks!
Linda
Hello. I have a problem with regards to MS SQL Server 7.
I was creating an index on a 7 million row table and I executed the following TSQL command.
create index idx_accno on ccaccount(accno)
go
After 1 minute the following error was displayed and SQL Server was shut down automatically.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionCheckForData (PeekNamedPipe()).
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.
Connection Broken
All the relevant settings on the server (server connections) seems to be ok. Any help will be greatly appreciated.
Winston
I ran a DBCC SHOWCONTIG on a large database. Because the execution was taking longer than I wanted I cancelled and then killed the process running the DBCC. This action seems to have abnormally ended SQLServer and subsequently crashed the entire NT server. Have you experienced any behavior similar to this when using DBCC and/or killed processes?
View 3 Replies View RelatedI am creating an SSIS Package to import some data. The package contains a big for each loop with 3 parallel running nested for each loops. The package crashes within the big loop without returning any error information. It starts up the sqldumper and genreates an dump - but does not report any error to the UI (Visual Studio or dtexec). While I am running only one for each loop and disable the others the package executes successfully. Has anyone an idea what might be wrong ? or is the only chance to submit a bug report ?
Thanks
HANNES
Hi!
when I'm trying something litle bit more complex thing than string manipulation in calculated field ex: =RunningValue(Fields!SALES.Value, Sum)
It just crashes visual studio when trying to run the report?! I think this could state as a bug in RS?
Hi
I'm trying to use a user defined alias type in a table creation, and everything works as expected, right until the moment where I rightclick on [Indexes] and click [new index] to create a new index.
Then I get this error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
------------------------------
Object reference not set to an instance of an object. (SqlManagerUI)
------------------------------
BUTTONS:
OK
------------------------------
This is the script I use to create the table:
exec sp_executeSql N'CREATE SCHEMA [TestSchema] AUTHORIZATION [dbo]'
GO
CREATE TYPE [TestSchema].[type_TestType]
FROM uniqueidentifier ;
GO
Create table [TestSchema].[Periode3]
(
Periode3_UID uniqueidentifier NOT NULL ROWGUIDCOL,
rowVersion timestamp NULL,
owner uniqueidentifier not null,
validFrom datetime
NOT NULL CONSTRAINT
DF_Periode_modified3 DEFAULT getdate()
);
Alter table [TestSchema].[Periode3]
add PeriodeType [TestSchema].[type_TestType];
now if I replace the 2 last lines with:
Alter table [TestSchema].[Periode3]
add PeriodeType uniqueidentifier;
everything works as expected.
Where did I go wrong ?
regards
Jens Chr
have SQL Server 2005 std edition SP1 installed on Windows 2003 Std edition .Configured Transactional (single Publisher and no clustered environment.)
Replication past two months working fine, Now
1.Distrib.exe application err is coming.
Due to which my job is failing (Distributor to Subscriber).
Iam attaching thw file.
Thanks
Sandeep
When I try to manually run one of my scheduled job, DR. Watson comes up and SQL Server crashes. the following error message is received in the NT event log. "Unable to read local Event log, reason the data area passed to a system call is too small". I am new to SQL and this is causing me some degree of stress!!!! Also please recommend a good book for a newbie like me.
Thanks in advance.