/3GB not working

Hi,

I am on a box with 4 GB of memory that only runs SQL Server. SQL Server is using 1.7 GB as per task manager. There are a lot of databases on this box. I looked at the boot.ini and /3GB was not set. I have done this at least 50 times before: turn on the /3GB switch and SQL Server will use up to 2.7 GB per task manager. (I know it is actually 2GB and 3GB but it seems that in task manager it shows up as 1.7-1.8 and 2.7-2.8)

Anyway back to the story. So I set /3GB, rebooted the server and SQL Server still only consumes up to 1.7GB. I realize that SQL Server might not actually need more memory, but I have a distinct feeling that it wants more but is being constrained; that is, the the /3GB switch is not working. More relevant information:

1) the boot.ini line:
multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft Windows 2000 Advanced Server" /fastdetect /3GB

2) max server memory (MB) = 3000

3) min server memory (MB) = 3000

4) awe enabled = 0

5) @.@.version = 8.00.2039 which is SQL Server 2000 SP4

Has anyone seen this before? Any ideas on how to troubleshoot this?Just figured out the problem: This server is using SQL Server 2000 Standard Edition. For the benefit of all future readers of this thread, the maximum amount of memory that SQL Server 2000 Standard Edition and SQL Server 2000 Personal Edition can ever use is 2GB. SQL Server 2000 Developer's Edition and SQL Server 2000 Enterprise Edition will both go higher. The actual amount of memory is dependent on the operating system.

.txt file to SQL Server 2005

My package inserts a text file into a database table. It first deletes the table rows, reseeds identity to 0 then inserts data from a .txt file.

Runs fine in development. When the package is run on the live server, it appears to have trouble connecting. I've checked the connection strings and they should be fine.

Error: An OLE DB error has occurred. Error code: 0x8000FFFF
Error: The AcquireConnection metod call to the connection manager "MyServer.MyDB" failed with error code 0x8000FFFF

Any suggestions?Issue resolved: it didn't occur to me until now that I needed to change the configuration Data Source to "localhost" once it was on the server!!! Works like a charm now! My first SSIS pkg installed and working, now to create a job to run it each morning...the adventure continues.

.dll files

Hello all,
I am currently looking to run my database using MSDE as
opposed to SQL 7.0. My database runs ok using 7.0 but
when i use MSDE i generate an error. I have run a windiff
on the files installed by 7.0 and those installed by MSDE
and came up with the following results. Can anyone help
me with regards what do these files do' In particular i
am looking out for files that deal with network
connectivity.
Many Thanks
MalThe files concerned are -
autoplt.dll
autowiz.dll
ce_clnt.dll
dtsui.dll
sqlftwiz.dll
sqlqry.dll
stardds.dll
tracewiz.dll|||If you describe the error it's be a lot easier to help you.
Andrés Taylor
"mal" <malpmcc@.hotmail.com> wrote in message
news:068e01c39173$95f45470$a001280a@.phx.gbl...
> Hello all,
> I am currently looking to run my database using MSDE as
> opposed to SQL 7.0. My database runs ok using 7.0 but
> when i use MSDE i generate an error. I have run a windiff
> on the files installed by 7.0 and those installed by MSDE
> and came up with the following results. Can anyone help
> me with regards what do these files do' In particular i
> am looking out for files that deal with network
> connectivity.
> Many Thanks
> Mal|||I think if i found out the definitions of these files i should be able to find the source of the problem. If anyone could maybe direct me to where i could find the file definitions it would be a great help.
Many thanks
>--Original Message--
>If you describe the error it's be a lot easier to help you.
>Andr=E9s Taylor
>"mal" <malpmcc@.hotmail.com> wrote in message
>news:068e01c39173$95f45470$a001280a@.phx.gbl...
>> Hello all,
>> I am currently looking to run my database using MSDE as
>> opposed to SQL 7.0. My database runs ok using 7.0 but
>> when i use MSDE i generate an error. I have run a windiff
>> on the files installed by 7.0 and those installed by MSDE
>> and came up with the following results. Can anyone help
>> me with regards what do these files do' In particular i
>> am looking out for files that deal with network
>> connectivity.
>> Many Thanks
>> Mal
>
>.
>

...Contains more than the maximum number of prefixes. The maximum is 3.

SQL Server 2000 8.00.760 (SP3)

I've been working on a test system and the following UDF worked fine.
It runs in the "current" database, and references another database on
the same server called 127-SuperQuote.

CREATE FUNCTION fnGetFormattedAddress(@.WorkID int)

RETURNS varchar(130)

AS

BEGIN

DECLARE

@.Address1 As varchar(50)
@.ReturnAddress As varchar(130)

SELECT
@.Address1 = [127-SuperQuote].dbo.tblCompany.Address1
FROM
[Work] INNER JOIN
[127-SuperQuote].dbo.tblCompany ON [Work].ClientID =
[127-SuperQuote].dbo.tblCompany.CompanyID
WHERE
[Work].WorkID = @.WorkID

IF @.Address1 IS NOT NULL
SET @.ReturnAddress = @.ReturnAddress + @.Address1 + CHAR(13)+ CHAR(10)

RETURN @.ReturnAddress

END

So now the system has gone live and it turns out that the live
"SuperQuote" database is on a different server.

I've linked the server and changed the function as below, but I get an
error both in QA and when checking Syntax in the UDF builder:

The number name 'Zen.SuperQuote.dbo.tblCompany' contains more than the
maximum number of prefixes. The maximum is 3.

CREATE FUNCTION fnGetFormattedAddress(@.WorkID int)

RETURNS varchar(130)

AS

BEGIN

DECLARE

@.Address1 As varchar(50)
@.ReturnAddress As varchar(130)

SELECT
@.Address1 = Zen.SuperQuote.dbo.tblCompany.Address1
FROM
[Work] INNER JOIN
Zen.SuperQuote.dbo.tblCompany ON [Work].ClientID =
Zen.SuperQuote.dbo.tblCompany.CompanyID
WHERE
[Work].WorkID = @.WorkID

IF @.Address1 IS NOT NULL
SET @.ReturnAddress = @.ReturnAddress + @.Address1 + CHAR(13)+ CHAR(10)

RETURN @.ReturnAddress

END

How can I get round this? By the way, I've rather simplified the
function to ease readability. Also, I haven't posted any DDL because I
don't think that's the problem!

Thanks

Edwardteddysnips@.hotmail.com wrote:
[...]

Alias, you dolt!

Sorry if I've wasted anyone's time.

Edward|||Thanks for wasting even more of everyone's time by not indicating your mistake and having this useless thread replicated to dozens of other forums!

From http://www.developmentnow.com/g/95_...ximum-is-3-.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com