how can i reduce the size of the database?

I am using SQL server 2000 and its size is increasing like a crazy.. is there any way to reduce the size by deleting any temp data or logs?

Have a look at the database files, which one are gwoing extremly, the data files or the log files ? if the logfiles are getting bigger you should consider shrking them from time to time.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

What is growing, your data files or your transaction log file? Are you running in Full Recovery mode and not doing transaction log backups?

If your data files are growing, you can try defragmenting or rebuilding your indexes. If you have a lot of index fragmentation, this can free up a lot of space. You can also try shrinking your data and log files like this:

DBCC SHRINKFILE (N'YourFileName_dat' , 0, TRUNCATEONLY)

http://glennberrysqlperformance.spaces.live.com

|||

Read the below mentioned links... You need to change your backup policy... take the transaction log backup regularly... Do not shirnk database just like that... every database requires some extra space for daily activities... Yes you can shrink Transaction log provided the first action after the shrinking should be Full Backup of your database. Which you truncate and shrink the Transaction Log the Backup chain breaks... so be aware that you should take full backup as soon as possible...

How to use the DBCC SHRINKFILE statement to shrink the transaction log file in SQL Server 2005
http://support.microsoft.com/kb/907511

How to stop the transaction log of a SQL Server database from growing unexpectedly
http://support.microsoft.com/kb/873235

http://support.microsoft.com/kb/907511

How to stop the transaction log of a SQL Server database from growing unexpectedly
http://support.microsoft.com/kb/873235

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19637

Madhu

|||

review ur backup policy...truncate transactional logs when u take a full backup....

i wont recommend -- regular -- shrinking of data files...its only goin to make it slower and wont be of significant help mostly...

how can i reduce the size of the database?

I am using SQL server 2000 and its size is increasing like a crazy.. is there any way to reduce the size by deleting any temp data or logs?

Have a look at the database files, which one are gwoing extremly, the data files or the log files ? if the logfiles are getting bigger you should consider shrking them from time to time.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

What is growing, your data files or your transaction log file? Are you running in Full Recovery mode and not doing transaction log backups?

If your data files are growing, you can try defragmenting or rebuilding your indexes. If you have a lot of index fragmentation, this can free up a lot of space. You can also try shrinking your data and log files like this:

DBCC SHRINKFILE (N'YourFileName_dat' , 0, TRUNCATEONLY)

http://glennberrysqlperformance.spaces.live.com

|||

Read the below mentioned links... You need to change your backup policy... take the transaction log backup regularly... Do not shirnk database just like that... every database requires some extra space for daily activities... Yes you can shrink Transaction log provided the first action after the shrinking should be Full Backup of your database. Which you truncate and shrink the Transaction Log the Backup chain breaks... so be aware that you should take full backup as soon as possible...

How to use the DBCC SHRINKFILE statement to shrink the transaction log file in SQL Server 2005
http://support.microsoft.com/kb/907511

How to stop the transaction log of a SQL Server database from growing unexpectedly
http://support.microsoft.com/kb/873235

http://support.microsoft.com/kb/907511

How to stop the transaction log of a SQL Server database from growing unexpectedly
http://support.microsoft.com/kb/873235

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19637

Madhu

|||

review ur backup policy...truncate transactional logs when u take a full backup....

i wont recommend -- regular -- shrinking of data files...its only goin to make it slower and wont be of significant help mostly...

sql

how can i reduce the size of the database?

I am using SQL server 2000 and its size is increasing like a crazy.. is there any way to reduce the size by deleting any temp data or logs?

Have a look at the database files, which one are gwoing extremly, the data files or the log files ? if the logfiles are getting bigger you should consider shrking them from time to time.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

What is growing, your data files or your transaction log file? Are you running in Full Recovery mode and not doing transaction log backups?

If your data files are growing, you can try defragmenting or rebuilding your indexes. If you have a lot of index fragmentation, this can free up a lot of space. You can also try shrinking your data and log files like this:

DBCC SHRINKFILE (N'YourFileName_dat' , 0, TRUNCATEONLY)

http://glennberrysqlperformance.spaces.live.com

|||

Read the below mentioned links... You need to change your backup policy... take the transaction log backup regularly... Do not shirnk database just like that... every database requires some extra space for daily activities... Yes you can shrink Transaction log provided the first action after the shrinking should be Full Backup of your database. Which you truncate and shrink the Transaction Log the Backup chain breaks... so be aware that you should take full backup as soon as possible...

How to use the DBCC SHRINKFILE statement to shrink the transaction log file in SQL Server 2005
http://support.microsoft.com/kb/907511

How to stop the transaction log of a SQL Server database from growing unexpectedly
http://support.microsoft.com/kb/873235

http://support.microsoft.com/kb/907511

How to stop the transaction log of a SQL Server database from growing unexpectedly
http://support.microsoft.com/kb/873235

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19637

Madhu

|||

review ur backup policy...truncate transactional logs when u take a full backup....

i wont recommend -- regular -- shrinking of data files...its only goin to make it slower and wont be of significant help mostly...

How can I pre-allocate file size of TempDB in SQL 2000?

Hello:
We reboot our production server on Mondays. I would like to pre-allocate
(set original) file size for TempDB to a reasonable size to avoid frequent
expand of this DB. How can I achieve that? I couldn't find any setting in
the Enterprise Manager to allow me to pre-allocate file size of TempDB.
What SQL command will I use then?
Thank you in advance for your help.
Chai
Chai,
See "alter database" in BOL.
AMB
"Chai" wrote:

> Hello:
> We reboot our production server on Mondays. I would like to pre-allocate
> (set original) file size for TempDB to a reasonable size to avoid frequent
> expand of this DB. How can I achieve that? I couldn't find any setting in
> the Enterprise Manager to allow me to pre-allocate file size of TempDB.
> What SQL command will I use then?
> Thank you in advance for your help.
>
> Chai
>
>
|||Hi Chai
You can use ALTER DATABASE, similar to the following:
alter database tempdb
modify file
( NAME = tempdev,
SIZE = 10 MB)
You can run sp_helpdb to verify the name of the data file for tempdb, the
default is tempdev. You might also want to change the initial log size.
Note that you cannot set a file size with ALTER that is smaller than the
current size. So if you want the new size to be smaller that it is
currently, you will have to restart one more time and issue the alter before
tempdb gets too big.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Chai" <chai@.trs.state.il.us> wrote in message
news:uXt%238gAjHHA.208@.TK2MSFTNGP05.phx.gbl...
> Hello:
> We reboot our production server on Mondays. I would like to pre-allocate
> (set original) file size for TempDB to a reasonable size to avoid frequent
> expand of this DB. How can I achieve that? I couldn't find any setting
> in the Enterprise Manager to allow me to pre-allocate file size of TempDB.
> What SQL command will I use then?
> Thank you in advance for your help.
>
> Chai
>
sql

How can I pre-allocate file size of TempDB in SQL 2000?

Hello:
We reboot our production server on Mondays. I would like to pre-allocate
(set original) file size for TempDB to a reasonable size to avoid frequent
expand of this DB. How can I achieve that? I couldn't find any setting in
the Enterprise Manager to allow me to pre-allocate file size of TempDB.
What SQL command will I use then?
Thank you in advance for your help.
ChaiChai,
See "alter database" in BOL.
AMB
"Chai" wrote:

> Hello:
> We reboot our production server on Mondays. I would like to pre-allocate
> (set original) file size for TempDB to a reasonable size to avoid frequent
> expand of this DB. How can I achieve that? I couldn't find any setting i
n
> the Enterprise Manager to allow me to pre-allocate file size of TempDB.
> What SQL command will I use then?
> Thank you in advance for your help.
>
> Chai
>
>|||Hi Chai
You can use ALTER DATABASE, similar to the following:
alter database tempdb
modify file
( NAME = tempdev,
SIZE = 10 MB)
You can run sp_helpdb to verify the name of the data file for tempdb, the
default is tempdev. You might also want to change the initial log size.
Note that you cannot set a file size with ALTER that is smaller than the
current size. So if you want the new size to be smaller that it is
currently, you will have to restart one more time and issue the alter before
tempdb gets too big.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Chai" <chai@.trs.state.il.us> wrote in message
news:uXt%238gAjHHA.208@.TK2MSFTNGP05.phx.gbl...
> Hello:
> We reboot our production server on Mondays. I would like to pre-allocate
> (set original) file size for TempDB to a reasonable size to avoid frequent
> expand of this DB. How can I achieve that? I couldn't find any setting
> in the Enterprise Manager to allow me to pre-allocate file size of TempDB.
> What SQL command will I use then?
> Thank you in advance for your help.
>
> Chai
>

How can I pre-allocate file size of TempDB in SQL 2000?

Hello:
We reboot our production server on Mondays. I would like to pre-allocate
(set original) file size for TempDB to a reasonable size to avoid frequent
expand of this DB. How can I achieve that? I couldn't find any setting in
the Enterprise Manager to allow me to pre-allocate file size of TempDB.
What SQL command will I use then?
Thank you in advance for your help.
ChaiChai,
See "alter database" in BOL.
AMB
"Chai" wrote:
> Hello:
> We reboot our production server on Mondays. I would like to pre-allocate
> (set original) file size for TempDB to a reasonable size to avoid frequent
> expand of this DB. How can I achieve that? I couldn't find any setting in
> the Enterprise Manager to allow me to pre-allocate file size of TempDB.
> What SQL command will I use then?
> Thank you in advance for your help.
>
> Chai
>
>|||Hi Chai
You can use ALTER DATABASE, similar to the following:
alter database tempdb
modify file
( NAME = tempdev,
SIZE = 10 MB)
You can run sp_helpdb to verify the name of the data file for tempdb, the
default is tempdev. You might also want to change the initial log size.
Note that you cannot set a file size with ALTER that is smaller than the
current size. So if you want the new size to be smaller that it is
currently, you will have to restart one more time and issue the alter before
tempdb gets too big.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Chai" <chai@.trs.state.il.us> wrote in message
news:uXt%238gAjHHA.208@.TK2MSFTNGP05.phx.gbl...
> Hello:
> We reboot our production server on Mondays. I would like to pre-allocate
> (set original) file size for TempDB to a reasonable size to avoid frequent
> expand of this DB. How can I achieve that? I couldn't find any setting
> in the Enterprise Manager to allow me to pre-allocate file size of TempDB.
> What SQL command will I use then?
> Thank you in advance for your help.
>
> Chai
>

How can I make tempdb to its original size?

Hi, everybody!
I installed MS SQL Server 2000, and add two files to tempdb.
And now I want to make tempdb to its original size by removing two files
which had beed added.
How can I do it?http://www.support.microsoft.com/?id=307487
Andrew J. Kelly
SQL Server MVP
"Kim Keuk Tae" <zyuuzika@.korea.com> wrote in message
news:uF0WdC1cDHA.2572@.TK2MSFTNGP11.phx.gbl...
>
> Hi, everybody!
> I installed MS SQL Server 2000, and add two files to tempdb.
> And now I want to make tempdb to its original size by removing two files
> which had beed added.
> How can I do it?
>
>

How Can I Look Up Database Log

In either SQL 2000 or SQL 2005.
we can set both Data and Log file's position or initial size or
autogrowth.
I know data are stored in the Data File.
but how do I know what are stored in the Log file?
so
what are stored in the log file in SQL Server's database?
Thanks
Benny wrote:

> In either SQL 2000 or SQL 2005.
> we can set both Data and Log file's position or initial size or
> autogrowth.
> I know data are stored in the Data File.
> but how do I know what are stored in the Log file?
> so
> what are stored in the log file in SQL Server's database?
> Thanks
http://sqlserver2000.databases.aspfaq.com/how-do-i-recover-data-from-sql-server-s-log-files.html
Regards
Amish Shah
|||There are some ways out of the box that can reveal info:
select * from ::fn_dblog(null,null)
dbcc log(Pub1, type=4)
However to get hold of the actual TSQL statements you'll need a 3rd-party
tool eg Lumigent Log Explorer
(http://www.lumigent.com/products/le_sql.html). BTW it's true that you could
use transactional replication and sp_browsereplcmds as a means of achieving
this aim without buying a 3rd-party tool, but it's unlikely anyone would
want the unnecessary overhead to go down this route, and the info obtained
is more limited than using Log Explorer.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

How Can I Look Up Database Log

In either SQL 2000 or SQL 2005.
we can set both Data and Log file's position or initial size or
autogrowth.
I know data are stored in the Data File.
but how do I know what are stored in the Log file?
so
what are stored in the log file in SQL Server's database?
ThanksBenny wrote:

> In either SQL 2000 or SQL 2005.
> we can set both Data and Log file's position or initial size or
> autogrowth.
> I know data are stored in the Data File.
> but how do I know what are stored in the Log file?
> so
> what are stored in the log file in SQL Server's database?
> Thanks
http://sqlserver2000.databases.aspf...
log-files.html
Regards
Amish Shah|||There are some ways out of the box that can reveal info:
select * from ::fn_dblog(null,null)
dbcc log(Pub1, type=4)
However to get hold of the actual TSQL statements you'll need a 3rd-party
tool eg Lumigent Log Explorer
(http://www.lumigent.com/products/le_sql.html). BTW it's true that you could
use transactional replication and sp_browsereplcmds as a means of achieving
this aim without buying a 3rd-party tool, but it's unlikely anyone would
want the unnecessary overhead to go down this route, and the info obtained
is more limited than using Log Explorer.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

How Can I Look Up Database Log

In either SQL 2000 or SQL 2005.
we can set both Data and Log file's position or initial size or
autogrowth.
I know data are stored in the Data File.
but how do I know what are stored in the Log file?
so
what are stored in the log file in SQL Server's database?
ThanksBenny wrote:
> In either SQL 2000 or SQL 2005.
> we can set both Data and Log file's position or initial size or
> autogrowth.
> I know data are stored in the Data File.
> but how do I know what are stored in the Log file?
> so
> what are stored in the log file in SQL Server's database?
> Thanks
http://sqlserver2000.databases.aspfaq.com/how-do-i-recover-data-from-sql-server-s-log-files.html
Regards
Amish Shah|||There are some ways out of the box that can reveal info:
select * from ::fn_dblog(null,null)
dbcc log(Pub1, type=4)
However to get hold of the actual TSQL statements you'll need a 3rd-party
tool eg Lumigent Log Explorer
(http://www.lumigent.com/products/le_sql.html). BTW it's true that you could
use transactional replication and sp_browsereplcmds as a means of achieving
this aim without buying a 3rd-party tool, but it's unlikely anyone would
want the unnecessary overhead to go down this route, and the info obtained
is more limited than using Log Explorer.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

How can I know the records in SQL 2005 Table possess size space?

We can know easily a database disk size, but can we konw a table in SQL 2005 database possess size? and more, how can I know the records in SQL 2005 Table possess size space?

Try the link below for sp_helpfile it is a system stored procedure and it is in the Master database. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms174307.aspx

|||

Thanks!

But I think Sp_helpfile don't know single Table or Records size

sp_helpfile (Transact-SQL)

Returns the physical names and attributes of files associated with the current database. Use this stored procedure to determine the names of files to attach to or detach from the server.

|||

Sorry it is sp_spaceused and there are undocumented system stored proc that you can use. Try the links below for details.

http://www.sqlservercentral.com/columnists/achigrik/sql2000.asp

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1062

http://msdn2.microsoft.com/en-us/library/ms188776.aspx

|||

Many thanks!

How can I know rows used space ? Such as I want to know the user Paul used space

select * from mytable where UserName='Paul'

|||Paul spaced used? Paul plus tables associated to Paul because sp_spaceused is for database objects like tables not users.|||

Sorry!

When system perform the sql select * from mytable where UserName='Paul' , it will return many rows , iI want to know these rows use size space.

|||

I am sorry I cannot help you the space used that concerns my employers are to make sure the transaction log will not run out of space, but I know the max for a row is 8060 which is also a SQL Server page. Try the thread below for the specs per Microsoft.

http://forums.asp.net/thread/1398414.aspx

|||

ok just open enterprise manager select the database then in the summary window just click report then expand disk space used by tables and you should get the info you're looking for as per table.

Have fun!

How can I know the data logical file name?

Hi, all
How can i know the the data file .mdf logical file name?
I want to use alter database to modify the file's size.
Thanks!Execute sp_helpfile in the database.
-Sue
On Tue, 19 Aug 2003 16:29:34 -0700, "Hawk"
<abchawk@.hotmail.com> wrote:
>Hi, all
>How can i know the the data file .mdf logical file name?
>I want to use alter database to modify the file's size.
>Thanks!
>|||or
select * from sysfiles
>--Original Message--
>Hi, all
>How can i know the the data file .mdf logical file name?
>I want to use alter database to modify the file's size.
>Thanks!
>
>.
>

How can I know a user table's size?

I want to check a user table's size, Maybe 20M or more?
what can i do ,pls kindly help me
Regards
Grantexec sp_spaceused ThisTable, @.updateusage = TRUE
Roy Harvey
Beacon Falls, CT
On Wed, 26 Apr 2006 19:41:02 -0700, Grant
<Grant@.discussions.microsoft.com> wrote:

>I want to check a user table's size, Maybe 20M or more?
>what can i do ,pls kindly help me
>
>Regards
>Grant|||try this (untested)
EXEC sp_spaceused [table1]
"Grant" wrote:

> I want to check a user table's size, Maybe 20M or more?
> what can i do ,pls kindly help me
>
> Regards
> Grant
>

How can I get the table size

Hi, everyone
Could you please tell me how to get the size of a table(including data) in
SQL Sever 2000?have a look in BOL for sp_spaceused, eg
USE pubs
EXEC sp_spaceused 'titles'
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)|||but how can reclaim the unused table size ?

How can I get the table size

Hi, everyone
Could you please tell me how to get the size of a table(including data) in
SQL Sever 2000?
have a look in BOL for sp_spaceused, eg
USE pubs
EXEC sp_spaceused 'titles'
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||but how can reclaim the unused table size ?

How can I get the table size

Hi, everyone
Could you please tell me how to get the size of a table(including data) in
SQL Sever 2000?have a look in BOL for sp_spaceused, eg
USE pubs
EXEC sp_spaceused 'titles'
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)|||but how can reclaim the unused table size ?

How can I find the allocated size of an index?

I ran sp_statistics on a table and the indexes were displayed along with the
SIZE of the table, but the index SIZE's are NULL. I ran statistics on the
table and the indexes SIZE's remained NULL. So what's the trick to obtain the
size of an indexe's allocation?
Thanks
Michael
Snake wrote:
> I ran sp_statistics on a table and the indexes were displayed along
> with the SIZE of the table, but the index SIZE's are NULL. I ran
> statistics on the table and the indexes SIZE's remained NULL. So
> what's the trick to obtain the size of an indexe's allocation?
> Thanks
> Michael
See "Estimating the Size of a Table with a Clustered Index" in BOL for
all required calculations.
David Gugick
Imceda Software
www.imceda.com
|||Try using sp_MSindexspace. It's not documented but it's reasonably simple.
It will give the size on nonclustered indexes.
"Snake" <Snake@.discussions.microsoft.com> wrote in message
news:FA336D35-BB8C-4172-8AA7-919DFC96759A@.microsoft.com...
>I ran sp_statistics on a table and the indexes were displayed along with
>the
> SIZE of the table, but the index SIZE's are NULL. I ran statistics on the
> table and the indexes SIZE's remained NULL. So what's the trick to obtain
> the
> size of an indexe's allocation?
> Thanks
> Michael
|||Thanks Danny!
"DANNY SCROGGINS" wrote:

> Try using sp_MSindexspace. It's not documented but it's reasonably simple.
> It will give the size on nonclustered indexes.
>
> "Snake" <Snake@.discussions.microsoft.com> wrote in message
> news:FA336D35-BB8C-4172-8AA7-919DFC96759A@.microsoft.com...
>
>

How can I find the allocated size of an index?

I ran sp_statistics on a table and the indexes were displayed along with the
SIZE of the table, but the index SIZE's are NULL. I ran statistics on the
table and the indexes SIZE's remained NULL. So what's the trick to obtain the
size of an indexe's allocation?
Thanks
MichaelSnake wrote:
> I ran sp_statistics on a table and the indexes were displayed along
> with the SIZE of the table, but the index SIZE's are NULL. I ran
> statistics on the table and the indexes SIZE's remained NULL. So
> what's the trick to obtain the size of an indexe's allocation?
> Thanks
> Michael
See "Estimating the Size of a Table with a Clustered Index" in BOL for
all required calculations.
--
David Gugick
Imceda Software
www.imceda.com|||Try using sp_MSindexspace. It's not documented but it's reasonably simple.
It will give the size on nonclustered indexes.
"Snake" <Snake@.discussions.microsoft.com> wrote in message
news:FA336D35-BB8C-4172-8AA7-919DFC96759A@.microsoft.com...
>I ran sp_statistics on a table and the indexes were displayed along with
>the
> SIZE of the table, but the index SIZE's are NULL. I ran statistics on the
> table and the indexes SIZE's remained NULL. So what's the trick to obtain
> the
> size of an indexe's allocation?
> Thanks
> Michael|||Thanks Danny!
"DANNY SCROGGINS" wrote:
> Try using sp_MSindexspace. It's not documented but it's reasonably simple.
> It will give the size on nonclustered indexes.
>
> "Snake" <Snake@.discussions.microsoft.com> wrote in message
> news:FA336D35-BB8C-4172-8AA7-919DFC96759A@.microsoft.com...
> >I ran sp_statistics on a table and the indexes were displayed along with
> >the
> > SIZE of the table, but the index SIZE's are NULL. I ran statistics on the
> > table and the indexes SIZE's remained NULL. So what's the trick to obtain
> > the
> > size of an indexe's allocation?
> >
> > Thanks
> >
> > Michael
>
>

How can I find the allocated size of an index?

I ran sp_statistics on a table and the indexes were displayed along with the
SIZE of the table, but the index SIZE's are NULL. I ran statistics on the
table and the indexes SIZE's remained NULL. So what's the trick to obtain th
e
size of an indexe's allocation?
Thanks
MichaelSnake wrote:
> I ran sp_statistics on a table and the indexes were displayed along
> with the SIZE of the table, but the index SIZE's are NULL. I ran
> statistics on the table and the indexes SIZE's remained NULL. So
> what's the trick to obtain the size of an indexe's allocation?
> Thanks
> Michael
See "Estimating the Size of a Table with a Clustered Index" in BOL for
all required calculations.
David Gugick
Imceda Software
www.imceda.com|||Try using sp_MSindexspace. It's not documented but it's reasonably simple.
It will give the size on nonclustered indexes.
"Snake" <Snake@.discussions.microsoft.com> wrote in message
news:FA336D35-BB8C-4172-8AA7-919DFC96759A@.microsoft.com...
>I ran sp_statistics on a table and the indexes were displayed along with
>the
> SIZE of the table, but the index SIZE's are NULL. I ran statistics on the
> table and the indexes SIZE's remained NULL. So what's the trick to obtain
> the
> size of an indexe's allocation?
> Thanks
> Michael|||Thanks Danny!
"DANNY SCROGGINS" wrote:

> Try using sp_MSindexspace. It's not documented but it's reasonably simple
.
> It will give the size on nonclustered indexes.
>
> "Snake" <Snake@.discussions.microsoft.com> wrote in message
> news:FA336D35-BB8C-4172-8AA7-919DFC96759A@.microsoft.com...
>
>