Showing posts with label wrong. Show all posts
Showing posts with label wrong. Show all posts

Monday, March 12, 2012

Maximum Possible Database Size

I posted this in another area and didn't get an answer, so maybe I posted it in the wrong place. Forgive me if you've seen this twice.

I'm trying to figure out what the ultimate size limitation for a SQL 2005 Enterprise server is. This document is helpful but I'm a bit confused:

http://msdn2.microsoft.com/en-us/library/ms143432.aspx

In the document, it says that the maximum database size is 524,258 terabytes; however, it also says that the maximum data file size--which I assume is the .MDF file--is 16 terabytes. My question is, how can you create a 524,258 TB database if the maximum file size 16 TB?

Dumb question, I'm sure...please enlighten me!

Norm

The .mdf file is the primary data file. You can create secondary data files (typically .ndf file extension) and with large databases you typically will. This allows you to distribute your data across multiple disk spindles or multiple LUN's if your company is using a SAN.

Maximum page width in Crystal Reports 8

Hi. I'm new to the forum. I apologize if this is the wrong place to pose such a question, or if it's been answered in another thread. I searched and did not find anything.

I don't want to bog everyone down in the details, but I want to give at least a little background as to the problem.

We use Crystal Reports 8.0.1 in conjunction with PeopleSoft Financials 8 to produce positive pay files out of our pay cycle process-which creates checks for vendors. The positive pay file includes basic check information-check number, date, etc. The pay cycle uses the Crystal Report definition, and creates a .txt positive pay file.

Due to new bank requirements, we now have to add several new fields to the file. The Crystal report designer doesn't seem capable of letting me go any further to the right than I already am. On print setup, I changed the layout to landscape, and the paper type to tabloid, and this definitely gave me some extra room. However, I still need about another 100 characters or so.

Does anyone know of any way to expand the page width further than I already have?

Help is much appreciated!Hi

I faced the same problem.. you can try to create a new custom paper size for your printer and change the designer printer setup paper size..
I failed to create a new paper size..
i would like to change the page header of the report also.. can anyone help?