Can the data viewers display Chinese characters?

Is there a way to change the font that the data viewer uses, so that the Chinese characters don't appear as boxes?

The data viewer displays Chinese characters as boxes, something similar to [_], at least on a computer with the following regional settings.

get-wmiobject CIM_OperatingSystem | ft OSLanguage, CodeSet, Locale

OSLanguage CodeSet Locale

- -

1033 1252 0409

The data itself is flowing correctly into the target database with a pipeline data_type of DT_WSTR. The ideograms can be seen by query utilities which supports a unicode font (e.g. Management Studio).

Yes, follow
Tools > Options > Environment > Fonts and Colors, then
select Show settings for: Business Intelligence Data Viewers.
Now select the font you want to use.|||Thanks a lot Michael, works great.

Can the data viewers display Chinese characters?

Is there a way to change the font that the data viewer uses, so that the Chinese characters don't appear as boxes?

The data viewer displays Chinese characters as boxes, something similar to [_], at least on a computer with the following regional settings.

get-wmiobject CIM_OperatingSystem | ft OSLanguage, CodeSet, Locale

OSLanguage CodeSet Locale

- -

1033 1252 0409

The data itself is flowing correctly into the target database with a pipeline data_type of DT_WSTR. The ideograms can be seen by query utilities which supports a unicode font (e.g. Management Studio).

Yes, follow
Tools > Options > Environment > Fonts and Colors, then
select Show settings for: Business Intelligence Data Viewers.
Now select the font you want to use.|||Thanks a lot Michael, works great.

can tables themselves be fragmented? Index ID 0?

When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
fragmented for index ID 0. I'm assuming this is the table itself? If so,
what do I do about it? I can't enter this ID into DBCC INDEXDEFRAG. All of
my indexes with ID's 1 and on up appear to be fine, it's just these ID 0's
that look bad.
thanks,
CoryIndex ID of 0 means that the table is a heap. In other words the table does
not have a clustered index. The only way to remove fragmentation is to
create a clustered index on that table or to export all the data, truncate
it and import it all back in again. Index ID of 1 is always the clustered
index. You will never have both only one or the other.
Andrew J. Kelly SQL MVP
"Cory Harrison" <charrison@.csiweb.com> wrote in message
news:OtXCgFJ9GHA.3384@.TK2MSFTNGP05.phx.gbl...
> When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
> fragmented for index ID 0. I'm assuming this is the table itself? If so,
> what do I do about it? I can't enter this ID into DBCC INDEXDEFRAG. All
> of my indexes with ID's 1 and on up appear to be fine, it's just these ID
> 0's that look bad.
>
> thanks,
> Cory
>
>|||Hey Andy, I'm wondering how exporting & re-importing the data helps? Doesn't
simply creating a clustered index & then dropping the clustered index
provide an effective defrag of the heap?
Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23E5p6yJ9GHA.3736@.TK2MSFTNGP02.phx.gbl...
> Index ID of 0 means that the table is a heap. In other words the table
> does not have a clustered index. The only way to remove fragmentation is
> to create a clustered index on that table or to export all the data,
> truncate it and import it all back in again. Index ID of 1 is always the
> clustered index. You will never have both only one or the other.
> --
> Andrew J. Kelly SQL MVP
> "Cory Harrison" <charrison@.csiweb.com> wrote in message
> news:OtXCgFJ9GHA.3384@.TK2MSFTNGP05.phx.gbl...
>|||In addition, it is worth explaining what you mean by fragmentation.
When the physical order doesn't match the logical order is one type of fragm
entation this is
impossible for the datapages of a heap table (index 0) as there is no order.
This is also known as
external fragmentation.
Another is then you have lots of free spaces on the pages and extents that t
he heap/index is using.
This is also known as internal fragmentation.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23E5p6yJ9GHA.3736@.TK2MSFTNGP02.phx.gbl...
> Index ID of 0 means that the table is a heap. In other words the table doe
s not have a clustered
> index. The only way to remove fragmentation is to create a clustered index
on that table or to
> export all the data, truncate it and import it all back in again. Index I
D of 1 is always the
> clustered index. You will never have both only one or the other.
> --
> Andrew J. Kelly SQL MVP
> "Cory Harrison" <charrison@.csiweb.com> wrote in message
> news:OtXCgFJ9GHA.3384@.TK2MSFTNGP05.phx.gbl...
>

can tables themselves be fragmented? Index ID 0?

When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
fragmented for index ID 0. I'm assuming this is the table itself? If so,
what do I do about it? I can't enter this ID into DBCC INDEXDEFRAG. All of
my indexes with ID's 1 and on up appear to be fine, it's just these ID 0's
that look bad.
thanks,
Cory> When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
> fragmented for index ID 0.
Judging by what value? See my other post. There's no order for rows in a hea
p, so scan density etc.
are meaningless for a heap.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Cory Harrison" <charrison@.csiweb.com> wrote in message
news:%23NBNJIr9GHA.3344@.TK2MSFTNGP03.phx.gbl...
> When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
> fragmented for index ID 0. I'm assuming this is the table itself? If so,
> what do I do about it? I can't enter this ID into DBCC INDEXDEFRAG. All
of
> my indexes with ID's 1 and on up appear to be fine, it's just these ID 0's
> that look bad.
>
> thanks,
> Cory
>
>
>|||Hi Cory,
These tables to which you refer are heap tables, those that do not have a
clustered index defined on them. The data pages for heaps are not stored in
any particular order, which would explain why the fragmentation values are
high. Consider creating an appropriate clustered index on these tables if
you want to reduce the observed fragmentation.
Kind Regards
Andrew Pike
--
SQL Server DBA
UBS IB
"Cory Harrison" wrote:

> When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
> fragmented for index ID 0. I'm assuming this is the table itself? If so,
> what do I do about it? I can't enter this ID into DBCC INDEXDEFRAG. All
of
> my indexes with ID's 1 and on up appear to be fine, it's just these ID 0's
> that look bad.
>
> thanks,
> Cory
>
>
>

can tables themselves be fragmented? Index ID 0?

When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
fragmented for index ID 0. I'm assuming this is the table itself? If so,
what do I do about it? I can't enter this ID into DBCC INDEXDEFRAG. All of
my indexes with ID's 1 and on up appear to be fine, it's just these ID 0's
that look bad.
thanks,
Cory
Index ID of 0 means that the table is a heap. In other words the table does
not have a clustered index. The only way to remove fragmentation is to
create a clustered index on that table or to export all the data, truncate
it and import it all back in again. Index ID of 1 is always the clustered
index. You will never have both only one or the other.
Andrew J. Kelly SQL MVP
"Cory Harrison" <charrison@.csiweb.com> wrote in message
news:OtXCgFJ9GHA.3384@.TK2MSFTNGP05.phx.gbl...
> When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
> fragmented for index ID 0. I'm assuming this is the table itself? If so,
> what do I do about it? I can't enter this ID into DBCC INDEXDEFRAG. All
> of my indexes with ID's 1 and on up appear to be fine, it's just these ID
> 0's that look bad.
>
> thanks,
> Cory
>
>
|||Hey Andy, I'm wondering how exporting & re-importing the data helps? Doesn't
simply creating a clustered index & then dropping the clustered index
provide an effective defrag of the heap?
Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23E5p6yJ9GHA.3736@.TK2MSFTNGP02.phx.gbl...
> Index ID of 0 means that the table is a heap. In other words the table
> does not have a clustered index. The only way to remove fragmentation is
> to create a clustered index on that table or to export all the data,
> truncate it and import it all back in again. Index ID of 1 is always the
> clustered index. You will never have both only one or the other.
> --
> Andrew J. Kelly SQL MVP
> "Cory Harrison" <charrison@.csiweb.com> wrote in message
> news:OtXCgFJ9GHA.3384@.TK2MSFTNGP05.phx.gbl...
>
|||In addition, it is worth explaining what you mean by fragmentation.
When the physical order doesn't match the logical order is one type of fragmentation this is
impossible for the datapages of a heap table (index 0) as there is no order. This is also known as
external fragmentation.
Another is then you have lots of free spaces on the pages and extents that the heap/index is using.
This is also known as internal fragmentation.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23E5p6yJ9GHA.3736@.TK2MSFTNGP02.phx.gbl...
> Index ID of 0 means that the table is a heap. In other words the table does not have a clustered
> index. The only way to remove fragmentation is to create a clustered index on that table or to
> export all the data, truncate it and import it all back in again. Index ID of 1 is always the
> clustered index. You will never have both only one or the other.
> --
> Andrew J. Kelly SQL MVP
> "Cory Harrison" <charrison@.csiweb.com> wrote in message
> news:OtXCgFJ9GHA.3384@.TK2MSFTNGP05.phx.gbl...
>

can tables themselves be fragmented? Index ID 0?

When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
fragmented for index ID 0. I'm assuming this is the table itself? If so,
what do I do about it? I can't enter this ID into DBCC INDEXDEFRAG. All of
my indexes with ID's 1 and on up appear to be fine, it's just these ID 0's
that look bad.
thanks,
Cory
> When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
> fragmented for index ID 0.
Judging by what value? See my other post. There's no order for rows in a heap, so scan density etc.
are meaningless for a heap.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Cory Harrison" <charrison@.csiweb.com> wrote in message
news:%23NBNJIr9GHA.3344@.TK2MSFTNGP03.phx.gbl...
> When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
> fragmented for index ID 0. I'm assuming this is the table itself? If so,
> what do I do about it? I can't enter this ID into DBCC INDEXDEFRAG. All of
> my indexes with ID's 1 and on up appear to be fine, it's just these ID 0's
> that look bad.
>
> thanks,
> Cory
>
>
>
|||Hi Cory,
These tables to which you refer are heap tables, those that do not have a
clustered index defined on them. The data pages for heaps are not stored in
any particular order, which would explain why the fragmentation values are
high. Consider creating an appropriate clustered index on these tables if
you want to reduce the observed fragmentation.
Kind Regards
Andrew Pike
SQL Server DBA
UBS IB
"Cory Harrison" wrote:

> When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
> fragmented for index ID 0. I'm assuming this is the table itself? If so,
> what do I do about it? I can't enter this ID into DBCC INDEXDEFRAG. All of
> my indexes with ID's 1 and on up appear to be fine, it's just these ID 0's
> that look bad.
>
> thanks,
> Cory
>
>
>

can tables themselves be fragmented? Index ID 0?

When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
fragmented for index ID 0. I'm assuming this is the table itself? If so,
what do I do about it? I can't enter this ID into DBCC INDEXDEFRAG. All of
my indexes with ID's 1 and on up appear to be fine, it's just these ID 0's
that look bad.
thanks,
CoryIndex ID of 0 means that the table is a heap. In other words the table does
not have a clustered index. The only way to remove fragmentation is to
create a clustered index on that table or to export all the data, truncate
it and import it all back in again. Index ID of 1 is always the clustered
index. You will never have both only one or the other.
--
Andrew J. Kelly SQL MVP
"Cory Harrison" <charrison@.csiweb.com> wrote in message
news:OtXCgFJ9GHA.3384@.TK2MSFTNGP05.phx.gbl...
> When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
> fragmented for index ID 0. I'm assuming this is the table itself? If so,
> what do I do about it? I can't enter this ID into DBCC INDEXDEFRAG. All
> of my indexes with ID's 1 and on up appear to be fine, it's just these ID
> 0's that look bad.
>
> thanks,
> Cory
>
>|||Hey Andy, I'm wondering how exporting & re-importing the data helps? Doesn't
simply creating a clustered index & then dropping the clustered index
provide an effective defrag of the heap?
Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23E5p6yJ9GHA.3736@.TK2MSFTNGP02.phx.gbl...
> Index ID of 0 means that the table is a heap. In other words the table
> does not have a clustered index. The only way to remove fragmentation is
> to create a clustered index on that table or to export all the data,
> truncate it and import it all back in again. Index ID of 1 is always the
> clustered index. You will never have both only one or the other.
> --
> Andrew J. Kelly SQL MVP
> "Cory Harrison" <charrison@.csiweb.com> wrote in message
> news:OtXCgFJ9GHA.3384@.TK2MSFTNGP05.phx.gbl...
>> When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
>> fragmented for index ID 0. I'm assuming this is the table itself? If
>> so, what do I do about it? I can't enter this ID into DBCC INDEXDEFRAG.
>> All of my indexes with ID's 1 and on up appear to be fine, it's just
>> these ID 0's that look bad.
>>
>> thanks,
>> Cory
>>
>|||In addition, it is worth explaining what you mean by fragmentation.
When the physical order doesn't match the logical order is one type of fragmentation this is
impossible for the datapages of a heap table (index 0) as there is no order. This is also known as
external fragmentation.
Another is then you have lots of free spaces on the pages and extents that the heap/index is using.
This is also known as internal fragmentation.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23E5p6yJ9GHA.3736@.TK2MSFTNGP02.phx.gbl...
> Index ID of 0 means that the table is a heap. In other words the table does not have a clustered
> index. The only way to remove fragmentation is to create a clustered index on that table or to
> export all the data, truncate it and import it all back in again. Index ID of 1 is always the
> clustered index. You will never have both only one or the other.
> --
> Andrew J. Kelly SQL MVP
> "Cory Harrison" <charrison@.csiweb.com> wrote in message
> news:OtXCgFJ9GHA.3384@.TK2MSFTNGP05.phx.gbl...
>> When I run DBCC SHOWCONTIG I see several tables who appear to be horribly fragmented for index ID
>> 0. I'm assuming this is the table itself? If so, what do I do about it? I can't enter this ID
>> into DBCC INDEXDEFRAG. All of my indexes with ID's 1 and on up appear to be fine, it's just
>> these ID 0's that look bad.
>>
>> thanks,
>> Cory
>>
>|||The idea would be that you would export with a select that had an order by.
Then once you truncate the table and import it back in you will not have any
forwarding pointers, gaps in the pages etc. The data may not be in physical
order like you would have at the leaf node of a clustered or non-clustered
index but it should be decent when thru. How long it stays that way is a
different story:). That process does not guarantee lack of fragmentation
from a data ordering standpoint but it will clean up the gaps, forwarding
pointers and if there is enough contiguous room in the data files it will be
mostly contiguous as well.
--
Andrew J. Kelly SQL MVP
"Greg Linwood" <g_linwood@.hotmail.com> wrote in message
news:uRIghjN9GHA.4632@.TK2MSFTNGP02.phx.gbl...
> Hey Andy, I'm wondering how exporting & re-importing the data helps?
> Doesn't simply creating a clustered index & then dropping the clustered
> index provide an effective defrag of the heap?
> Regards,
> Greg Linwood
> SQL Server MVP
> http://blogs.sqlserver.org.au/blogs/greg_linwood
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23E5p6yJ9GHA.3736@.TK2MSFTNGP02.phx.gbl...
>> Index ID of 0 means that the table is a heap. In other words the table
>> does not have a clustered index. The only way to remove fragmentation is
>> to create a clustered index on that table or to export all the data,
>> truncate it and import it all back in again. Index ID of 1 is always the
>> clustered index. You will never have both only one or the other.
>> --
>> Andrew J. Kelly SQL MVP
>> "Cory Harrison" <charrison@.csiweb.com> wrote in message
>> news:OtXCgFJ9GHA.3384@.TK2MSFTNGP05.phx.gbl...
>> When I run DBCC SHOWCONTIG I see several tables who appear to be
>> horribly fragmented for index ID 0. I'm assuming this is the table
>> itself? If so, what do I do about it? I can't enter this ID into DBCC
>> INDEXDEFRAG. All of my indexes with ID's 1 and on up appear to be fine,
>> it's just these ID 0's that look bad.
>>
>> thanks,
>> Cory
>>
>>
>

can tables themselves be fragmented? Index ID 0?

When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
fragmented for index ID 0. I'm assuming this is the table itself? If so,
what do I do about it? I can't enter this ID into DBCC INDEXDEFRAG. All of
my indexes with ID's 1 and on up appear to be fine, it's just these ID 0's
that look bad.
thanks,
Cory> When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
> fragmented for index ID 0.
Judging by what value? See my other post. There's no order for rows in a heap, so scan density etc.
are meaningless for a heap.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Cory Harrison" <charrison@.csiweb.com> wrote in message
news:%23NBNJIr9GHA.3344@.TK2MSFTNGP03.phx.gbl...
> When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
> fragmented for index ID 0. I'm assuming this is the table itself? If so,
> what do I do about it? I can't enter this ID into DBCC INDEXDEFRAG. All of
> my indexes with ID's 1 and on up appear to be fine, it's just these ID 0's
> that look bad.
>
> thanks,
> Cory
>
>
>|||Hi Cory,
These tables to which you refer are heap tables, those that do not have a
clustered index defined on them. The data pages for heaps are not stored in
any particular order, which would explain why the fragmentation values are
high. Consider creating an appropriate clustered index on these tables if
you want to reduce the observed fragmentation.
Kind Regards
Andrew Pike
--
SQL Server DBA
UBS IB
"Cory Harrison" wrote:
> When I run DBCC SHOWCONTIG I see several tables who appear to be horribly
> fragmented for index ID 0. I'm assuming this is the table itself? If so,
> what do I do about it? I can't enter this ID into DBCC INDEXDEFRAG. All of
> my indexes with ID's 1 and on up appear to be fine, it's just these ID 0's
> that look bad.
>
> thanks,
> Cory
>
>
>

Can SQL2KEE use 4GB on x64?

I thought I saw someone mention that SQL2KEE can access a full 4GB on x64.
Can someone verify this? Here are 2 links that appear to support this.
http://msdn.microsoft.com/library/de...onsumption.asp
http://msdn.microsoft.com/library/de...management.asp
Running 32-bit version of sqlserver does you no good. See this document for
details.
http://download.microsoft.com/downlo...Advantages.doc
-oj
"Mike Kruchten" <mrk@.fsisolutions.com> wrote in message
news:uyO2zO1eFHA.3836@.tk2msftngp13.phx.gbl...
>I thought I saw someone mention that SQL2KEE can access a full 4GB on x64.
>Can someone verify this? Here are 2 links that appear to support this.
> http://msdn.microsoft.com/library/de...onsumption.asp
> http://msdn.microsoft.com/library/de...management.asp
>
|||Well, being from March 2004 this document doesn't say anything about running
32-bit SQL2000 on x64 W2k3. The following quote from one of the links I
provided leads me to believe that SQL2000EE running in this environment will
be able to use a full 4GB of virtual memory.
On the x64 processor, each 32-bit application receives 4 GB virtual address
space in the WOW64 environment, if the application has the
IMAGE_FILE_LARGE_ADDRESS_AWARE flag set in the image header. If this flag is
not set, the 32-bit application receives 2 GB virtual address space.
"oj" <nospam_ojngo@.home.com> wrote in message
news:u7XB3Q6eFHA.3932@.TK2MSFTNGP12.phx.gbl...
> Running 32-bit version of sqlserver does you no good. See this document
> for details.
> http://download.microsoft.com/downlo...Advantages.doc
>
> --
> -oj
>
>
|||You're right. SQL2K (32bit) SP4 allows you to run it in WOW64. Though, I am
not sure if you can actually use up 4Gb. If you have windbg, you can try to
look it up *live* - don't have a x64 here else I would check it out for
sure.
-oj
"Mike Kruchten" <mrk@.fsisolutions.com> wrote in message
news:ukcPvG%23eFHA.1456@.TK2MSFTNGP15.phx.gbl...
> Well, being from March 2004 this document doesn't say anything about
> running 32-bit SQL2000 on x64 W2k3. The following quote from one of the
> links I provided leads me to believe that SQL2000EE running in this
> environment will be able to use a full 4GB of virtual memory.
>
> On the x64 processor, each 32-bit application receives 4 GB virtual
> address space in the WOW64 environment, if the application has the
> IMAGE_FILE_LARGE_ADDRESS_AWARE flag set in the image header. If this flag
> is not set, the 32-bit application receives 2 GB virtual address space.
>
>
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:u7XB3Q6eFHA.3932@.TK2MSFTNGP12.phx.gbl...
>
|||Is there any official work on this yet?
Daren
"Mike Kruchten" <mrk@.fsisolutions.com> wrote in message
news:uyO2zO1eFHA.3836@.tk2msftngp13.phx.gbl...
> I thought I saw someone mention that SQL2KEE can access a full 4GB on x64.
> Can someone verify this? Here are 2 links that appear to support this.
>
http://msdn.microsoft.com/library/de...onsumption.asp
>
http://msdn.microsoft.com/library/de...management.asp
>

