Data File Does Not Shrink! (SQL2K)

Hi,
I have a database that its data file is almost 15GB. When I go to shrink
file page (EM), the page displays that the minimum file size can be 8GB but
after shrink, the size doesn't change at all! I tried both EM and DBCC
SHRINKFILE and the result is the same(the process takes 10 minutes)! It
might help if I say that the complete backup is about 9GB, but after restore
it's 15GB.
Any help would be greatly appreciated.
Leilahave you tried shrinking the files individually? To do this go to
shrink database, then click on the files... button and select the data
file you want to shrink.
Leila wrote:
> Hi,
> I have a database that its data file is almost 15GB. When I go to shrink
> file page (EM), the page displays that the minimum file size can be 8GB but
> after shrink, the size doesn't change at all! I tried both EM and DBCC
> SHRINKFILE and the result is the same(the process takes 10 minutes)! It
> might help if I say that the complete backup is about 9GB, but after restore
> it's 15GB.
> Any help would be greatly appreciated.
> Leila|||Thanks,
I explained it exactly in my previous post!
"Someone Else" <someone_else_of_course@.hotmail.co.uk> wrote in message
news:1163509708.111473.245080@.b28g2000cwb.googlegroups.com...
> have you tried shrinking the files individually? To do this go to
> shrink database, then click on the files... button and select the data
> file you want to shrink.
> Leila wrote:
>> Hi,
>> I have a database that its data file is almost 15GB. When I go to shrink
>> file page (EM), the page displays that the minimum file size can be 8GB
>> but
>> after shrink, the size doesn't change at all! I tried both EM and DBCC
>> SHRINKFILE and the result is the same(the process takes 10 minutes)! It
>> might help if I say that the complete backup is about 9GB, but after
>> restore
>> it's 15GB.
>> Any help would be greatly appreciated.
>> Leila
>|||you were less exact with the line "any help would be greatly
appreciated"
anyway, I was just trying to check the basics, people often confuse the
shrink database option and shrink file option.
things you could try (I don't know if they make a difference, but I
tend to clutch at straws when this happens to me and it usually works
in the end) would be clearing all connections to your db (not always an
option), checking to see what locks are held, if it's an option you
could even try detaching and re-attaching.
I believe the backup will restore with the file sizes it originally was
backed up with, so if you are restoring from a backup that had a lot of
free space when backed up, it will claim that space again upon restore.
Leila wrote:
> Thanks,
> I explained it exactly in my previous post!
>
> "Someone Else" <someone_else_of_course@.hotmail.co.uk> wrote in message
> news:1163509708.111473.245080@.b28g2000cwb.googlegroups.com...
> > have you tried shrinking the files individually? To do this go to
> > shrink database, then click on the files... button and select the data
> > file you want to shrink.
> >
> > Leila wrote:
> >> Hi,
> >> I have a database that its data file is almost 15GB. When I go to shrink
> >> file page (EM), the page displays that the minimum file size can be 8GB
> >> but
> >> after shrink, the size doesn't change at all! I tried both EM and DBCC
> >> SHRINKFILE and the result is the same(the process takes 10 minutes)! It
> >> might help if I say that the complete backup is about 9GB, but after
> >> restore
> >> it's 15GB.
> >> Any help would be greatly appreciated.
> >> Leila
> >|||Try:
dbcc shrinkfile(1,9000)
... explicitly specify the size (in MB)
"Leila" wrote:
> Hi,
> I have a database that its data file is almost 15GB. When I go to shrink
> file page (EM), the page displays that the minimum file size can be 8GB but
> after shrink, the size doesn't change at all! I tried both EM and DBCC
> SHRINKFILE and the result is the same(the process takes 10 minutes)! It
> might help if I say that the complete backup is about 9GB, but after restore
> it's 15GB.
> Any help would be greatly appreciated.
> Leila
>
>|||Leila,
The situation you are reporting, is relacionated with the DB Transaction Log.
If you are not doing any log shipping, or transaction log backups, run the
Following:
Backup Log DatabaseName with truncate_only
This will truncate the inactive part of the Trn Log.
Best Regards,
Paulo Condeça
"Leila" wrote:
> Hi,
> I have a database that its data file is almost 15GB. When I go to shrink
> file page (EM), the page displays that the minimum file size can be 8GB but
> after shrink, the size doesn't change at all! I tried both EM and DBCC
> SHRINKFILE and the result is the same(the process takes 10 minutes)! It
> might help if I say that the complete backup is about 9GB, but after restore
> it's 15GB.
> Any help would be greatly appreciated.
> Leila
>
>|||Leila
Let's start with classic question , why would you want to shrink the file at
all?
Have you read this article?
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
DBCC SHRINKFILE does not shrink a file past the size needed to store the
data. If you have 50 percent of the pagaes in a 10 MB data file are used ,a
DBCC SHRINKFILE statement with a target_size of 6 shrinks the file to only
5GB/MB not 6GB/MB
"Leila" <Leilas@.hotpop.com> wrote in message
news:uYimey%23BHHA.2328@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have a database that its data file is almost 15GB. When I go to shrink
> file page (EM), the page displays that the minimum file size can be 8GB
> but after shrink, the size doesn't change at all! I tried both EM and DBCC
> SHRINKFILE and the result is the same(the process takes 10 minutes)! It
> might help if I say that the complete backup is about 9GB, but after
> restore it's 15GB.
> Any help would be greatly appreciated.
> Leila
>|||Thanks,
I exactly tried it, but no change occured!
"F_clef" <Fclef@.discussions.microsoft.com> wrote in message
news:A2C58C00-D254-496F-ABFC-B1C7DB76EBDF@.microsoft.com...
> Try:
> dbcc shrinkfile(1,9000)
> ... explicitly specify the size (in MB)
> "Leila" wrote:
>> Hi,
>> I have a database that its data file is almost 15GB. When I go to shrink
>> file page (EM), the page displays that the minimum file size can be 8GB
>> but
>> after shrink, the size doesn't change at all! I tried both EM and DBCC
>> SHRINKFILE and the result is the same(the process takes 10 minutes)! It
>> might help if I say that the complete backup is about 9GB, but after
>> restore
>> it's 15GB.
>> Any help would be greatly appreciated.
>> Leila
>>|||Thanks,
The log file almost always is 30MB! (Simple recovery model is being used)
"Paulo Condeça" <PauloCondea@.discussions.microsoft.com> wrote in message
news:B2BF958E-CE71-4DD6-8570-DA5EB3EF47F0@.microsoft.com...
> Leila,
> The situation you are reporting, is relacionated with the DB Transaction
> Log.
> If you are not doing any log shipping, or transaction log backups, run the
> Following:
> Backup Log DatabaseName with truncate_only
> This will truncate the inactive part of the Trn Log.
> Best Regards,
> Paulo Condeça
> "Leila" wrote:
>> Hi,
>> I have a database that its data file is almost 15GB. When I go to shrink
>> file page (EM), the page displays that the minimum file size can be 8GB
>> but
>> after shrink, the size doesn't change at all! I tried both EM and DBCC
>> SHRINKFILE and the result is the same(the process takes 10 minutes)! It
>> might help if I say that the complete backup is about 9GB, but after
>> restore
>> it's 15GB.
>> Any help would be greatly appreciated.
>> Leila
>>|||Thanks Uri,
Actually there was a big table in db (about 5GB). At the end of year, the
data of this table was moved to other db (kind of archive). The admin
dropped and recreated this table in first db. After some time, this table
became large again. sp_SpaceUsed shows that this table has 3GB reserved
space, 500MB is data and almost 2.5GB is unused! I'm curious to free this
2.5GB space.
I must mention that DBCC CHECKDB returns error for 4 pages near eachother.
But the ObjectID the it shows does not exists in sysobjects and Object_Name
function returns NULL for it!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:edCoPQ$BHHA.3228@.TK2MSFTNGP03.phx.gbl...
> Leila
> Let's start with classic question , why would you want to shrink the file
> at all?
> Have you read this article?
> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
>
> DBCC SHRINKFILE does not shrink a file past the size needed to store the
> data. If you have 50 percent of the pagaes in a 10 MB data file are used
> ,a DBCC SHRINKFILE statement with a target_size of 6 shrinks the file to
> only 5GB/MB not 6GB/MB
>
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:uYimey%23BHHA.2328@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> I have a database that its data file is almost 15GB. When I go to shrink
>> file page (EM), the page displays that the minimum file size can be 8GB
>> but after shrink, the size doesn't change at all! I tried both EM and
>> DBCC SHRINKFILE and the result is the same(the process takes 10 minutes)!
>> It might help if I say that the complete backup is about 9GB, but after
>> restore it's 15GB.
>> Any help would be greatly appreciated.
>> Leila
>sql

Data File Does Not Shrink! (SQL2K)

Hi,
I have a database that its data file is almost 15GB. When I go to shrink
file page (EM), the page displays that the minimum file size can be 8GB but
after shrink, the size doesn't change at all! I tried both EM and DBCC
SHRINKFILE and the result is the same(the process takes 10 minutes)! It
might help if I say that the complete backup is about 9GB, but after restore
it's 15GB.
Any help would be greatly appreciated.
Leila
have you tried shrinking the files individually? To do this go to
shrink database, then click on the files... button and select the data
file you want to shrink.
Leila wrote:
> Hi,
> I have a database that its data file is almost 15GB. When I go to shrink
> file page (EM), the page displays that the minimum file size can be 8GB but
> after shrink, the size doesn't change at all! I tried both EM and DBCC
> SHRINKFILE and the result is the same(the process takes 10 minutes)! It
> might help if I say that the complete backup is about 9GB, but after restore
> it's 15GB.
> Any help would be greatly appreciated.
> Leila
|||Thanks,
I explained it exactly in my previous post!
"Someone Else" <someone_else_of_course@.hotmail.co.uk> wrote in message
news:1163509708.111473.245080@.b28g2000cwb.googlegr oups.com...
> have you tried shrinking the files individually? To do this go to
> shrink database, then click on the files... button and select the data
> file you want to shrink.
> Leila wrote:
>
|||you were less exact with the line "any help would be greatly
appreciated"
anyway, I was just trying to check the basics, people often confuse the
shrink database option and shrink file option.
things you could try (I don't know if they make a difference, but I
tend to clutch at straws when this happens to me and it usually works
in the end) would be clearing all connections to your db (not always an
option), checking to see what locks are held, if it's an option you
could even try detaching and re-attaching.
I believe the backup will restore with the file sizes it originally was
backed up with, so if you are restoring from a backup that had a lot of
free space when backed up, it will claim that space again upon restore.
Leila wrote:[vbcol=seagreen]
> Thanks,
> I explained it exactly in my previous post!
>
> "Someone Else" <someone_else_of_course@.hotmail.co.uk> wrote in message
> news:1163509708.111473.245080@.b28g2000cwb.googlegr oups.com...
|||Try:
dbcc shrinkfile(1,9000)
... explicitly specify the size (in MB)
"Leila" wrote:

> Hi,
> I have a database that its data file is almost 15GB. When I go to shrink
> file page (EM), the page displays that the minimum file size can be 8GB but
> after shrink, the size doesn't change at all! I tried both EM and DBCC
> SHRINKFILE and the result is the same(the process takes 10 minutes)! It
> might help if I say that the complete backup is about 9GB, but after restore
> it's 15GB.
> Any help would be greatly appreciated.
> Leila
>
>
|||Leila,
The situation you are reporting, is relacionated with the DB Transaction Log.
If you are not doing any log shipping, or transaction log backups, run the
Following:
Backup Log DatabaseName with truncate_only
This will truncate the inactive part of the Trn Log.
Best Regards,
Paulo Conde?a
"Leila" wrote:

> Hi,
> I have a database that its data file is almost 15GB. When I go to shrink
> file page (EM), the page displays that the minimum file size can be 8GB but
> after shrink, the size doesn't change at all! I tried both EM and DBCC
> SHRINKFILE and the result is the same(the process takes 10 minutes)! It
> might help if I say that the complete backup is about 9GB, but after restore
> it's 15GB.
> Any help would be greatly appreciated.
> Leila
>
>
|||Leila
Let's start with classic question , why would you want to shrink the file at
all?
Have you read this article?
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
DBCC SHRINKFILE does not shrink a file past the size needed to store the
data. If you have 50 percent of the pagaes in a 10 MB data file are used ,a
DBCC SHRINKFILE statement with a target_size of 6 shrinks the file to only
5GB/MB not 6GB/MB
"Leila" <Leilas@.hotpop.com> wrote in message
news:uYimey%23BHHA.2328@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have a database that its data file is almost 15GB. When I go to shrink
> file page (EM), the page displays that the minimum file size can be 8GB
> but after shrink, the size doesn't change at all! I tried both EM and DBCC
> SHRINKFILE and the result is the same(the process takes 10 minutes)! It
> might help if I say that the complete backup is about 9GB, but after
> restore it's 15GB.
> Any help would be greatly appreciated.
> Leila
>
|||Thanks,
I exactly tried it, but no change occured!
"F_clef" <Fclef@.discussions.microsoft.com> wrote in message
news:A2C58C00-D254-496F-ABFC-B1C7DB76EBDF@.microsoft.com...[vbcol=seagreen]
> Try:
> dbcc shrinkfile(1,9000)
> ... explicitly specify the size (in MB)
> "Leila" wrote:
|||Thanks,
The log file almost always is 30MB! (Simple recovery model is being used)
"Paulo Condea" <PauloCondea@.discussions.microsoft.com> wrote in message
news:B2BF958E-CE71-4DD6-8570-DA5EB3EF47F0@.microsoft.com...[vbcol=seagreen]
> Leila,
> The situation you are reporting, is relacionated with the DB Transaction
> Log.
> If you are not doing any log shipping, or transaction log backups, run the
> Following:
> Backup Log DatabaseName with truncate_only
> This will truncate the inactive part of the Trn Log.
> Best Regards,
> Paulo Condea
> "Leila" wrote:
|||Thanks Uri,
Actually there was a big table in db (about 5GB). At the end of year, the
data of this table was moved to other db (kind of archive). The admin
dropped and recreated this table in first db. After some time, this table
became large again. sp_SpaceUsed shows that this table has 3GB reserved
space, 500MB is data and almost 2.5GB is unused! I'm curious to free this
2.5GB space.
I must mention that DBCC CHECKDB returns error for 4 pages near eachother.
But the ObjectID the it shows does not exists in sysobjects and Object_Name
function returns NULL for it!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:edCoPQ$BHHA.3228@.TK2MSFTNGP03.phx.gbl...
> Leila
> Let's start with classic question , why would you want to shrink the file
> at all?
> Have you read this article?
> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
>
> DBCC SHRINKFILE does not shrink a file past the size needed to store the
> data. If you have 50 percent of the pagaes in a 10 MB data file are used
> ,a DBCC SHRINKFILE statement with a target_size of 6 shrinks the file to
> only 5GB/MB not 6GB/MB
>
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:uYimey%23BHHA.2328@.TK2MSFTNGP02.phx.gbl...
>

Data File Does Not Shrink! (SQL2K)

Hi,
I have a database that its data file is almost 15GB. When I go to shrink
file page (EM), the page displays that the minimum file size can be 8GB but
after shrink, the size doesn't change at all! I tried both EM and DBCC
SHRINKFILE and the result is the same(the process takes 10 minutes)! It
might help if I say that the complete backup is about 9GB, but after restore
it's 15GB.
Any help would be greatly appreciated.
Leilahave you tried shrinking the files individually? To do this go to
shrink database, then click on the files... button and select the data
file you want to shrink.
Leila wrote:
> Hi,
> I have a database that its data file is almost 15GB. When I go to shrink
> file page (EM), the page displays that the minimum file size can be 8GB bu
t
> after shrink, the size doesn't change at all! I tried both EM and DBCC
> SHRINKFILE and the result is the same(the process takes 10 minutes)! It
> might help if I say that the complete backup is about 9GB, but after resto
re
> it's 15GB.
> Any help would be greatly appreciated.
> Leila|||Thanks,
I explained it exactly in my previous post!
"Someone Else" <someone_else_of_course@.hotmail.co.uk> wrote in message
news:1163509708.111473.245080@.b28g2000cwb.googlegroups.com...
> have you tried shrinking the files individually? To do this go to
> shrink database, then click on the files... button and select the data
> file you want to shrink.
> Leila wrote:
>|||you were less exact with the line "any help would be greatly
appreciated"
anyway, I was just trying to check the basics, people often confuse the
shrink database option and shrink file option.
things you could try (I don't know if they make a difference, but I
tend to clutch at straws when this happens to me and it usually works
in the end) would be clearing all connections to your db (not always an
option), checking to see what locks are held, if it's an option you
could even try detaching and re-attaching.
I believe the backup will restore with the file sizes it originally was
backed up with, so if you are restoring from a backup that had a lot of
free space when backed up, it will claim that space again upon restore.
Leila wrote:[vbcol=seagreen]
> Thanks,
> I explained it exactly in my previous post!
>
> "Someone Else" <someone_else_of_course@.hotmail.co.uk> wrote in message
> news:1163509708.111473.245080@.b28g2000cwb.googlegroups.com...|||Try:
dbcc shrinkfile(1,9000)
... explicitly specify the size (in MB)
"Leila" wrote:

> Hi,
> I have a database that its data file is almost 15GB. When I go to shrink
> file page (EM), the page displays that the minimum file size can be 8GB bu
t
> after shrink, the size doesn't change at all! I tried both EM and DBCC
> SHRINKFILE and the result is the same(the process takes 10 minutes)! It
> might help if I say that the complete backup is about 9GB, but after resto
re
> it's 15GB.
> Any help would be greatly appreciated.
> Leila
>
>|||Leila,
The situation you are reporting, is relacionated with the DB Transaction Log
.
If you are not doing any log shipping, or transaction log backups, run the
Following:
Backup Log DatabaseName with truncate_only
This will truncate the inactive part of the Trn Log.
Best Regards,
Paulo Conde?a
"Leila" wrote:

> Hi,
> I have a database that its data file is almost 15GB. When I go to shrink
> file page (EM), the page displays that the minimum file size can be 8GB bu
t
> after shrink, the size doesn't change at all! I tried both EM and DBCC
> SHRINKFILE and the result is the same(the process takes 10 minutes)! It
> might help if I say that the complete backup is about 9GB, but after resto
re
> it's 15GB.
> Any help would be greatly appreciated.
> Leila
>
>|||Leila
Let's start with classic question , why would you want to shrink the file at
all?
Have you read this article?
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
DBCC SHRINKFILE does not shrink a file past the size needed to store the
data. If you have 50 percent of the pagaes in a 10 MB data file are used ,a
DBCC SHRINKFILE statement with a target_size of 6 shrinks the file to only
5GB/MB not 6GB/MB
"Leila" <Leilas@.hotpop.com> wrote in message
news:uYimey%23BHHA.2328@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have a database that its data file is almost 15GB. When I go to shrink
> file page (EM), the page displays that the minimum file size can be 8GB
> but after shrink, the size doesn't change at all! I tried both EM and DBCC
> SHRINKFILE and the result is the same(the process takes 10 minutes)! It
> might help if I say that the complete backup is about 9GB, but after
> restore it's 15GB.
> Any help would be greatly appreciated.
> Leila
>|||Thanks,
I exactly tried it, but no change occured!
"F_clef" <Fclef@.discussions.microsoft.com> wrote in message
news:A2C58C00-D254-496F-ABFC-B1C7DB76EBDF@.microsoft.com...[vbcol=seagreen]
> Try:
> dbcc shrinkfile(1,9000)
> ... explicitly specify the size (in MB)
> "Leila" wrote:
>|||Thanks,
The log file almost always is 30MB! (Simple recovery model is being used)
"Paulo Condea" <PauloCondea@.discussions.microsoft.com> wrote in message
news:B2BF958E-CE71-4DD6-8570-DA5EB3EF47F0@.microsoft.com...[vbcol=seagreen]
> Leila,
> The situation you are reporting, is relacionated with the DB Transaction
> Log.
> If you are not doing any log shipping, or transaction log backups, run the
> Following:
> Backup Log DatabaseName with truncate_only
> This will truncate the inactive part of the Trn Log.
> Best Regards,
> Paulo Condea
> "Leila" wrote:
>|||Thanks Uri,
Actually there was a big table in db (about 5GB). At the end of year, the
data of this table was moved to other db (kind of archive). The admin
dropped and recreated this table in first db. After some time, this table
became large again. sp_SpaceUsed shows that this table has 3GB reserved
space, 500MB is data and almost 2.5GB is unused! I'm curious to free this
2.5GB space.
I must mention that DBCC CHECKDB returns error for 4 pages near eachother.
But the ObjectID the it shows does not exists in sysobjects and Object_Name
function returns NULL for it!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:edCoPQ$BHHA.3228@.TK2MSFTNGP03.phx.gbl...
> Leila
> Let's start with classic question , why would you want to shrink the file
> at all?
> Have you read this article?
> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
>
> DBCC SHRINKFILE does not shrink a file past the size needed to store the
> data. If you have 50 percent of the pagaes in a 10 MB data file are used
> ,a DBCC SHRINKFILE statement with a target_size of 6 shrinks the file to
> only 5GB/MB not 6GB/MB
>
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:uYimey%23BHHA.2328@.TK2MSFTNGP02.phx.gbl...
>

Data fields are not allowed in the Page Header section

How can I build the page header (Sales for John Smith) where John Smith is
returned in the query results? Data fields are not allowed in the Page
Header section.
All responses greatly appreciated.
--
Any and all contributions are greatly appreciated ...
Regards TJYou can use read-only parameter with default value from query (assuming that
you render separate instance of report for every person)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"TJ" <nospam@.nowhere.com> wrote in message
news:O2Mt1aNoEHA.3564@.tk2msftngp13.phx.gbl...
> How can I build the page header (Sales for John Smith) where John Smith is
> returned in the query results? Data fields are not allowed in the Page
> Header section.
> All responses greatly appreciated.
> --
> Any and all contributions are greatly appreciated ...
> Regards TJ
>
>

data driven web site

I am using vb .net 2003 with msde.

I have downloaded microsoft`s vbsdk setup and have it working pretty well until I get to the login page and the provided credentials will not work.

The sample tells me to set permissions in the dacl editor.

1:What is the dacl editor and how do I use it?

2:What do I set permissions to?

I have been through the code provided over and over and can`t seem to find anything wrong,So I figure maybe this is the problem.

Any help will be appreciated.

Davco

Hi,

this is a SQL Server related forum and this seems more like a problem within the SDk walkthrough. perhpas it would be better to try your question in the ASP.NET forums.

HTH, jens K. Suessmeyer.

http://www.sqlserver2005.de

Data Delivery

I've created a number of .html, pivot tables using Access' Data Page
tools. These work great and by pointing my browser to these files,
users throughout my firm can access these pivot tables. I had assumed
that I could simply publish these pivot tables on the web to outside
users who are configured as active directory users. The .htm pivot
table is linked to a query in Access that is built from a SQL database.
We've separately built a system where users can crawl through our file
server from outside of our network. I placed the .htm file in a folder
that the user has access to and the application shows the file.
However, when the user clicks on the file, s/he gets these messages:
Data Access Pages has detected that your IE security settings will not
allow you to access data from a site considered to be insecure.
[
In order to access the data contained within the Data Access Page, you
need to:
1. Start IE
2. Choose Internet Options from the Tools menu
3. Click on the "Security" Tab
4. Click on the "Trusted Sites" icon
5. Click on the "Sites..." button
6. Uncheck the "Require server verification (https) for all sites in
the zone" checkbox
]
Our technology consultant indicated that there's no way for the data to
"bind" to the browser and it's impossible to expose these .htm, pivot
tables to users outside of our network. Does anyone know a way to
accomplish what I'm trying to do? I feel like it should be possible
since Microsoft created that product to build .htm pages?
Ryan
Any suggestions would be very helpfulRyan.Chowdhury@.gmail.com wrote:
> I've created a number of .html, pivot tables using Access' Data Page
> tools. These work great and by pointing my browser to these files,
> users throughout my firm can access these pivot tables. I had assumed
> that I could simply publish these pivot tables on the web to outside
> users who are configured as active directory users. The .htm pivot
> table is linked to a query in Access that is built from a SQL database.
>
> We've separately built a system where users can crawl through our file
> server from outside of our network. I placed the .htm file in a folder
> that the user has access to and the application shows the file.
> However, when the user clicks on the file, s/he gets these messages:
> Data Access Pages has detected that your IE security settings will not
> allow you to access data from a site considered to be insecure.
> [
> In order to access the data contained within the Data Access Page, you
> need to:
> 1. Start IE
> 2. Choose Internet Options from the Tools menu
> 3. Click on the "Security" Tab
> 4. Click on the "Trusted Sites" icon
> 5. Click on the "Sites..." button
> 6. Uncheck the "Require server verification (https) for all sites in
> the zone" checkbox
> ]
> Our technology consultant indicated that there's no way for the data to
> "bind" to the browser and it's impossible to expose these .htm, pivot
> tables to users outside of our network. Does anyone know a way to
> accomplish what I'm trying to do? I feel like it should be possible
> since Microsoft created that product to build .htm pages?
> Ryan
> Any suggestions would be very helpful
>
First off, you might have better luck asking in an Access group instead
of SQL Server. Second, let me say, YIKES!!! You allow outside access
to your file servers?
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Data Cubes using MS Analysis Services

I need to use cubes in VS 2005 web project. I have no clue how to create cubes or use them in my web page. I am familiar with Reporting Services but not cubes.

thanks in advance!

In SQL Server 2005 it depends on where your data is comming from, if you have a Data Warehouse running you can create the Cubes in Analysis Service but SQL Server 2005 also comes with UDM(unified dimension modeling) stripping the Algebra and moving to calculus in one step, some thing you need tools like Hyperion to do in SQL Server 2000. Try the link below for some SQL Server 2005 Analysis resources including UDM. Hope this helps.

http://www.mosha.com/msolap/yukon.htm

|||Thanks Caddre. I am sure I will find lots of info there. I also found this link: http://www.microsoft.com/technet/prodtechnol/sql/default.mspx.|||

Hi,

I have created a cube using MS Analysis Services 2005. I have a fact table that contains 6 different measures (actualUSrevenue, actualEURrevenue,Qty) and (scheduledUSrevenue,scheduledEURrevenue,scheduledQty). How do I break these up into two separate groups of measures.

I will be taking these separate measure groups to build a stacked column chart with both actual and scheduled in the same column but each in a separate series.

thanks,

marilyn

marilyn.beaudreau@.philips.com

|||

There is very good sample code from Microsoft in the file below and the second link is a tutorial to get you started. Hope this helps.

http://www.microsoft.com/downloads/details.aspx?FamilyID=790d631b-bff9-4f4a-b648-e9209e6ac8ad&DisplayLang=en

http://www.databasejournal.com/article.php/1459531

Data Convertion error help

Hi,

I have an error:"*erro while update quantity. Error converting data type nvarchar to int "while i try update data through form page. Does anybody have any idea how can i correct the error??

I didnt try two methods but both given same error and failed update: -

1) Dim sqlcomm As New SqlCommand(sSaveQuote, rConnect)
....

sqlcomm.Parameters.AddWithValue("@.employeeID", sUserID)
sqlcomm.Parameters.AddWithValue("@.quantity", txtquantity.Text)

2)Error converting data type nvarchar to int ??
Dim rConnect As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("CRNS_CustomerConnectionString").ConnectionString)
Dim command As SqlCommand = New SqlCommand("UpdateOrder", rConnect)
command.CommandType = Data.CommandType.StoredProcedure

If OrderInfo.Verified.ToUpper = "True" Or OrderInfo.Verified = 1 Then

command.Parameters.Add("@.Verified", Data.SqlDbType.Bit)
command.Parameters("@.Verified").Value = 1
Else
command.Parameters.Add("@.Verified", Data.SqlDbType.Bit)
command.Parameters("@.Verified").Value = 0
End If

command.Parameters.Add("@.Comment", Data.SqlDbType.VarChar, 100)
command.Parameters("@.Comment").Value = OrderInfo.Comment

command.Parameters.Add("@.ProductID", Data.SqlDbType.Int)
command.Parameters("@.ProductID").Value = OrderInfo.ProductID

command.Parameters.Add("@.OrderDate", Data.SqlDbType.SmallDateTime)
command.Parameters("@.OrderDate").Value = OrderInfo.OrderDate

Cheers:)

Christe

It seems that your column is int type and what you try to send in connot convert to int.|||

Hi,

Thks for kind replied. Do you have any idea or hint, how can i correct the error?? or how i can convert the nvarchar to int before update in dbs??

cheers:)

|||

Hi

You could debug your program to see if the value you pass to parameter is right ,especiallyOrderInfo.ProductID.

Data Conversion Components & Code Page issue

I am using the SSIS wizard to pull data from DB2 z/os to sql server. The data flow task that is created converts the data to DT_STR Ansi 1252 before storing to sql server database. The package is blowing up on in the data conversion component...no match in found in target code page...for my city name field.

My old dts wizard didn't have this problem. The forums seem to indicate that SSIS is no longer doing some of the implicit conversions that DTS did and I may have to do more than one conversion.

What format type/code page do I use for the other conversion? The code page for my DB2 data source is 37.

I've tried several scenarios and none of them have worked. Any hints?

Quick and dirty work around was to change the destination column to nchar.|||

This one is a good workaround if you don't mind your strings being Unicode at the destination.

If you would rather keep your ANSI strings, then you should go to the package set the appropriate code page in the data conversion transform and set the appropriate collation in the CREATE TABLE statement.

Thanks.

|||

I tried that and couldn't get it to work.

My problem isn't a foreign language issue, but a special character issue. My old DTS packages accepted the special characters without a fuss but I'm told SSIS isn't doing the implicit conversion that the old DTS use to do.

Obviously, I can't seem to figure out which code page to use. And where do I set all of these code pages? My input data is coming from DB2 z/OS which is using code page 37. Do I set the code page of the source component to 37? The destination? The transform component? I tried setting the code page with multiple scenarios...none worked.

There is no where that I can find that explains how to do a code page transformation except in the most general terms.

PS. Wouldn't I only change the collation for a foreign language?

Data change event

Let's say I want to have a Web page that will be showing live data change in
a SQL table? Is it possible to have on SQL side some kind of listener that
will propogate changes to the Web page?
ThanksMarkgoldin wrote:
> Let's say I want to have a Web page that will be showing live data change
in
> a SQL table? Is it possible to have on SQL side some kind of listener that
> will propogate changes to the Web page?
I've always done the opposite, have the Web page query the database
whenever it needs to be refreshed. Even if you build a component with
ActiveX or Java it would still require the client to continually connect
to the data source to determine if there were changes. If you aren't
particular about how it works then just have the Web page refresh itself
on a regular basis, it's alot easier.
gorf|||If you are using SQL Server 2005, then lookup Query Notification in BOL. If
you are using an earlier version, then, as far as I know, you have to have
your application poll the database to look for changes.
"Markgoldin" <Markgoldin@.discussions.microsoft.com> wrote in message
news:D9064F07-0DB3-4687-B562-DF800DD8DA64@.microsoft.com...
> Let's say I want to have a Web page that will be showing live data change
> in
> a SQL table? Is it possible to have on SQL side some kind of listener that
> will propogate changes to the Web page?
> Thanks

Data access, DataReaders, DataSets, web pages and controls

I have a question about loading data on the page lode event. The question is more conceptual then how to.

Using C#, I would like to make a call to a SQL 2000 Server, with the use of a stored procedure return one row with eleven fields. Then use the data to fill five different controls. There is no manipulation of the data it is just presented as information. With a DataReader and the GetValues method using the resultant array I can fill the controls (or can I), or with a DataSet and the Load method do the same thing. Now this code can be placed in the code behind page or it can be implemented in a class. This is the only page that uses this combination of fields and controls; however I would think a more generic call to the data could be made then pick and chose the fields as needed. What process makes the most sense? Is what I just described even possible (as yet I haven't tried it)?

As always thanks in advance for any thoughts, comments, and suggestions.

hi Darel

i think u can create a function in a class and call that function in code behind. that function will return a dataset. u cannot use datareader as u have to fill more than one control in a function call.

Data Access Pages and SQL-Server

Dear All,

I have developed a Data Access Page with Access as a project. It is
connected to a SQL-Server database. I try to edit the data in the table and
am not able to do so. I might be missing some permissions. I have changed
a number. What am I missing?

Thanks in advance.

Jeff MagouirkIf the SQL table does not have a primary index (key), your Access program
can NOT update the table. I am 90% sure this is your problem.

Oscar...

"Jeff Magouirk" <magouirkj@.njc.org> wrote in message
news:10psm909drc4ea6@.corp.supernews.com...
> Dear All,
> I have developed a Data Access Page with Access as a project. It is
> connected to a SQL-Server database. I try to edit the data in the table
and
> am not able to do so. I might be missing some permissions. I have
changed
> a number. What am I missing?
> Thanks in advance.
> Jeff Magouirk

cyrstal report into asp

Hello friends,
I am a newbie in crystal report - working on 9.2 version i have created a report and would like to view the same in an asp page -
Please if anybody can help me out with this - wanted steps to acheive the same
Thanks in advance
sandyGive a look to -->
http://www.thinkydink.com/crystal.html
This tutorial assumes you already know how to code in ASP and your Crystal and IIS servers are already set up and fully functional.

Cutomizing Exported Excel tabs

Hi All
I have a very simple report that is grouped on a particular field. I have
also set the "Page Break at end property" set to true for this group. I wish
to set up a subscription that will email this report as an excel attachment.
The excel export shows the records of each group in a separate sheet -
Exactly the way I need. What I also want is that the tabs of each sheet
should show the group field name as its name instead of sheet1, sheet2
etc....
Is there any way to achieve this ?
ThanksSorry, there is no property in the RDL that would allow you to achieve
customizing the sheet names.
It is under consideration for inclusion in a future release.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"PR" <PR@.discussions.microsoft.com> wrote in message
news:FEDD440A-49E9-4F2F-9DA3-08CC995E2D7B@.microsoft.com...
> Hi All
> I have a very simple report that is grouped on a particular field. I have
> also set the "Page Break at end property" set to true for this group. I
wish
> to set up a subscription that will email this report as an excel
attachment.
> The excel export shows the records of each group in a separate sheet -
> Exactly the way I need. What I also want is that the tabs of each sheet
> should show the group field name as its name instead of sheet1, sheet2
> etc....
> Is there any way to achieve this ?
> Thanks|||Robert
Can it be moved off the consideration list onto the must do list?
Providing the functionality to output to multiple sheets without the ability
to dynamically name those sheets makes multiple sheets pretty pointless.
I have one report that generates an Excel file for state managers. The file
contains a seperate sheet for each consultant in their state. As I can't
name the sheets from RS all they see is Sheet1, Sheet2, etc...
One of these files has over 200 sheets and the generic naming is a major
pain in the butt. Due to this problem most of the managers won't sign-off on
the costs for developing/deploying RS at our site.
Thanks
Phill
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:OA99z8MBFHA.3924@.TK2MSFTNGP10.phx.gbl...
> Sorry, there is no property in the RDL that would allow you to achieve
> customizing the sheet names.
> It is under consideration for inclusion in a future release.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "PR" <PR@.discussions.microsoft.com> wrote in message
> news:FEDD440A-49E9-4F2F-9DA3-08CC995E2D7B@.microsoft.com...
>> Hi All
>> I have a very simple report that is grouped on a particular field. I have
>> also set the "Page Break at end property" set to true for this group. I
> wish
>> to set up a subscription that will email this report as an excel
> attachment.
>> The excel export shows the records of each group in a separate sheet -
>> Exactly the way I need. What I also want is that the tabs of each sheet
>> should show the group field name as its name instead of sheet1, sheet2
>> etc....
>> Is there any way to achieve this ?
>> Thanks
>
>|||I use the document map facility to get aroung this. It exports as the front
sheet of the excel file and clicking on each title takes you to the correct
sheet.
"news.microsoft.com" <pcarter_NOT_AT_SPAM_bellpotter.com.au> wrote in
message news:ueUeHQPBFHA.2624@.TK2MSFTNGP11.phx.gbl...
> Robert
> Can it be moved off the consideration list onto the must do list?
> Providing the functionality to output to multiple sheets without the
> ability to dynamically name those sheets makes multiple sheets pretty
> pointless.
> I have one report that generates an Excel file for state managers. The
> file contains a seperate sheet for each consultant in their state. As I
> can't name the sheets from RS all they see is Sheet1, Sheet2, etc...
> One of these files has over 200 sheets and the generic naming is a major
> pain in the butt. Due to this problem most of the managers won't sign-off
> on the costs for developing/deploying RS at our site.
> Thanks
> Phill
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:OA99z8MBFHA.3924@.TK2MSFTNGP10.phx.gbl...
>> Sorry, there is no property in the RDL that would allow you to achieve
>> customizing the sheet names.
>> It is under consideration for inclusion in a future release.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "PR" <PR@.discussions.microsoft.com> wrote in message
>> news:FEDD440A-49E9-4F2F-9DA3-08CC995E2D7B@.microsoft.com...
>> Hi All
>> I have a very simple report that is grouped on a particular field. I
>> have
>> also set the "Page Break at end property" set to true for this group. I
>> wish
>> to set up a subscription that will email this report as an excel
>> attachment.
>> The excel export shows the records of each group in a separate sheet -
>> Exactly the way I need. What I also want is that the tabs of each sheet
>> should show the group field name as its name instead of sheet1, sheet2
>> etc....
>> Is there any way to achieve this ?
>> Thanks
>>
>|||I agree with you Phill... my company likes seamless transitions. Reporting
Services would've been the easiest solution if we had control on the
sheetnames.
I'm keeping my fingers crossed that this is included in the SP2 that's going
to be realeased soon (mid-April last I read). I cannot see the funcitonal
enhancements list because it is in the beta site which I don't have access
to.
Pete
"news.microsoft.com" wrote:
> Robert
> Can it be moved off the consideration list onto the must do list?
> Providing the functionality to output to multiple sheets without the ability
> to dynamically name those sheets makes multiple sheets pretty pointless.
> I have one report that generates an Excel file for state managers. The file
> contains a seperate sheet for each consultant in their state. As I can't
> name the sheets from RS all they see is Sheet1, Sheet2, etc...
> One of these files has over 200 sheets and the generic naming is a major
> pain in the butt. Due to this problem most of the managers won't sign-off on
> the costs for developing/deploying RS at our site.
> Thanks
> Phill
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:OA99z8MBFHA.3924@.TK2MSFTNGP10.phx.gbl...
> > Sorry, there is no property in the RDL that would allow you to achieve
> > customizing the sheet names.
> > It is under consideration for inclusion in a future release.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> >
> > "PR" <PR@.discussions.microsoft.com> wrote in message
> > news:FEDD440A-49E9-4F2F-9DA3-08CC995E2D7B@.microsoft.com...
> >> Hi All
> >>
> >> I have a very simple report that is grouped on a particular field. I have
> >> also set the "Page Break at end property" set to true for this group. I
> > wish
> >> to set up a subscription that will email this report as an excel
> > attachment.
> >> The excel export shows the records of each group in a separate sheet -
> >> Exactly the way I need. What I also want is that the tabs of each sheet
> >> should show the group field name as its name instead of sheet1, sheet2
> >> etc....
> >>
> >> Is there any way to achieve this ?
> >>
> >> Thanks
> >
> >
> >
>
>

Customizing the Home Page

Hi,
Anyone have a link to any instructions on how to customize the RS Home page?
I'd like the change the bolded 'Home' text with our company's name.
Thanks
JerryAccording to the Hitchhiker's Guide to SQL Server 2000 Reporting
Services, you should be able to do that by accessing and editing the
ReportingServices.css file on the box where ReportServer resides. They
list the path as C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\Report Manager\Styles. They warn several times to back up the
original CSS file and try your changes on your test server. I don't
have access to our report server box so I've never tried this. Good
luck!!