SSMS Crashes On Index Creation....

May 16, 2008



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

View 2 Replies


ADVERTISEMENT

Server Management Studio Crashes On Create Index

May 12, 2008



Hi

I'm trying to use a udt in a table creation, and everything works as expected, right until the moment where I rightclick on [Indexes] 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

View 5 Replies View Related

Auto Index Creation By SQL

Jun 21, 2000

Looks like SQL decided to make an index, is this typical? Where can I look at the parameters for this? Thanks

From SQL Profiler:
create statistics hind_239_3 on [calljrnl] ( [cj_created_by] )

View 3 Replies View Related

Right Or Wrong In Index Creation......

Feb 3, 2005

Hi,

like I said in other posts, I'm new to sql server, worked with informix for a long time. Right now I got into an "argument" with the present "dba", the indexes for all the tables in the database are being rebuilt, he wanted to start a monthly process, I told him that he can't do processing because when an index is built the table is locked, now, since I'm new at sql server I would like to know from the experts..... can you run process in sql server against tables when:

- indexes are being created
- the structure of a table is being modified
- the database is being shrunk

If we had been talking about informix then I would have probably slapped him if he tried to "teach" me about how things work, I'm pretty sure its the same in SQL but I think its better to have complete assureness of what I'm talking about before the slapping starts :)

Thanks in advance

Luis Torres

View 6 Replies View Related

Index Creation Progress

Jun 16, 2008

I have 2 questions,

1. I am trying to create an index, which is running for a long time. Is there an option to know the progress so far or how much more time it is going to take?

2. Is there anyway to find out how much space is required to rebuild an index?




------------------------
I think, therefore I am - Rene Descartes

View 2 Replies View Related

Creation Script For An Index

Oct 27, 2005

Hi -

I could not find an SQL script, which would generate index creation DDL for a specific table/index. Query Analyzer does it, but I need to do it programmatically. Does anyone have a working script?
Thank you.

View 3 Replies View Related

Index Creation Date

Jul 23, 2005

Does Microsoft SQL Server keep a record of an index creation date andlast modified date in a system table somewhere?

View 2 Replies View Related

Text Index Creation Fails

Jun 16, 2004

I am trying to create a new full text index on some table and getting the follwing error

"The Microsoft Search service

cannot be administered under the present user account"

i have already checked that Microsoft Search service is properly installed with the server version of SQL Server and this is running under the system account

could anyone plz comeout with the solution to this problem]


thanks in advance
bhavya

View 3 Replies View Related

SQL 2012 :: Index Creation On Predicates

Jan 16, 2015

I was reading this blog below about Indexed Views and needed some clarification.

When the author choose to create the unique clustered index he excluded the PER.BusinessEntityID columns and only included, (CustomerID, SalesOrderID, ProductID).

Why didn't the PER.BusinessEntityID get added?

[URL] ....

CREATE VIEW Sales.vSalesSummaryCustomerProduct
WITH SCHEMABINDING
AS
SELECT CUST.CustomerID ,
SOH.SalesOrderID ,
SOD.ProductID ,
SUM(SOD.OrderQty) AS TotalOrderQty ,

[Code] .....

View 2 Replies View Related

SQL Tools :: Index Was Outside Bounds Of Array SSMS 2014 SP1

Nov 3, 2015

I am getting an intermittent problem with executing queries on my workstation. Whenever I execute a couple of store procedures that return a large numbers of rows (200,000 to 500,000 rows) I receive an intermittent error message when running the same sp with the same parameters sometimes the procedure runs fine and returns the result, sometimes I get an error message

Error message is: Index was outside the bounds of the array.

Sometimes

Error message is: Internal connection fatal error.

Sometimes I get a datetime overflow

I also occasionally get these intermittent messages when I execute the native query that the SP wraps.

I have SSMS 2015 SP1 installed on my workstation, the servers are a range of server from 2008 R2 SP2 to 2014 SP1.  It feels like a client problem as there are applications connecting to these servers and running the stored procedures without issue...

View 2 Replies View Related

SQL 2012 :: Find All Index And Creation Date

Mar 27, 2014

