Attach DB > 2 GB

I understand that there is a 2GB limit in MSDE so that
databases can't be created or expanded past 2GB. However,
if the database has come from SQL Server 2000 and is over
2GB (15GB)and is for reference only, is it possible to use
within MSDE?
Thanks for your help.
Hi Jake,
I haven't tried it but have heard from others that it will attach. However,
they had a variety of problems later. Wouldn't recommend it except to
perhaps extract some data.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jake Levington" <anonymous@.discussions.microsoft.com> wrote in message
news:1fda01c47d34$abde4ae0$a301280a@.phx.gbl...
> I understand that there is a 2GB limit in MSDE so that
> databases can't be created or expanded past 2GB. However,
> if the database has come from SQL Server 2000 and is over
> 2GB (15GB)and is for reference only, is it possible to use
> within MSDE?
> Thanks for your help.
|||Or use SQLExpress which has a 4GB limit.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:%23J9cnfTfEHA.632@.TK2MSFTNGP12.phx.gbl...
> Hi Jake,
> I haven't tried it but have heard from others that it will attach.
However,
> they had a variety of problems later. Wouldn't recommend it except to
> perhaps extract some data.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Jake Levington" <anonymous@.discussions.microsoft.com> wrote in message
> news:1fda01c47d34$abde4ae0$a301280a@.phx.gbl...
>

Attach Database Basic Question

When one of our clients tries to attach a database (about 6GB in size)
she gets a message saying file size limit exceeded. She is using Sql
Server 2000. Is there a limitation on size for Sql Server 2000? I know
for MSDE the size can not be more than 2GB. Can you shed any light on
the issue please?Strange, and is there enough space on the file system for the database?
"S Chapman" <s_chapman47@.hotmail.co.uk> wrote in message
news:1147856960.608383.244690@.i39g2000cwa.googlegroups.com...
>
> When one of our clients tries to attach a database (about 6GB in size)
> she gets a message saying file size limit exceeded. She is using Sql
> Server 2000. Is there a limitation on size for Sql Server 2000? I know
> for MSDE the size can not be more than 2GB. Can you shed any light on
> the issue please?
>|||Sounds like your client is using MSDE or SQL Server which has limit of data
storage for a database
(2 vs 4 GB).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"S Chapman" <s_chapman47@.hotmail.co.uk> wrote in message
news:1147856960.608383.244690@.i39g2000cwa.googlegroups.com...
>
> When one of our clients tries to attach a database (about 6GB in size)
> she gets a message saying file size limit exceeded. She is using Sql
> Server 2000. Is there a limitation on size for Sql Server 2000? I know
> for MSDE the size can not be more than 2GB. Can you shed any light on
> the issue please?
>

Assign expression value using code

I am trying to use a variable to set an attribute value of an SSIS task but I keep running into the 4000 character limit of the string variable. Not sure why the variable which is of .NET type String has this limit when it doesn't when you are in a .NET environment. Regardless, can anyone provide some sample code that I could use to do this in a script task? I am trying to set the QueryString property of the Data Mining Query Task. All help would be appreciated.

Thank you in advance.

Variables and expressions in SSIS are limited to 4000 bytes. Sorry.|||As far as dynamically setting the QueryString, when you look at the properties of the Data Mining Query task, is there an "expressions" parameter? If you expand the expressions parameter, do you have an option for QueryString? (I'm not sitting in front of SSIS at the moment, so I can't verify.) If so, you may want to put your variable there instead of using a script.|||

All task properties support expressions, it is only Data Flow components that require the developer to actually set some code that says an expression is supported.

The problem is that the result of an expression cannot be greater than 4000 characters. Using a variable whose value is greater than 4000 characters will not work because this still has to pass through the expression evaluator to be assigned to the property value.

Since the DM Query Task does not offer anything other than a literal string for the query, this cannot be set dynamically within the package. I think this is a limitation, obviously it would be nice to have expressions with > 4000 characters but also tasks should be (consistently) developed with properties such as this accepting literals, variables and files. An ideal example is the Execute SQL Task with the SourceSQLType property that describes the interpretation of the SQL Statement property.

|||That is too bad. Hopefully this will change in a later version. Thanks for the help.