Failed to reserve contiguous memory

Guys,
does anyone know what to do when you get this kind of
error message: My server is windows 2000 sp4, sql2000
sp3a, Here is the min and max memory configuration in
sp_config
min memory per query (KB) 512 2147483647
min server memory (MB) 0 2147483647
WARNING: Failed to reserve contiguous memory of Size= 65536.
Buffer Distribution: Stolen=4294948690 Free=412
Procedures=142775
Inram=0 Dirty=1232 Kept=0
I/O=0, Latched=41, Other=105186
Does anyone know what needs to be done. It happened
yester at 4pm and hasn't happened again. Let me know
please. Thanks.
Mary LouChances are it is related to one of these:
http://support.microsoft.com/default.aspx?scid=kb;en-us;832674&Product=sql2k
http://support.microsoft.com/default.aspx?scid=kb;en-us;818095&Product=sql2k
http://support.microsoft.com/default.aspx?scid=kb;en-us;316749&Product=sql2k
Andrew J. Kelly SQL MVP
"Mary Lou" <anonymous@.discussions.microsoft.com> wrote in message
news:197a01c4a25a$62bf7f50$a301280a@.phx.gbl...
> Guys,
> does anyone know what to do when you get this kind of
> error message: My server is windows 2000 sp4, sql2000
> sp3a, Here is the min and max memory configuration in
> sp_config
> min memory per query (KB) 512 2147483647
> min server memory (MB) 0 2147483647
>
> WARNING: Failed to reserve contiguous memory of Size=> 65536.
> Buffer Distribution: Stolen=4294948690 Free=412
> Procedures=142775
> Inram=0 Dirty=1232 Kept=0
> I/O=0, Latched=41, Other=105186
>
> Does anyone know what needs to be done. It happened
> yester at 4pm and hasn't happened again. Let me know
> please. Thanks.
> Mary Lou

Failed to reserve contiguous memory

Guys,
does anyone know what to do when you get this kind of
error message: My server is windows 2000 sp4, sql2000
sp3a, Here is the min and max memory configuration in
sp_config
min memory per query (KB)5122147483647
min server memory (MB)02147483647
WARNING: Failed to reserve contiguous memory of Size=
65536.
Buffer Distribution: Stolen=4294948690 Free=412
Procedures=142775
Inram=0 Dirty=1232 Kept=0
I/O=0, Latched=41, Other=105186
Does anyone know what needs to be done. It happened
yester at 4pm and hasn't happened again. Let me know
please. Thanks.
Mary Lou
Chances are it is related to one of these:
http://support.microsoft.com/default...&Product=sql2k
http://support.microsoft.com/default...&Product=sql2k
http://support.microsoft.com/default...&Product=sql2k
Andrew J. Kelly SQL MVP
"Mary Lou" <anonymous@.discussions.microsoft.com> wrote in message
news:197a01c4a25a$62bf7f50$a301280a@.phx.gbl...
> Guys,
> does anyone know what to do when you get this kind of
> error message: My server is windows 2000 sp4, sql2000
> sp3a, Here is the min and max memory configuration in
> sp_config
> min memory per query (KB) 512 2147483647
> min server memory (MB) 0 2147483647
>
> WARNING: Failed to reserve contiguous memory of Size=
> 65536.
> Buffer Distribution: Stolen=4294948690 Free=412
> Procedures=142775
> Inram=0 Dirty=1232 Kept=0
> I/O=0, Latched=41, Other=105186
>
> Does anyone know what needs to be done. It happened
> yester at 4pm and hasn't happened again. Let me know
> please. Thanks.
> Mary Lou

Failed to reinstall sql server 05

Hi guys, I had sql server 05 RTM Developer installed on my laptop before and decided to remove and reinstall it. because i want it on a different drive. I went ahead and uninstalled everything that had to do SQL Server 2005. When I come to reinstall it, it throws me with an error saying,

- Performance Monitor Counter Requirement (Error)
Messages
Performance Monitor Counter Requirement
The System Configuration Check for Performance Monitor counter registry value has failed. For details, see How to: Increment the Counter Registry Key for Setup in SQL Server 2005, in the readme file or in SQL Server Books Online.

I looked up the fix article that te message is referring to
http://msdn2.microsoft.com/en-us/library/ms143215(SQL.90).aspx