I need to find all the index and the creation date. I did cross apply of sys.objects & Sys.indexes on name column. I am getting some but the team is saying they created so many. Any other option to find Indexes and their creation date?

View 2 Replies View Related

Distributed Database Unique Index Creation

Nov 14, 2007

Can anyone suggest an appropriate strategy to create unique index's when a distributed database is used. As a bit of a background I have several SQL Server 2005 servers scattered around the country and I am trying to come up with a way to create a unique index i.e. one that hasn't been used in a particular table say Staff in any of the databases around the country.

Performance is an issue particularly as our network isn't that fantastic has anyone done something similar and achieved reasonable speeds?

Thanks ...

View 2 Replies View Related

Limiting Disk Utilization For Clustered Index Creation

Aug 28, 2001

Hi,
Does anyone have any good tips for reducing the amount of disk space required for new clustered index creation.

I have just finished building a rather large table (48gbs) and durring the clustered index creation I came very close to running out of disk space.

What I am already doing:
1.Recovery Model simple
2. index padding 0
3. fillfactor 0


Any help would be appreciated
daLoonster

View 1 Replies View Related

SQL Server 2012 :: How To Generate Index Creation Scripts (many Indexes)

Jun 24, 2015

Script they use to generate indexes in SQL 2005.

I have 2 databases on a separate instance. I want to script out all indexes from database1 then execute it on database2.

How to accomplish this task efficiently.

View 5 Replies View Related

Can You, By Default, Allocate Uniform Extents Upon Creation Of Index/table?

Jul 20, 2005

is there a setting that will ebnable uniform extent allocation uponcreation of index/table by default ?if there isn't any default setting can you code it in?thanks,Doron

View 1 Replies View Related

Reporting Services :: Non Clustered Index Creation In SSRS Report

Sep 15, 2015

I have a Performance issue in ssrs report , query  takes  execution time 1  to 2 min. When I add the non clustered index for one of the table columns which takes only 2 sec to execute the query. But as from my environment I couldn't able to add the index due to these changes will effect for all reports. Without adding indexes which takes 2 min to run that report. My question is:

Is there any way to add the non-clustered index on the report itself like if a non clustered index exists "execute the query" else create a non clustered  index and run that report with newly created index in report itself like a temp table concept. How to add this concept in this below query:Final Query without non clustered index, takes 2 min to execution time ---