Can SQL2KEE use 4GB on x64?

I thought I saw someone mention that SQL2KEE can access a full 4GB on x64.
Can someone verify this? Here are 2 links that appear to support this.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/win64/win64/performance_and_memory_consumption.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/win64/win64/memory_management.aspRunning 32-bit version of sqlserver does you no good. See this document for
details.
http://download.microsoft.com/download/0/4/7/047da8d3-aa80-452a-9148-40a7e8a7048a/SQL64bitAdvantages.doc
-oj
"Mike Kruchten" <mrk@.fsisolutions.com> wrote in message
news:uyO2zO1eFHA.3836@.tk2msftngp13.phx.gbl...
>I thought I saw someone mention that SQL2KEE can access a full 4GB on x64.
>Can someone verify this? Here are 2 links that appear to support this.
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/win64/win64/performance_and_memory_consumption.asp
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/win64/win64/memory_management.asp
>|||Well, being from March 2004 this document doesn't say anything about running
32-bit SQL2000 on x64 W2k3. The following quote from one of the links I
provided leads me to believe that SQL2000EE running in this environment will
be able to use a full 4GB of virtual memory.
---
On the x64 processor, each 32-bit application receives 4 GB virtual address
space in the WOW64 environment, if the application has the
IMAGE_FILE_LARGE_ADDRESS_AWARE flag set in the image header. If this flag is
not set, the 32-bit application receives 2 GB virtual address space.
"oj" <nospam_ojngo@.home.com> wrote in message
news:u7XB3Q6eFHA.3932@.TK2MSFTNGP12.phx.gbl...
> Running 32-bit version of sqlserver does you no good. See this document
> for details.
> http://download.microsoft.com/download/0/4/7/047da8d3-aa80-452a-9148-40a7e8a7048a/SQL64bitAdvantages.doc
>
> --
> -oj
>
>|||You're right. SQL2K (32bit) SP4 allows you to run it in WOW64. Though, I am
not sure if you can actually use up 4Gb. If you have windbg, you can try to
look it up *live* - don't have a x64 here else I would check it out for
sure.
--
-oj
"Mike Kruchten" <mrk@.fsisolutions.com> wrote in message
news:ukcPvG%23eFHA.1456@.TK2MSFTNGP15.phx.gbl...
> Well, being from March 2004 this document doesn't say anything about
> running 32-bit SQL2000 on x64 W2k3. The following quote from one of the
> links I provided leads me to believe that SQL2000EE running in this
> environment will be able to use a full 4GB of virtual memory.
>
> ---
> On the x64 processor, each 32-bit application receives 4 GB virtual
> address space in the WOW64 environment, if the application has the
> IMAGE_FILE_LARGE_ADDRESS_AWARE flag set in the image header. If this flag
> is not set, the 32-bit application receives 2 GB virtual address space.
>
>
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:u7XB3Q6eFHA.3932@.TK2MSFTNGP12.phx.gbl...
>> Running 32-bit version of sqlserver does you no good. See this document
>> for details.
>> http://download.microsoft.com/download/0/4/7/047da8d3-aa80-452a-9148-40a7e8a7048a/SQL64bitAdvantages.doc
>>
>> --
>> -oj
>>
>|||Is there any official work on this yet?
Daren
"Mike Kruchten" <mrk@.fsisolutions.com> wrote in message
news:uyO2zO1eFHA.3836@.tk2msftngp13.phx.gbl...
> I thought I saw someone mention that SQL2KEE can access a full 4GB on x64.
> Can someone verify this? Here are 2 links that appear to support this.
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/win64/win64/performance_and_memory_consumption.asp
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/win64/win64/memory_management.asp
>

Can SQL2KEE use 4GB on x64?

I thought I saw someone mention that SQL2KEE can access a full 4GB on x64.
Can someone verify this? Here are 2 links that appear to support this.
http://msdn.microsoft.com/library/d...consumption.asp
http://msdn.microsoft.com/library/d..._management.aspRunning 32-bit version of sqlserver does you no good. See this document for
details.
http://download.microsoft.com/downl...tAdvantages.doc
-oj
"Mike Kruchten" <mrk@.fsisolutions.com> wrote in message
news:uyO2zO1eFHA.3836@.tk2msftngp13.phx.gbl...
>I thought I saw someone mention that SQL2KEE can access a full 4GB on x64.
>Can someone verify this? Here are 2 links that appear to support this.
> http://msdn.microsoft.com/library/d...consumption.asp
> http://msdn.microsoft.com/library/d..._management.asp
>|||Well, being from March 2004 this document doesn't say anything about running
32-bit SQL2000 on x64 W2k3. The following quote from one of the links I
provided leads me to believe that SQL2000EE running in this environment will
be able to use a full 4GB of virtual memory.
---
On the x64 processor, each 32-bit application receives 4 GB virtual address
space in the WOW64 environment, if the application has the
IMAGE_FILE_LARGE_ADDRESS_AWARE flag set in the image header. If this flag is
not set, the 32-bit application receives 2 GB virtual address space.
"oj" <nospam_ojngo@.home.com> wrote in message
news:u7XB3Q6eFHA.3932@.TK2MSFTNGP12.phx.gbl...
> Running 32-bit version of sqlserver does you no good. See this document
> for details.
> http://download.microsoft.com/downl...tAdvantages.doc
>
> --
> -oj
>
>|||You're right. SQL2K (32bit) SP4 allows you to run it in WOW64. Though, I am
not sure if you can actually use up 4Gb. If you have windbg, you can try to
look it up *live* - don't have a x64 here else I would check it out for
sure.
-oj
"Mike Kruchten" <mrk@.fsisolutions.com> wrote in message
news:ukcPvG%23eFHA.1456@.TK2MSFTNGP15.phx.gbl...
> Well, being from March 2004 this document doesn't say anything about
> running 32-bit SQL2000 on x64 W2k3. The following quote from one of the
> links I provided leads me to believe that SQL2000EE running in this
> environment will be able to use a full 4GB of virtual memory.
>
> ---
> On the x64 processor, each 32-bit application receives 4 GB virtual
> address space in the WOW64 environment, if the application has the
> IMAGE_FILE_LARGE_ADDRESS_AWARE flag set in the image header. If this flag
> is not set, the 32-bit application receives 2 GB virtual address space.
>
>
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:u7XB3Q6eFHA.3932@.TK2MSFTNGP12.phx.gbl...
>|||Is there any official work on this yet?
Daren
"Mike Kruchten" <mrk@.fsisolutions.com> wrote in message
news:uyO2zO1eFHA.3836@.tk2msftngp13.phx.gbl...
> I thought I saw someone mention that SQL2KEE can access a full 4GB on x64.
> Can someone verify this? Here are 2 links that appear to support this.
>
http://msdn.microsoft.com/library/d...consumption.asp
>
http://msdn.microsoft.com/library/d...ent.asp

>

Can SQL 2005 Backup to a different file name each night?

In SQL 2000, I could use the DB Maint Wizard to create a backup that created
a new backup file each night. This basic feature does not appear to be an
option in SQL 2005. Is there some workaround? Anyone know if this will be
part of SP01?
I have hundreds of systems that have 4 5GB databases where we do full
backups every night. I do NOT want to append the previous nights backup to
the existing file, and I do NOT want to overwrite last nights backup because
I don't want to be without a backup if tonight's backup fails.
All suggestions are welcome, but I need a very simple way to set this up on
hundreds of systems by non-computer literate people.
Rob Kraft
Never mind group. I cannot recreate the problem I had. Originally in
testing, all of the backups were appending to the same date/time stamped
filename. I set up a new plan and it seems to work as desired - creating a
new file each time the backup runs. I have to manually add a cleanup task
to the DB Maint Plan created by the wizard to delete old DB files, but I've
got that figured out too.
Rob Kraft
"Rob Kraft" <robkraft@.msn.com> wrote in message
news:%23nhHf4%23VGHA.3284@.TK2MSFTNGP09.phx.gbl...
> In SQL 2000, I could use the DB Maint Wizard to create a backup that
> created a new backup file each night. This basic feature does not appear
> to be an option in SQL 2005. Is there some workaround? Anyone know if
> this will be part of SP01?
> I have hundreds of systems that have 4 5GB databases where we do full
> backups every night. I do NOT want to append the previous nights backup
> to the existing file, and I do NOT want to overwrite last nights backup
> because I don't want to be without a backup if tonight's backup fails.
> All suggestions are welcome, but I need a very simple way to set this up
> on hundreds of systems by non-computer literate people.
> Rob Kraft
>
|||Rob,
How do you add the delete of the oldest file? I cannot seem to manage this
so far.
Thanks
Chris Wood
"Rob Kraft" <robkraft@.msn.com> wrote in message
news:e4R3FI$VGHA.4328@.TK2MSFTNGP12.phx.gbl...
> Never mind group. I cannot recreate the problem I had. Originally in
> testing, all of the backups were appending to the same date/time stamped
> filename. I set up a new plan and it seems to work as desired - creating
> a new file each time the backup runs. I have to manually add a cleanup
> task to the DB Maint Plan created by the wizard to delete old DB files,
> but I've got that figured out too.
> Rob Kraft
> "Rob Kraft" <robkraft@.msn.com> wrote in message
> news:%23nhHf4%23VGHA.3284@.TK2MSFTNGP09.phx.gbl...
>
|||Chris, I could not do this using the Maintenance Plan Wizard. Instead, after
creating the plan, right-click on the plan and select Modify. Then, on the
left hand side (probably) -drag a "Maintenance Cleanup Task" from the
Toolbox window into your plan (make sure you do NOT grab the "History
Cleanup Task"). Right-click on the "Maintenance Cleanup Task" and select
Edit. They you can specify to delete files in a specific folder that are
older than a n Weeks (or n Days). (and you can specify to delete files with
just a specific extension such as bak). Close that window then click on the
"Maintenance Cleanup Task" in the maintence plan and click and drag the
green arrow that appears down to the "Back Up Database Task" you just
created to cause the "Back Up Database Task" to execute after the file
delete.
Technically, I don't see a way using these tools to delete "the oldest
file"; but you can delete "all files over n days old".
Rob Kraft
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:exAKTW$VGHA.5076@.TK2MSFTNGP14.phx.gbl...
> Rob,
> How do you add the delete of the oldest file? I cannot seem to manage this
> so far.
> Thanks
> Chris Wood
> "Rob Kraft" <robkraft@.msn.com> wrote in message
> news:e4R3FI$VGHA.4328@.TK2MSFTNGP12.phx.gbl...
>
|||Thank you Rob.
Works like a treat. Another 2005 nuance out of the way.
Chris
"Rob Kraft" <robkraft@.msn.com> wrote in message
news:e7ziF2XWGHA.1564@.TK2MSFTNGP03.phx.gbl...
> Chris, I could not do this using the Maintenance Plan Wizard. Instead,
> after creating the plan, right-click on the plan and select Modify. Then,
> on the left hand side (probably) -drag a "Maintenance Cleanup Task" from
> the Toolbox window into your plan (make sure you do NOT grab the "History
> Cleanup Task"). Right-click on the "Maintenance Cleanup Task" and select
> Edit. They you can specify to delete files in a specific folder that are
> older than a n Weeks (or n Days). (and you can specify to delete files
> with just a specific extension such as bak). Close that window then click
> on the "Maintenance Cleanup Task" in the maintence plan and click and drag
> the green arrow that appears down to the "Back Up Database Task" you just
> created to cause the "Back Up Database Task" to execute after the file
> delete.
> Technically, I don't see a way using these tools to delete "the oldest
> file"; but you can delete "all files over n days old".
> Rob Kraft
>
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:exAKTW$VGHA.5076@.TK2MSFTNGP14.phx.gbl...
>

Can SQL 2005 Backup to a different file name each night?

In SQL 2000, I could use the DB Maint Wizard to create a backup that created
a new backup file each night. This basic feature does not appear to be an
option in SQL 2005. Is there some workaround? Anyone know if this will be
part of SP01?
I have hundreds of systems that have 4 5GB databases where we do full
backups every night. I do NOT want to append the previous nights backup to
the existing file, and I do NOT want to overwrite last nights backup because
I don't want to be without a backup if tonight's backup fails.
All suggestions are welcome, but I need a very simple way to set this up on
hundreds of systems by non-computer literate people.
Rob KraftNever mind group. I cannot recreate the problem I had. Originally in
testing, all of the backups were appending to the same date/time stamped
filename. I set up a new plan and it seems to work as desired - creating a
new file each time the backup runs. I have to manually add a cleanup task
to the DB Maint Plan created by the wizard to delete old DB files, but I've
got that figured out too.
Rob Kraft
"Rob Kraft" <robkraft@.msn.com> wrote in message
news:%23nhHf4%23VGHA.3284@.TK2MSFTNGP09.phx.gbl...
> In SQL 2000, I could use the DB Maint Wizard to create a backup that
> created a new backup file each night. This basic feature does not appear
> to be an option in SQL 2005. Is there some workaround? Anyone know if
> this will be part of SP01?
> I have hundreds of systems that have 4 5GB databases where we do full
> backups every night. I do NOT want to append the previous nights backup
> to the existing file, and I do NOT want to overwrite last nights backup
> because I don't want to be without a backup if tonight's backup fails.
> All suggestions are welcome, but I need a very simple way to set this up
> on hundreds of systems by non-computer literate people.
> Rob Kraft
>|||Rob,
How do you add the delete of the oldest file? I cannot seem to manage this
so far.
Thanks
Chris Wood
"Rob Kraft" <robkraft@.msn.com> wrote in message
news:e4R3FI$VGHA.4328@.TK2MSFTNGP12.phx.gbl...
> Never mind group. I cannot recreate the problem I had. Originally in
> testing, all of the backups were appending to the same date/time stamped
> filename. I set up a new plan and it seems to work as desired - creating
> a new file each time the backup runs. I have to manually add a cleanup
> task to the DB Maint Plan created by the wizard to delete old DB files,
> but I've got that figured out too.
> Rob Kraft
> "Rob Kraft" <robkraft@.msn.com> wrote in message
> news:%23nhHf4%23VGHA.3284@.TK2MSFTNGP09.phx.gbl...
>> In SQL 2000, I could use the DB Maint Wizard to create a backup that
>> created a new backup file each night. This basic feature does not appear
>> to be an option in SQL 2005. Is there some workaround? Anyone know if
>> this will be part of SP01?
>> I have hundreds of systems that have 4 5GB databases where we do full
>> backups every night. I do NOT want to append the previous nights backup
>> to the existing file, and I do NOT want to overwrite last nights backup
>> because I don't want to be without a backup if tonight's backup fails.
>> All suggestions are welcome, but I need a very simple way to set this up
>> on hundreds of systems by non-computer literate people.
>> Rob Kraft
>|||Look at maintenance cleanup task in Management plan.
Regards
Amish Shah|||Chris, I could not do this using the Maintenance Plan Wizard. Instead, after
creating the plan, right-click on the plan and select Modify. Then, on the
left hand side (probably) -drag a "Maintenance Cleanup Task" from the
Toolbox window into your plan (make sure you do NOT grab the "History
Cleanup Task"). Right-click on the "Maintenance Cleanup Task" and select
Edit. They you can specify to delete files in a specific folder that are
older than a n Weeks (or n Days). (and you can specify to delete files with
just a specific extension such as bak). Close that window then click on the
"Maintenance Cleanup Task" in the maintence plan and click and drag the
green arrow that appears down to the "Back Up Database Task" you just
created to cause the "Back Up Database Task" to execute after the file
delete.
Technically, I don't see a way using these tools to delete "the oldest
file"; but you can delete "all files over n days old".
Rob Kraft
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:exAKTW$VGHA.5076@.TK2MSFTNGP14.phx.gbl...
> Rob,
> How do you add the delete of the oldest file? I cannot seem to manage this
> so far.
> Thanks
> Chris Wood
> "Rob Kraft" <robkraft@.msn.com> wrote in message
> news:e4R3FI$VGHA.4328@.TK2MSFTNGP12.phx.gbl...
>> Never mind group. I cannot recreate the problem I had. Originally in
>> testing, all of the backups were appending to the same date/time stamped
>> filename. I set up a new plan and it seems to work as desired - creating
>> a new file each time the backup runs. I have to manually add a cleanup
>> task to the DB Maint Plan created by the wizard to delete old DB files,
>> but I've got that figured out too.
>> Rob Kraft
>> "Rob Kraft" <robkraft@.msn.com> wrote in message
>> news:%23nhHf4%23VGHA.3284@.TK2MSFTNGP09.phx.gbl...
>> In SQL 2000, I could use the DB Maint Wizard to create a backup that
>> created a new backup file each night. This basic feature does not
>> appear to be an option in SQL 2005. Is there some workaround? Anyone
>> know if this will be part of SP01?
>> I have hundreds of systems that have 4 5GB databases where we do full
>> backups every night. I do NOT want to append the previous nights backup
>> to the existing file, and I do NOT want to overwrite last nights backup
>> because I don't want to be without a backup if tonight's backup fails.
>> All suggestions are welcome, but I need a very simple way to set this up
>> on hundreds of systems by non-computer literate people.
>> Rob Kraft
>>
>|||Thank you Rob.
Works like a treat. Another 2005 nuance out of the way.
Chris
"Rob Kraft" <robkraft@.msn.com> wrote in message
news:e7ziF2XWGHA.1564@.TK2MSFTNGP03.phx.gbl...
> Chris, I could not do this using the Maintenance Plan Wizard. Instead,
> after creating the plan, right-click on the plan and select Modify. Then,
> on the left hand side (probably) -drag a "Maintenance Cleanup Task" from
> the Toolbox window into your plan (make sure you do NOT grab the "History
> Cleanup Task"). Right-click on the "Maintenance Cleanup Task" and select
> Edit. They you can specify to delete files in a specific folder that are
> older than a n Weeks (or n Days). (and you can specify to delete files
> with just a specific extension such as bak). Close that window then click
> on the "Maintenance Cleanup Task" in the maintence plan and click and drag
> the green arrow that appears down to the "Back Up Database Task" you just
> created to cause the "Back Up Database Task" to execute after the file
> delete.
> Technically, I don't see a way using these tools to delete "the oldest
> file"; but you can delete "all files over n days old".
> Rob Kraft
>
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:exAKTW$VGHA.5076@.TK2MSFTNGP14.phx.gbl...
>> Rob,
>> How do you add the delete of the oldest file? I cannot seem to manage
>> this so far.
>> Thanks
>> Chris Wood
>> "Rob Kraft" <robkraft@.msn.com> wrote in message
>> news:e4R3FI$VGHA.4328@.TK2MSFTNGP12.phx.gbl...
>> Never mind group. I cannot recreate the problem I had. Originally in
>> testing, all of the backups were appending to the same date/time stamped
>> filename. I set up a new plan and it seems to work as desired -
>> creating a new file each time the backup runs. I have to manually add a
>> cleanup task to the DB Maint Plan created by the wizard to delete old DB
>> files, but I've got that figured out too.
>> Rob Kraft
>> "Rob Kraft" <robkraft@.msn.com> wrote in message
>> news:%23nhHf4%23VGHA.3284@.TK2MSFTNGP09.phx.gbl...
>> In SQL 2000, I could use the DB Maint Wizard to create a backup that
>> created a new backup file each night. This basic feature does not
>> appear to be an option in SQL 2005. Is there some workaround? Anyone
>> know if this will be part of SP01?
>> I have hundreds of systems that have 4 5GB databases where we do full
>> backups every night. I do NOT want to append the previous nights
>> backup to the existing file, and I do NOT want to overwrite last nights
>> backup because I don't want to be without a backup if tonight's backup
>> fails.
>> All suggestions are welcome, but I need a very simple way to set this
>> up on hundreds of systems by non-computer literate people.
>> Rob Kraft
>>
>>
>|||See also the discussion in thread
http://forums.microsoft.com/MSDN/ShowPost.aspx?postid=111810&siteid=1
"Chris Wood" wrote:
> Thank you Rob.
> Works like a treat. Another 2005 nuance out of the way.
> Chris
> "Rob Kraft" <robkraft@.msn.com> wrote in message
> news:e7ziF2XWGHA.1564@.TK2MSFTNGP03.phx.gbl...
> > Chris, I could not do this using the Maintenance Plan Wizard. Instead,
> > after creating the plan, right-click on the plan and select Modify. Then,
> > on the left hand side (probably) -drag a "Maintenance Cleanup Task" from
> > the Toolbox window into your plan (make sure you do NOT grab the "History
> > Cleanup Task"). Right-click on the "Maintenance Cleanup Task" and select
> > Edit. They you can specify to delete files in a specific folder that are
> > older than a n Weeks (or n Days). (and you can specify to delete files
> > with just a specific extension such as bak). Close that window then click
> > on the "Maintenance Cleanup Task" in the maintence plan and click and drag
> > the green arrow that appears down to the "Back Up Database Task" you just
> > created to cause the "Back Up Database Task" to execute after the file
> > delete.
> >
> > Technically, I don't see a way using these tools to delete "the oldest
> > file"; but you can delete "all files over n days old".
> >
> > Rob Kraft
> >
> >
> > "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> > news:exAKTW$VGHA.5076@.TK2MSFTNGP14.phx.gbl...
> >> Rob,
> >>
> >> How do you add the delete of the oldest file? I cannot seem to manage
> >> this so far.
> >>
> >> Thanks
> >>
> >> Chris Wood
> >>
> >> "Rob Kraft" <robkraft@.msn.com> wrote in message
> >> news:e4R3FI$VGHA.4328@.TK2MSFTNGP12.phx.gbl...
> >> Never mind group. I cannot recreate the problem I had. Originally in
> >> testing, all of the backups were appending to the same date/time stamped
> >> filename. I set up a new plan and it seems to work as desired -
> >> creating a new file each time the backup runs. I have to manually add a
> >> cleanup task to the DB Maint Plan created by the wizard to delete old DB
> >> files, but I've got that figured out too.
> >>
> >> Rob Kraft
> >>
> >> "Rob Kraft" <robkraft@.msn.com> wrote in message
> >> news:%23nhHf4%23VGHA.3284@.TK2MSFTNGP09.phx.gbl...
> >> In SQL 2000, I could use the DB Maint Wizard to create a backup that
> >> created a new backup file each night. This basic feature does not
> >> appear to be an option in SQL 2005. Is there some workaround? Anyone
> >> know if this will be part of SP01?
> >> I have hundreds of systems that have 4 5GB databases where we do full
> >> backups every night. I do NOT want to append the previous nights
> >> backup to the existing file, and I do NOT want to overwrite last nights
> >> backup because I don't want to be without a backup if tonight's backup
> >> fails.
> >>
> >> All suggestions are welcome, but I need a very simple way to set this
> >> up on hundreds of systems by non-computer literate people.
> >>
> >> Rob Kraft
> >>
> >>
> >>
> >>
> >>
> >
> >
>
>

Can SQL 2005 Backup to a different file name each night?

In SQL 2000, I could use the DB Maint Wizard to create a backup that created
a new backup file each night. This basic feature does not appear to be an
option in SQL 2005. Is there some workaround? Anyone know if this will be
part of SP01?
I have hundreds of systems that have 4 5GB databases where we do full
backups every night. I do NOT want to append the previous nights backup to
the existing file, and I do NOT want to overwrite last nights backup because
I don't want to be without a backup if tonight's backup fails.
All suggestions are welcome, but I need a very simple way to set this up on
hundreds of systems by non-computer literate people.
Rob KraftNever mind group. I cannot recreate the problem I had. Originally in
testing, all of the backups were appending to the same date/time stamped
filename. I set up a new plan and it seems to work as desired - creating a
new file each time the backup runs. I have to manually add a cleanup task
to the DB Maint Plan created by the wizard to delete old DB files, but I've
got that figured out too.
Rob Kraft
"Rob Kraft" <robkraft@.msn.com> wrote in message
news:%23nhHf4%23VGHA.3284@.TK2MSFTNGP09.phx.gbl...
> In SQL 2000, I could use the DB Maint Wizard to create a backup that
> created a new backup file each night. This basic feature does not appear
> to be an option in SQL 2005. Is there some workaround? Anyone know if
> this will be part of SP01?
> I have hundreds of systems that have 4 5GB databases where we do full
> backups every night. I do NOT want to append the previous nights backup
> to the existing file, and I do NOT want to overwrite last nights backup
> because I don't want to be without a backup if tonight's backup fails.
> All suggestions are welcome, but I need a very simple way to set this up
> on hundreds of systems by non-computer literate people.
> Rob Kraft
>|||Rob,
How do you add the delete of the oldest file? I cannot seem to manage this
so far.
Thanks
Chris Wood
"Rob Kraft" <robkraft@.msn.com> wrote in message
news:e4R3FI$VGHA.4328@.TK2MSFTNGP12.phx.gbl...
> Never mind group. I cannot recreate the problem I had. Originally in
> testing, all of the backups were appending to the same date/time stamped
> filename. I set up a new plan and it seems to work as desired - creating
> a new file each time the backup runs. I have to manually add a cleanup
> task to the DB Maint Plan created by the wizard to delete old DB files,
> but I've got that figured out too.
> Rob Kraft
> "Rob Kraft" <robkraft@.msn.com> wrote in message
> news:%23nhHf4%23VGHA.3284@.TK2MSFTNGP09.phx.gbl...
>|||Chris, I could not do this using the Maintenance Plan Wizard. Instead, after
creating the plan, right-click on the plan and select Modify. Then, on the
left hand side (probably) -drag a "Maintenance Cleanup Task" from the
Toolbox window into your plan (make sure you do NOT grab the "History
Cleanup Task"). Right-click on the "Maintenance Cleanup Task" and select
Edit. They you can specify to delete files in a specific folder that are
older than a n Weeks (or n Days). (and you can specify to delete files with
just a specific extension such as bak). Close that window then click on the
"Maintenance Cleanup Task" in the maintence plan and click and drag the
green arrow that appears down to the "Back Up Database Task" you just
created to cause the "Back Up Database Task" to execute after the file
delete.
Technically, I don't see a way using these tools to delete "the oldest
file"; but you can delete "all files over n days old".
Rob Kraft
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:exAKTW$VGHA.5076@.TK2MSFTNGP14.phx.gbl...
> Rob,
> How do you add the delete of the oldest file? I cannot seem to manage this
> so far.
> Thanks
> Chris Wood
> "Rob Kraft" <robkraft@.msn.com> wrote in message
> news:e4R3FI$VGHA.4328@.TK2MSFTNGP12.phx.gbl...
>|||Thank you Rob.
Works like a treat. Another 2005 nuance out of the way.
Chris
"Rob Kraft" <robkraft@.msn.com> wrote in message
news:e7ziF2XWGHA.1564@.TK2MSFTNGP03.phx.gbl...
> Chris, I could not do this using the Maintenance Plan Wizard. Instead,
> after creating the plan, right-click on the plan and select Modify. Then,
> on the left hand side (probably) -drag a "Maintenance Cleanup Task" from
> the Toolbox window into your plan (make sure you do NOT grab the "History
> Cleanup Task"). Right-click on the "Maintenance Cleanup Task" and select
> Edit. They you can specify to delete files in a specific folder that are
> older than a n Weeks (or n Days). (and you can specify to delete files
> with just a specific extension such as bak). Close that window then click
> on the "Maintenance Cleanup Task" in the maintence plan and click and drag
> the green arrow that appears down to the "Back Up Database Task" you just
> created to cause the "Back Up Database Task" to execute after the file
> delete.
> Technically, I don't see a way using these tools to delete "the oldest
> file"; but you can delete "all files over n days old".
> Rob Kraft
>
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:exAKTW$VGHA.5076@.TK2MSFTNGP14.phx.gbl...
>|||See also the discussion in thread
http://forums.microsoft.com/MSDN/Sh...111810&siteid=1
"Chris Wood" wrote:

> Thank you Rob.
> Works like a treat. Another 2005 nuance out of the way.
> Chris
> "Rob Kraft" <robkraft@.msn.com> wrote in message
> news:e7ziF2XWGHA.1564@.TK2MSFTNGP03.phx.gbl...
>
>

Can report parameters be sent in subscription emails?

Hi all,
Is there any way to have the report parameters appear in the subscription
email, for both custom and default reports? Currently, the goal is to just
get the team project name to appear along with the sent report. The other
idea I can think of is to just put a field in the actual report that will
show the project name. I would rather not do this so that we don't have to
edit the existing rdl's (unless in the end, we absolutely have to). It
would also appear redundant when viewing the reports through Report Manager.
In addition to these, it is possible that people would request for other
parameters to be sent with the email, thus cluttering the actual report with
redundant information.
Can anyone help or offer alternatives, please? Thanks.Hello Winkles,
I would like to know this issue a little bit clearly.
Do you mean that you want to add the Report Parameter in the Subject of the
subscription?
Well, you could not refer the Report Parameter in the Subject.
I would like to suggest you to use the data driven subscription so that you
could store the subject in a data table and you could maintain it.
Data-Driven Subscriptions
http://msdn2.microsoft.com/en-us/library/ms159150.aspx
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Wei,
We are trying to include, at the very least, the team project name in the
email somewhere. This is because some people may subscribe to the same
report across multiple team projects, and we need a way to indicate which
project the report belongs to.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:dllA96K$GHA.4432@.TK2MSFTNGXA01.phx.gbl...
> Hello Winkles,
> I would like to know this issue a little bit clearly.
> Do you mean that you want to add the Report Parameter in the Subject of
> the
> subscription?
> Well, you could not refer the Report Parameter in the Subject.
> I would like to suggest you to use the data driven subscription so that
> you
> could store the subject in a data table and you could maintain it.
> Data-Driven Subscriptions
> http://msdn2.microsoft.com/en-us/library/ms159150.aspx
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Winkles,
Thanks for the update.
When you try to create a subscription, you will need to provide which
parameter you will need to render the report.
According to your scenario, you could add a TextBox in the beginning of the
report and add the value =Parameters!Team.Value in the textbox. Then, when
you send the email, and provide the parameter value, it will show the value
in the report.
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Wei,
Thanks for your response. So is that the only way to do it then? Adding a
textbox to the report? There is no way to either set some flag or add some
lines of code to get something like the Parameters selection box to be sent
with the subscription email, along with the options used to generate that
report?
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:a8xSHiY$GHA.4184@.TK2MSFTNGXA01.phx.gbl...
> Hello Winkles,
> Thanks for the update.
> When you try to create a subscription, you will need to provide which
> parameter you will need to render the report.
> According to your scenario, you could add a TextBox in the beginning of
> the
> report and add the value =Parameters!Team.Value in the textbox. Then, when
> you send the email, and provide the parameter value, it will show the
> value
> in the report.
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Just to clarify: will this change also be applied to people who subscribe to
their own reports, i.e. independent of a data-driven subscription?
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:a8xSHiY$GHA.4184@.TK2MSFTNGXA01.phx.gbl...
> Hello Winkles,
> Thanks for the update.
> When you try to create a subscription, you will need to provide which
> parameter you will need to render the report.
> According to your scenario, you could add a TextBox in the beginning of
> the
> report and add the value =Parameters!Team.Value in the textbox. Then, when
> you send the email, and provide the parameter value, it will show the
> value
> in the report.
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Winkles,
If you wants the user to be able to select the parameter in the email
subscription, that can not been done in the Reporting Services.
All the report render type need a parameter value so you could not just
provide the parameter select option in the output file.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.