Database Auto Shrink

I have unattached and taken some databases from an Enterprise version of SQL
and attached them onto a Personal Edition laptop. Although I have deselected
the auto shrink option, on a daily basis it reappears, shrinks my files and
my data import crashes.
So my quesiton is =
Is there a way to disable autoshrink on the Personal edition or do I need to
rebuild the laptops on NT Server.
Many Thanks,
RichieBHi
Right click on the database and click on Properties. Under Tbal Options
uncheck AutoShrink option.
"RichieB" <RichieB@.discussions.microsoft.com> wrote in message
news:F3BFBD6F-910A-4A91-BC0C-80E34B1B1A3A@.microsoft.com...
>I have unattached and taken some databases from an Enterprise version of
>SQL
> and attached them onto a Personal Edition laptop. Although I have
> deselected
> the auto shrink option, on a daily basis it reappears, shrinks my files
> and
> my data import crashes.
> So my quesiton is =
> Is there a way to disable autoshrink on the Personal edition or do I need
> to
> rebuild the laptops on NT Server.
> Many Thanks,
> RichieB

Database Auto Shrink

I have unattached and taken some databases from an Enterprise version of SQL
and attached them onto a Personal Edition laptop. Although I have deselected
the auto shrink option, on a daily basis it reappears, shrinks my files and
my data import crashes.
So my quesiton is =
Is there a way to disable autoshrink on the Personal edition or do I need to
rebuild the laptops on NT Server.
Many Thanks,
RichieB
Hi
Right click on the database and click on Properties. Under Tbal Options
uncheck AutoShrink option.
"RichieB" <RichieB@.discussions.microsoft.com> wrote in message
news:F3BFBD6F-910A-4A91-BC0C-80E34B1B1A3A@.microsoft.com...
>I have unattached and taken some databases from an Enterprise version of
>SQL
> and attached them onto a Personal Edition laptop. Although I have
> deselected
> the auto shrink option, on a daily basis it reappears, shrinks my files
> and
> my data import crashes.
> So my quesiton is =
> Is there a way to disable autoshrink on the Personal edition or do I need
> to
> rebuild the laptops on NT Server.
> Many Thanks,
> RichieB

Database Auto Shrink

I have unattached and taken some databases from an Enterprise version of SQL
and attached them onto a Personal Edition laptop. Although I have deselected
the auto shrink option, on a daily basis it reappears, shrinks my files and
my data import crashes.
So my quesiton is =
Is there a way to disable autoshrink on the Personal edition or do I need to
rebuild the laptops on NT Server.
Many Thanks,
RichieBHi
Right click on the database and click on Properties. Under Tbal Options
uncheck AutoShrink option.
"RichieB" <RichieB@.discussions.microsoft.com> wrote in message
news:F3BFBD6F-910A-4A91-BC0C-80E34B1B1A3A@.microsoft.com...
>I have unattached and taken some databases from an Enterprise version of
>SQL
> and attached them onto a Personal Edition laptop. Although I have
> deselected
> the auto shrink option, on a daily basis it reappears, shrinks my files
> and
> my data import crashes.
> So my quesiton is => Is there a way to disable autoshrink on the Personal edition or do I need
> to
> rebuild the laptops on NT Server.
> Many Thanks,
> RichieB

Database at 9.0.3152 but SSMS at 9.0.3042 - Problem?

I've got a SQL 2K5 installation that I have upgraded to 9.0.3152. In SSMS, I see the SQL Server instance showing with the correct version - 9.0.3152. But SSMS (Help->About) shows a version of 9.00.3042. Is this expected or should "Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available" (http://support.microsoft.com/default.aspx/kb/933097/) have upgraded all these to 3152, as well?

Thanks!

Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790

There are several ways to check the version level of various components. The easiest seems to be by using Add/Remove Programs. Click on your SQL entry, then uninstall, and then Change. This pops up a nice report showing your machine at the component level and the associated versions. If SSMS is at 3042, you can apply hotfix 3152 and bring it up to date. My guess is that SSMS might not show the hotfix level (only the SP level) and that your box is updated already.

Thanks,

Sam Lester (MSFT)

|||

Really it may not be the easiest way for remote server.

Iа I were you (or if you were I), I would have preferred

SERVERPROPERTY function.

SELECT SERVERPROPERTY('productversion') AS ProductVersion,

SERVERPROPERTY ('ResourceVersion') As ResourceVersion ,

SERVERPROPERTY ('productlevel') AS ProductLevel,

SERVERPROPERTY ('edition') As Edition,

SERVERPROPERTY ('ResourceLastUpdateDateTime') As ResourceLastUpdateDateTime

Shows for me
ProductVersion ResourceVersion ProductLevel Edition ResourceLastUpdateDateTime
9.00.3054.00 9.00.3042 SP2 Developer Edition 2007-02-10 00:39:35.480

Database at 9.0.3152 but SSMS at 9.0.3042 - Problem?

I've got a SQL 2K5 installation that I have upgraded to 9.0.3152. In SSMS, I see the SQL Server instance showing with the correct version - 9.0.3152. But SSMS (Help->About) shows a version of 9.00.3042. Is this expected or should "Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available" (http://support.microsoft.com/default.aspx/kb/933097/) have upgraded all these to 3152, as well?

Thanks!

Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790

There are several ways to check the version level of various components. The easiest seems to be by using Add/Remove Programs. Click on your SQL entry, then uninstall, and then Change. This pops up a nice report showing your machine at the component level and the associated versions. If SSMS is at 3042, you can apply hotfix 3152 and bring it up to date. My guess is that SSMS might not show the hotfix level (only the SP level) and that your box is updated already.

Thanks,

Sam Lester (MSFT)

|||

Really it may not be the easiest way for remote server.

Iа I were you (or if you were I), I would have preferred

SERVERPROPERTY function.

SELECT SERVERPROPERTY('productversion') AS ProductVersion,

SERVERPROPERTY ('ResourceVersion') As ResourceVersion ,

SERVERPROPERTY ('productlevel') AS ProductLevel,

SERVERPROPERTY ('edition') As Edition,

SERVERPROPERTY ('ResourceLastUpdateDateTime') As ResourceLastUpdateDateTime

Shows for me
ProductVersion ResourceVersion ProductLevel Edition ResourceLastUpdateDateTime
9.00.3054.00 9.00.3042 SP2 Developer Edition 2007-02-10 00:39:35.480

Data/records in other languages

Hi,

Can the English version of Sql Server (or other DBMSs) store data/records in
other languages (e.g. French, Chinese, etc.) or
do you have to use the French version of Sql Server to store French data?

Where can I go to read more on this?

Thanks.
Eric"Eric" <ericd_@.hotmail.com> wrote in message news:<Gpjjb.3561$Z_2.317631@.news20.bellglobal.com>...
> Hi,
> Can the English version of Sql Server (or other DBMSs) store data/records in
> other languages (e.g. French, Chinese, etc.) or
> do you have to use the French version of Sql Server to store French data?
> Where can I go to read more on this?
> Thanks.
> Eric

You can use Unicode data types (nchar, nvarchar, ntext) to store
Unicode data, and it doesn't matter what language your version of
MSSQL is. You can get more information in Books Online in the sections
on "Using Unicode Data" and "Collations".

Simon

Data Tuning Advisor

Is Data Tuning Advisor available for any Express version?

--Thanks

No, DTA is not part of the Express offering.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.