And it simply didnt do the job. same error keeps coming back.

Anyone has come across this before and would like to share some knowledge plz.

Cheers!

This might be a stupid question, but do you have sufficient rights to run lodctr.exe?

(as described in the msdn article, if this program can't be run, you get the same error message)

|||yea. it's my personal laptop where I am an admin...
|||I found out what the problem was... I have XP Chinese Simplified Edition on my laptop which somehow puts a directory "004" under perflib alongside with "009" i.e.;

Besides:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009

There is also a:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\004
"004" has exactly the same registries as "009". BUT I need to align the registries in "Perflib" with the them in "004" rather than "009"...

It might apply to XP in other languages too.

Failed insert via Enterprise Manager

Hey guys..

Trying to insert a row via Enterprise Manager I get "object does not exist" error.. However it works on another server?!?

The table name is aa.aabc .. So i know what the problem is.. it thinks that aa is the owner.. I can insert using query analyzer by using the following syntax: insert into [aa.aabc] ... but it fails using: insert into aa.abc .. for obvious reasons..

I'm guessing it has something to do with the differences in the server config between the 2 servers as to why one server you can insert via enterprise manager and the other you cant..

The collation is different as the ANSI warning and padding in the connection info..

Can anyone else help me fix this problem, so that I can insert using enterprise manager?

CheersINSERT into EM Where?|||Databases --> Databasename --> Tables --> Tablename --> Return all rows.. Then you can scroll to the bottom row and insert in a similar way to access..

THanks

Fact Table/Dimension and Multiple Level Dimension

Hi Guys,

I have two questions on Analysis Service for SQL SERVER 2005:-

a) Is it possible for me to use two tables from my database without Primary Key. As this use to work on my Analysis Service on SQL SERVER 2000.

b) I had a multiple Level Dimension in SQL SERVER 2000 with Key Column as one column in my table and name column as another in my table. I am not able to do the same in SQL SERVER 2005.

Urgent help is requried.

Regards,

Kaushal

a)You do not need primary keys in the source data base but I think you need to set logical primary keys in the data source view.

b)Key and name columns are still separated in Analysis Services 2005.

Regards

Thomas Ivarsson

|||

Hi Thomas,

Thanks for Reply.

a) Yes i do understand that, but then what happens if i want to use the columns used in Primary key as levels in a Dimension?

b) I am still not understanding how to take kare of Key and Name Columns?

Regards,

Kaushal

Extracting data from SQL Server to XML documents

Hey guys, here's the situation.
I need to extract data from SQL Server to multiple XML files, on a daily
basis.
What is the best strategy to accomplish this task?
I did try two things already. These method were using stored procedures.
The first one was the use of the System Stored Procedure sp_makewebtask
using template files. This task failed due to a dll error.
My second attempt was using the "bcp" utility. It didn't work because of the
version of SQL Server we are using right now (too old).
Is there any other ways to generate XML from SQL Server? Can we use DTS to
accomplished this task?
Thanks for the help!
If you're using SQL Server 2000, you can use a variety of techniques -
including FOR XML queries, annotated schemas, etc. See SQL Server Books
Online, and install SQLXML 3.0
(http://www.microsoft.com/downloads/d...isplayLang=en.).
For earlier versions, you'd have to write a custom solution - there's no
built-in support for XML.
Graeme Malcolm
Principal Technologist
Content Master
- a member of CM Group Ltd.
www.contentmaster.com
"Dominic Feron" <dominic.feron@.dessausoprin.com> wrote in message
news:%23W6QGyiVFHA.3280@.TK2MSFTNGP09.phx.gbl...
Hey guys, here's the situation.
I need to extract data from SQL Server to multiple XML files, on a daily
basis.
What is the best strategy to accomplish this task?
I did try two things already. These method were using stored procedures.
The first one was the use of the System Stored Procedure sp_makewebtask
using template files. This task failed due to a dll error.
My second attempt was using the "bcp" utility. It didn't work because of the
version of SQL Server we are using right now (too old).
Is there any other ways to generate XML from SQL Server? Can we use DTS to
accomplished this task?
Thanks for the help!
|||thx for the info!
"Graeme Malcolm" <graemem_cm@.hotmail.com> a crit dans le message de
news:u4T2%23UjVFHA.1796@.TK2MSFTNGP15.phx.gbl...
> If you're using SQL Server 2000, you can use a variety of techniques -
> including FOR XML queries, annotated schemas, etc. See SQL Server Books
> Online, and install SQLXML 3.0
>
(http://www.microsoft.com/downloads/d...a154-8e23-47d2
-a033-764259cfb53b&DisplayLang=en.).
> For earlier versions, you'd have to write a custom solution - there's no
> built-in support for XML.
> --
> Graeme Malcolm
> Principal Technologist
> Content Master
> - a member of CM Group Ltd.
> www.contentmaster.com
>
> "Dominic Feron" <dominic.feron@.dessausoprin.com> wrote in message
> news:%23W6QGyiVFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hey guys, here's the situation.
> I need to extract data from SQL Server to multiple XML files, on a daily
> basis.
> What is the best strategy to accomplish this task?
> I did try two things already. These method were using stored procedures.
> The first one was the use of the System Stored Procedure sp_makewebtask
> using template files. This task failed due to a dll error.
> My second attempt was using the "bcp" utility. It didn't work because of
the
> version of SQL Server we are using right now (too old).
> Is there any other ways to generate XML from SQL Server? Can we use DTS to
> accomplished this task?
> Thanks for the help!
>
>

Extracting data from SQL Server to XML documents

Hey guys, here's the situation.
I need to extract data from SQL Server to multiple XML files, on a daily
basis.
What is the best strategy to accomplish this task?
I did try two things already. These method were using stored procedures.
The first one was the use of the System Stored Procedure sp_makewebtask
using template files. This task failed due to a dll error.
My second attempt was using the "bcp" utility. It didn't work because of the
version of SQL Server we are using right now (too old).
Is there any other ways to generate XML from SQL Server? Can we use DTS to
accomplished this task?
Thanks for the help!If you're using SQL Server 2000, you can use a variety of techniques -
including FOR XML queries, annotated schemas, etc. See SQL Server Books
Online, and install SQLXML 3.0
(http://www.microsoft.com/downloads/...DisplayLang=en.).
For earlier versions, you'd have to write a custom solution - there's no
built-in support for XML.
Graeme Malcolm
Principal Technologist
Content Master
- a member of CM Group Ltd.
www.contentmaster.com
"Dominic Feron" <dominic.feron@.dessausoprin.com> wrote in message
news:%23W6QGyiVFHA.3280@.TK2MSFTNGP09.phx.gbl...
Hey guys, here's the situation.
I need to extract data from SQL Server to multiple XML files, on a daily
basis.
What is the best strategy to accomplish this task?
I did try two things already. These method were using stored procedures.
The first one was the use of the System Stored Procedure sp_makewebtask
using template files. This task failed due to a dll error.
My second attempt was using the "bcp" utility. It didn't work because of the
version of SQL Server we are using right now (too old).
Is there any other ways to generate XML from SQL Server? Can we use DTS to
accomplished this task?
Thanks for the help!|||thx for the info!
"Graeme Malcolm" <graemem_cm@.hotmail.com> a crit dans le message de
news:u4T2%23UjVFHA.1796@.TK2MSFTNGP15.phx.gbl...
> If you're using SQL Server 2000, you can use a variety of techniques -
> including FOR XML queries, annotated schemas, etc. See SQL Server Books
> Online, and install SQLXML 3.0
>
(http://www.microsoft.com/downloads/...4a154-8e23-47d2
-a033-764259cfb53b&DisplayLang=en.).
> For earlier versions, you'd have to write a custom solution - there's no
> built-in support for XML.
> --
> Graeme Malcolm
> Principal Technologist
> Content Master
> - a member of CM Group Ltd.
> www.contentmaster.com
>
> "Dominic Feron" <dominic.feron@.dessausoprin.com> wrote in message
> news:%23W6QGyiVFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hey guys, here's the situation.
> I need to extract data from SQL Server to multiple XML files, on a daily
> basis.
> What is the best strategy to accomplish this task?
> I did try two things already. These method were using stored procedures.
> The first one was the use of the System Stored Procedure sp_makewebtask
> using template files. This task failed due to a dll error.
> My second attempt was using the "bcp" utility. It didn't work because of
the
> version of SQL Server we are using right now (too old).
> Is there any other ways to generate XML from SQL Server? Can we use DTS to
> accomplished this task?
> Thanks for the help!
>
>

extracting data from a varchar variable?

Guys.

I have some data like this one:

'Uploadfiles\CompanyID\ProjectCode\Files\File1.doc'

P.S: the values may vary each time.

I need to programmatically extract from that kind of string only file1.doc

Ho can I dynamically do it? any function? statement? etc? please help.

The idea is getting only the string after the last "\"

Thanks
Frdeclare @.t varchar(256)

select @.t = 'Uploadfiles\CompanyID\ProjectCode\Files\File1.doc'

select reverse(substring(reverse(@.t),1,patindex('%\%',reverse(@.t))-1))

Extracting currency symbol and measurement units using tSQL

Hi guys,
Does anyone know how to extract the currency symbol and measurement
unitsusing an ISQL query?
For instance, in .NET I can very easily do the following
-Thread.CurrentThread.CurrentCulture.NumberFormat.CurrencySymbol and
System.Globalization.RegionInfo.CurrentRegion.IsMetric
Is such a thing possible under SQL Server?
Cheers
MBmukesh bhakta (mukesh_bhakta@.hotmail.com) writes:
> Does anyone know how to extract the currency symbol and measurement
> unitsusing an ISQL query?
>
> For instance, in .NET I can very easily do the following
> -Thread.CurrentThread.CurrentCulture.NumberFormat.CurrencySymbol and
> System.Globalization.RegionInfo.CurrentRegion.IsMetric
> Is such a thing possible under SQL Server?
I don't think it even makes sense. Measurement unit certanly doesn't,
because SQL Server does not use any measurement unit as far as I recall.
Currency symbols are used with the money data type, but I don't really
know whether this affected by language settings. (Which are separate from
Windows regional settings.) A quick test indicated that all of $,
and were understood as currency signs.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I have found the only way is to access the Windows registry using the
sp's supplied inside SQL Server.|||mukesh bhakta (mukesh_bhakta@.hotmail.com) writes:
> I have found the only way is to access the Windows registry using the
> sp's supplied inside SQL Server.
But I can't really see that you have any use for this information?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Extracting Contents of Object Variable in script Task

Hey Guys,

Im pretty new to Scripting in SSIS, but i have worked a fair bit out already, although i am stuck with the following problem.. If anyone can help out that would be great!!

Ok, i have a package that loops through records in a table, and extracts the detailed lines in a For Each loop. and stores them in a variable called DetailRecordSet with an data type of object.

I have a built a script task so that i can send out an email confirmation for each order, and i want to list the details in a HTML Table in the body of the message ( I have read that the standard send mail task wont support this, but found an example of using .NET code to generate the email message which will support it) .

What i want to know is how do i reference the columns in the Object variable so i can extract each line and add it into my string that i am creating with HTML codes.. I

e:( str = "<TABLE> <TR>" + Cstr(Variable for 1st column in recordset) + " </TR>"

if any can help my, that would be most appriciated.. Ive tried all different things that ive found on the net, but nothing is working.

Thanks in Advance

Scotty

To know how to interact with SSIS object variable's underlying type, you need to know the type itself. That is, the type of the "thing" stored by reference in the SSIS object variable.

What the actual underlying type of the variable stored in the SSIS variable of type object?

System.Windows.Forms.MessageBox.Show(Dts.Variables("DetailRecordSet").Value.GetType().FullName)

The above MessageBox() will display the underlying type in your script task, excepting Com callable wrappers (of type System.__Object).
|||

Sorry for the late reply Jaegd. but have been away for a few days,,

This object type is System.Object. from the variable section i select the data type to be Object.

I appricate your help still, cause i am still stuck

Thanks

Scotty

|||

As per the previous reply, knowing what is in the object is crucial. From your reply it is a COM object, so I'll guess that it is probably an ADO recordset. IN which case take a look here for some links and pointers - http://blogs.conchango.com/jamiethomson/archive/2005/02/08/SSIS_3A00_-Accessing-a-recordset-in-a-script-task.aspx

If that does not help, then help me, as I don't understand how you got there. So what has populated the variable exactly, and what method was used? If it is the For Each loop, what enumerator have you used?