with cte1
( MovementDate,
MovementTypeDesc,
CDCNumber,
MovementTime,
LocationReportMovement,
OtherLocationCode,

[code]....

View 7 Replies View Related

Order Of Data Load And Index Creation / Move Indexes To Separate Filegroup?

Apr 15, 2015

We are running SQL Server 2014 Enterprise Edition (64-Bit) on Windows 2012 R2 Standard (64-Bit).

1. When to create indexes, before or after data is added? Please address Clustered and Non-Clustered Indexes.

2. To move indexes to it's own filegroup, is it best to create the NON-Clustered Indexes on the separate filegroup with code similar to the example below?

CREATE NONCLUSTERED INDEX IX_Employee_OrganizationLevel_OrganizationNode
ON HumanResources.Employee (OrganizationLevel, OrganizationNode)
WITH (DROP_EXISTING = ON)
ON TransactionsFG1;
GO

I have read the following links that states that if you create the Clustered Index on a separate filegroup, it would also move the base table to that particular filegroup. (So I take it that you ONLY can move NON-CLustered Indexes to a separate filegroup.)

Placing Indexes on Filegroups:

[URL]

By default, indexes are stored in the same filegroup as the base table on which the index is created. A nonpartitioned clustered index and the base table always reside in the same filegroup. However, you can do the following:

• Create nonclustered indexes on a filegroup other than the filegroup of the base table.

Move an Existing Index to a Different Filegroup:

[URL]

Limitations and Restrictions

• If a table has a clustered index, moving the clustered index to a new filegroup moves the table to that filegroup.

• You cannot move indexes created using a UNIQUE or PRIMARY KEY constraint using Management Studio. To move these indexes use the CREATE INDEX statement with the (DROP_EXISTING=ON) option in Transact-SQL.

View 1 Replies View Related

Index Creation Causes Error The Conversion Of A Char Data Type To A Datetime Data Type Resulted...

Jul 23, 2005

Hi all,I have a table called PTRANS with few columns (see create script below).I have created a view on top that this table VwTransaction (See below)I can now run this query without a problem:select * from dbo.VwTransactionwhereAssetNumber = '101001' andTransactionDate <= '7/1/2003'But when I create an index on the PTRANS table using the command below:CREATE INDEX IDX_PTRANS_CHL# ON PTRANS(CHL#)The same query that ran fine before, fails with the error:Server: Msg 242, Level 16, State 3, Line 1The conversion of a char data type to a datetime data type resulted inan out-of-range datetime value.I can run the same query by commeting out the AssetNumber clause and itworks fine. I can also run the query commenting out the TransactionDatecolumn and it works fine. But when I have both the conditions in theWHERE clause, it gives me this error. Dropping the index solves theproblem.Can anyone tell me why an index would cause a query to fail?Thanks a lot in advance,AmirCREATE TABLE [PTRANS] ([CHL#] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[CHCENT] [numeric](2, 0) NOT NULL ,[CHYYMM] [numeric](4, 0) NOT NULL ,[CHDAY] [numeric](2, 0) NOT NULL ,[CHTC] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL) ON [PRIMARY]GOCREATE VIEW dbo.vwTransactionsASSELECT CONVERT(datetime, dbo.udf_AddDashes(REPLICATE('0', 2 -LEN(CHCENT)) + CONVERT(varchar, CHCENT) + REPLICATE('0', 4 -LEN(CHYYMM))+ CONVERT(varchar, CHYYMM) + REPLICATE('0', 2 -LEN(CHDAY)) + CONVERT(varchar, CHDAY)), 20) AS TransactionDate,CHL# AS AssetNumber,CHTC AS TransactionCodeFROM dbo.PTRANSWHERE (CHCENT <> 0) AND (CHTC <> 'RA')*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View 1 Replies View Related

Difference Between Index Seek &&amp; Index Scan &&amp; Index Lookup Operations?

Oct 20, 2006

please explain the differences btween this logical & phisicall operations that we can see therir graphical icons in execution plan tab in Management Studio

thank you in advance

View 3 Replies View Related

SQL 2012 :: Trace Creation Time Is Different From Time Check Creation

Oct 8, 2014

We have an SSAS instance where when we run the query "select * from $system.discover_traces" the creation time in the resultset shows a different time from when we actually started the trace.

for example if we have create the trace at 3.30pm it shows 7.35 pm in the Sql server management studio resultset when we run the query "select * from $system.discover_traces".

View 0 Replies View Related

Dts Crashes

Jul 14, 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

View 4 Replies View Related

SETUSER Crashes

Jan 4, 2000

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 Related

More Server Crashes

Mar 29, 1999

View 1 Replies View Related

Server Crashes

Jan 20, 2004

We 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

View 2 Replies View Related

Sub-Report Crashes

Jul 20, 2007

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 &amp; " - " &amp; 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:" &amp; Fields!EmployerID.Value &amp;"|FileName:" &amp; 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 # " &amp; Fields!InvoiceGroup.Value</Value>
</Textbox>
</ReportItems>
<Top>7.83333in</Top>
<ZIndex>4</ZIndex>
<Visibility>
<Hidden>=iif(countrows("Body_MainGroup_Details_Group")&gt; 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

View 4 Replies View Related

Sql Server 7.0 Crashes Continuously

Dec 15, 1999

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 Related

MSDE Installation Crashes Pc

Jun 22, 2007

Hi 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 :)

View 1 Replies View Related

Management Studio Crashes

Jan 15, 2008

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.

View 3 Replies View Related

Sqldmo ListAvailableSQLServers Crashes

Jul 23, 2005

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 Related

Indexed View Crashes ASP.NET App

Oct 13, 2007

I 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 Related

Logging To Second Disk -- What Happens When It Crashes?

Jul 20, 2005

Currently 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 Related

Unnamed Parameter Crashes VS

Jun 14, 2007

I'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.

View 1 Replies View Related

VS Crashes When I Use Calculated Fields

May 22, 2008



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

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved