.net 1.1 SqlDbType accepts varchar(MAX)

My app uses .net 1.1 and MS SQL 2005 as backend. How to add a SqlParamter that is varchar(MAX)?

SqlParameter myParameter = new SqlParameter("@.Description",SqlDbType.VarChar,whatToPutHere?,ParameterDirection.Input,
true,0,0,"Whatever",DataRowVersion.Current,"Whatever");

That's the size position, right? Put the max value you expect to have. Max allowable is 8000

|||

Try:

SqlParameter myParameter = new SqlParameter("@.Description",SqlDbType.VarChar);

|||

Motley:

SqlDbType.VarChar

I'm not positive about this, but make sure that if you leave the VarChar declaration w/o a length parm that it won't default to VarChar(1) (ie, max 1 char). I think it may do this but I could be wrong. I am pretty sure that if you declare a variable as

declare @.v varchar

that it sets the max size to 1, for example (but I'mnot anywhere where I can double check that statment, though<g>)

|||

Motley:

SqlDbType.VarChar

I'm not positive about this, but make sure that if you leave the VarChar declaration w/o a length parm that it won't default to VarChar(1) (ie, max 1 char). I think it may do this but I could be wrong. I am pretty sure that if you declare a variable as

declare @.v varchar

that it sets the max size to 1, for example (but I'mnot anywhere where I can double check that statment, though<g>)

.doc iFilter not working for Mobile docs

Hi,
I have implemented full text searching over files stored in a varbinary(max)
field and this works great
The only issue i am now having is that users creating office documents
created on a Windows Mobile device such as word docs are not being searched.
The extension is .doc but the files look cut down in size.
Does anyone know of a filter or filter update that will also search office
type files created on a Windows Mobile device?
Thanks,
Jeff
The iFilters are specific for document type. The PocketWord application does
not save it in a format that the Office iFilter can understand. You would be
better off to convert them to Word.
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:87EE86C3-0B73-4F23-B1C2-FCB85A15DF5B@.microsoft.com...
> Hi,
> I have implemented full text searching over files stored in a
> varbinary(max)
> field and this works great
> The only issue i am now having is that users creating office documents
> created on a Windows Mobile device such as word docs are not being
> searched.
> The extension is .doc but the files look cut down in size.
> Does anyone know of a filter or filter update that will also search office
> type files created on a Windows Mobile device?
> Thanks,
> Jeff
|||Hi Hilary,
Thanks for your answer.
What I find strange is that the device saves the document with the extension
..doc, but is not a true word document format. So when I check the file
extension with the supported SQL iFilter extensions I get a match and save it
in the db for indexing and searching.
How would I go about programaticaly converting the uploaded docs from the
mobile devices to the full Office document standard supported by the Office
iFilter?
Thanks for your help,
Jeff
"Hilary Cotter" wrote:

> The iFilters are specific for document type. The PocketWord application does
> not save it in a format that the Office iFilter can understand. You would be
> better off to convert them to Word.
> "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
> news:87EE86C3-0B73-4F23-B1C2-FCB85A15DF5B@.microsoft.com...
>
>
|||You would have to use Word to convert the files to the Office Word document
format as opposed to the Pocket Word format.
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:20A3F7E8-C0C6-490A-B555-EAD7931C62E0@.microsoft.com...[vbcol=seagreen]
> Hi Hilary,
> Thanks for your answer.
> What I find strange is that the device saves the document with the
> extension
> .doc, but is not a true word document format. So when I check the file
> extension with the supported SQL iFilter extensions I get a match and save
> it
> in the db for indexing and searching.
> How would I go about programaticaly converting the uploaded docs from the
> mobile devices to the full Office document standard supported by the
> Office
> iFilter?
> Thanks for your help,
> Jeff
> "Hilary Cotter" wrote:

(Target Server Memory)Perf. Monitor Counters

Yes, we have AWE set to 1 and max server memory set to
5120. Yes, this is a SQL Server 2000 Enterprise Edition
with Windows 2000 Advanced Server. SQL Server is
clustered also. After the 2GB of RAM (6GB + 2GB) was
added to the server the script listed below was applied to
the server.
We have three other servers that have the same
configuration and SQL Server Memory Manager (Target Server
Memory) is set correctly at 5.12GB. But when you run
Performance Monitor and display SQL Server Memory Manager
(Target Server Memory) it is set to 2.7GB
I replied the script listed below but it did not change
the SQL Server Memory Manager (Target Server Memory) value.
Please help me with this problem.
Thanks,
Mike
sp_configure "show advanced options", 1
RECONFIGURE
GO
sp_configure "awe enabled", 1
RECONFIGURE
GO
sp_configure "max server memory", 5120
RECONFIGURE
GO
sp_configure "min server memory", 0
RECONFIGURE
GO
Do you have AWE enabled in SQL?
Are you running Enterprise Edition SQL?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> Why does'nt my Target Server Memory value (2.7 GB) within
> Memory Manager in the Performance Monitor Counters match
> the values in SQL Server Memory Maximum Value (5.2 GB)
> My Target Server Memory displays a value of 2.7 GB and
the
> SQL Memory Maximum displays 5.2 GB.
> The boot.ini is set with the following parameters:
> [boot loader]
> timeout=10
> default=multi(0)disk(0)rdisk(0)partition(1)\WINNT
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microso ft
> Windows 2000 Advanced Server" /fastdetect /3gb /PAE
> The server initially had 6GB of RAM and 2GB were added to
> the server. SQL Server displays 5.2 GB is the maximum
alot
> memory and Dynamically configure SQL Server memory.
> How can I fix the memory problem.
> Thanks,
> Mike
>
..
What is the Total Server Memory counter value?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:94e101c43372$1237ed80$a001280a@.phx.gbl...
> Yes, we have AWE set to 1 and max server memory set to
> 5120. Yes, this is a SQL Server 2000 Enterprise Edition
> with Windows 2000 Advanced Server. SQL Server is
> clustered also. After the 2GB of RAM (6GB + 2GB) was
> added to the server the script listed below was applied to
> the server.
> We have three other servers that have the same
> configuration and SQL Server Memory Manager (Target Server
> Memory) is set correctly at 5.12GB. But when you run
> Performance Monitor and display SQL Server Memory Manager
> (Target Server Memory) it is set to 2.7GB
> I replied the script listed below but it did not change
> the SQL Server Memory Manager (Target Server Memory) value.
> Please help me with this problem.
> Thanks,
> Mike
>
> sp_configure "show advanced options", 1
> RECONFIGURE
> GO
> sp_configure "awe enabled", 1
> RECONFIGURE
> GO
> sp_configure "max server memory", 5120
> RECONFIGURE
> GO
> sp_configure "min server memory", 0
> RECONFIGURE
> GO
>
>
> Do you have AWE enabled in SQL?
> Are you running Enterprise Edition SQL?
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> "Mike" <anonymous@.discussions.microsoft.com> wrote in
> message
> news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> the
> alot
>
> .
>
|||The Total Server Memory counter value?
8,125,736 KB of RAM
Thank You,
Mike

>--Original Message--
>What is the Total Server Memory counter value?
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:94e101c43372$1237ed80$a001280a@.phx.gbl...
to[vbcol=seagreen]
Server[vbcol=seagreen]
Manager[vbcol=seagreen]
value.[vbcol=seagreen]
within[vbcol=seagreen]
match[vbcol=seagreen]
added to
>
>.
>

(Target Server Memory)Perf. Monitor Counters

Yes, we have AWE set to 1 and max server memory set to
5120. Yes, this is a SQL Server 2000 Enterprise Edition
with Windows 2000 Advanced Server. SQL Server is
clustered also. After the 2GB of RAM (6GB + 2GB) was
added to the server the script listed below was applied to
the server.
We have three other servers that have the same
configuration and SQL Server Memory Manager (Target Server
Memory) is set correctly at 5.12GB. But when you run
Performance Monitor and display SQL Server Memory Manager
(Target Server Memory) it is set to 2.7GB
I replied the script listed below but it did not change
the SQL Server Memory Manager (Target Server Memory) value.
Please help me with this problem.
Thanks,
Mike
sp_configure "show advanced options", 1
RECONFIGURE
GO
sp_configure "awe enabled", 1
RECONFIGURE
GO
sp_configure "max server memory", 5120
RECONFIGURE
GO
sp_configure "min server memory", 0
RECONFIGURE
GO
Do you have AWE enabled in SQL?
Are you running Enterprise Edition SQL?
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
>
> Why does'nt my Target Server Memory value (2.7 GB) within
> Memory Manager in the Performance Monitor Counters match
> the values in SQL Server Memory Maximum Value (5.2 GB)
>
> My Target Server Memory displays a value of 2.7 GB and
the
> SQL Memory Maximum displays 5.2 GB.
>
> The boot.ini is set with the following parameters:
> [boot loader]
> timeout=10
> default=multi(0)disk(0)rdisk(0)partition(1)\WINNT
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft
> Windows 2000 Advanced Server" /fastdetect /3gb /PAE
>
> The server initially had 6GB of RAM and 2GB were added to
> the server. SQL Server displays 5.2 GB is the maximum
alot
> memory and Dynamically configure SQL Server memory.
>
> How can I fix the memory problem.
>
> Thanks,
>
> Mike
>
.What is the Total Server Memory counter value?
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:94e101c43372$1237ed80$a001280a@.phx.gbl...
> Yes, we have AWE set to 1 and max server memory set to
> 5120. Yes, this is a SQL Server 2000 Enterprise Edition
> with Windows 2000 Advanced Server. SQL Server is
> clustered also. After the 2GB of RAM (6GB + 2GB) was
> added to the server the script listed below was applied to
> the server.
> We have three other servers that have the same
> configuration and SQL Server Memory Manager (Target Server
> Memory) is set correctly at 5.12GB. But when you run
> Performance Monitor and display SQL Server Memory Manager
> (Target Server Memory) it is set to 2.7GB
> I replied the script listed below but it did not change
> the SQL Server Memory Manager (Target Server Memory) value.
> Please help me with this problem.
> Thanks,
> Mike
>
> sp_configure "show advanced options", 1
> RECONFIGURE
> GO
> sp_configure "awe enabled", 1
> RECONFIGURE
> GO
> sp_configure "max server memory", 5120
> RECONFIGURE
> GO
> sp_configure "min server memory", 0
> RECONFIGURE
> GO
>
>
> Do you have AWE enabled in SQL?
> Are you running Enterprise Edition SQL?
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> "Mike" <anonymous@.discussions.microsoft.com> wrote in
> message
> news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> >
> > Why does'nt my Target Server Memory value (2.7 GB) within
> > Memory Manager in the Performance Monitor Counters match
> > the values in SQL Server Memory Maximum Value (5.2 GB)
> >
> > My Target Server Memory displays a value of 2.7 GB and
> the
> > SQL Memory Maximum displays 5.2 GB.
> >
> > The boot.ini is set with the following parameters:
> > [boot loader]
> > timeout=10
> > default=multi(0)disk(0)rdisk(0)partition(1)\WINNT
> > [operating systems]
> > multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft
> > Windows 2000 Advanced Server" /fastdetect /3gb /PAE
> >
> > The server initially had 6GB of RAM and 2GB were added to
> > the server. SQL Server displays 5.2 GB is the maximum
> alot
> > memory and Dynamically configure SQL Server memory.
> >
> > How can I fix the memory problem.
> >
> > Thanks,
> >
> > Mike
> >
>
> .
>|||The Total Server Memory counter value?
8,125,736 KB of RAM
Thank You,
Mike
>--Original Message--
>What is the Total Server Memory counter value?
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
>news:94e101c43372$1237ed80$a001280a@.phx.gbl...
>> Yes, we have AWE set to 1 and max server memory set to
>> 5120. Yes, this is a SQL Server 2000 Enterprise Edition
>> with Windows 2000 Advanced Server. SQL Server is
>> clustered also. After the 2GB of RAM (6GB + 2GB) was
>> added to the server the script listed below was applied
to
>> the server.
>> We have three other servers that have the same
>> configuration and SQL Server Memory Manager (Target
Server
>> Memory) is set correctly at 5.12GB. But when you run
>> Performance Monitor and display SQL Server Memory
Manager
>> (Target Server Memory) it is set to 2.7GB
>> I replied the script listed below but it did not change
>> the SQL Server Memory Manager (Target Server Memory)
value.
>> Please help me with this problem.
>> Thanks,
>> Mike
>>
>> sp_configure "show advanced options", 1
>> RECONFIGURE
>> GO
>> sp_configure "awe enabled", 1
>> RECONFIGURE
>> GO
>> sp_configure "max server memory", 5120
>> RECONFIGURE
>> GO
>> sp_configure "min server memory", 0
>> RECONFIGURE
>> GO
>>
>>
>> Do you have AWE enabled in SQL?
>> Are you running Enterprise Edition SQL?
>> --
>> Geoff N. Hiten
>> Microsoft SQL Server MVP
>> Senior Database Administrator
>> Careerbuilder.com
>> "Mike" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
>> >
>> > Why does'nt my Target Server Memory value (2.7 GB)
within
>> > Memory Manager in the Performance Monitor Counters
match
>> > the values in SQL Server Memory Maximum Value (5.2 GB)
>> >
>> > My Target Server Memory displays a value of 2.7 GB and
>> the
>> > SQL Memory Maximum displays 5.2 GB.
>> >
>> > The boot.ini is set with the following parameters:
>> > [boot loader]
>> > timeout=10
>> > default=multi(0)disk(0)rdisk(0)partition(1)\WINNT
>> > [operating systems]
>> > multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft
>> > Windows 2000 Advanced Server" /fastdetect /3gb /PAE
>> >
>> > The server initially had 6GB of RAM and 2GB were
added to
>> > the server. SQL Server displays 5.2 GB is the maximum
>> alot
>> > memory and Dynamically configure SQL Server memory.
>> >
>> > How can I fix the memory problem.
>> >
>> > Thanks,
>> >
>> > Mike
>> >
>>
>> .
>>
>
>.
>

(Target Server Memory)Perf. Monitor Counters

Yes, we have AWE set to 1 and max server memory set to
5120. Yes, this is a SQL Server 2000 Enterprise Edition
with Windows 2000 Advanced Server. SQL Server is
clustered also. After the 2GB of RAM (6GB + 2GB) was
added to the server the script listed below was applied to
the server.
We have three other servers that have the same
configuration and SQL Server Memory Manager (Target Server
Memory) is set correctly at 5.12GB. But when you run
Performance Monitor and display SQL Server Memory Manager
(Target Server Memory) it is set to 2.7GB
I replied the script listed below but it did not change
the SQL Server Memory Manager (Target Server Memory) value.
Please help me with this problem.
Thanks,
Mike
sp_configure "show advanced options", 1
RECONFIGURE
GO
sp_configure "awe enabled", 1
RECONFIGURE
GO
sp_configure "max server memory", 5120
RECONFIGURE
GO
sp_configure "min server memory", 0
RECONFIGURE
GO
Do you have AWE enabled in SQL?
Are you running Enterprise Edition SQL?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> Why does'nt my Target Server Memory value (2.7 GB) within
> Memory Manager in the Performance Monitor Counters match
> the values in SQL Server Memory Maximum Value (5.2 GB)
> My Target Server Memory displays a value of 2.7 GB and
the
> SQL Memory Maximum displays 5.2 GB.
> The boot.ini is set with the following parameters:
> [boot loader]
> timeout=10
> default=multi(0)disk(0)rdisk(0)partition
(1)\WINNT
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINN
T="Microsoft
> Windows 2000 Advanced Server" /fastdetect /3gb /PAE
> The server initially had 6GB of RAM and 2GB were added to
> the server. SQL Server displays 5.2 GB is the maximum
alot
> memory and Dynamically configure SQL Server memory.
> How can I fix the memory problem.
> Thanks,
> Mike
>
.What is the Total Server Memory counter value?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:94e101c43372$1237ed80$a001280a@.phx.gbl...
> Yes, we have AWE set to 1 and max server memory set to
> 5120. Yes, this is a SQL Server 2000 Enterprise Edition
> with Windows 2000 Advanced Server. SQL Server is
> clustered also. After the 2GB of RAM (6GB + 2GB) was
> added to the server the script listed below was applied to
> the server.
> We have three other servers that have the same
> configuration and SQL Server Memory Manager (Target Server
> Memory) is set correctly at 5.12GB. But when you run
> Performance Monitor and display SQL Server Memory Manager
> (Target Server Memory) it is set to 2.7GB
> I replied the script listed below but it did not change
> the SQL Server Memory Manager (Target Server Memory) value.
> Please help me with this problem.
> Thanks,
> Mike
>
> sp_configure "show advanced options", 1
> RECONFIGURE
> GO
> sp_configure "awe enabled", 1
> RECONFIGURE
> GO
> sp_configure "max server memory", 5120
> RECONFIGURE
> GO
> sp_configure "min server memory", 0
> RECONFIGURE
> GO
>
>
> Do you have AWE enabled in SQL?
> Are you running Enterprise Edition SQL?
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> "Mike" <anonymous@.discussions.microsoft.com> wrote in
> message
> news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> the
> alot
>
> .
>|||The Total Server Memory counter value?
8,125,736 KB of RAM
Thank You,
Mike

>--Original Message--
>What is the Total Server Memory counter value?
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
>news:94e101c43372$1237ed80$a001280a@.phx.gbl...
to[vbcol=seagreen]
Server[vbcol=seagreen]
Manager[vbcol=seagreen]
value.[vbcol=seagreen]
within[vbcol=seagreen]
match[vbcol=seagreen]
added to[vbcol=seagreen]
>
>.
>