bugs in subreport

I have a table contain a sub report . when I run on preview (visual studio), no problem . but when I run from my application , the report viewer just show "Report been generated" , never show the report .

after try and error I discover that when the query from main report return no records , plus the table contain a sub report , the problem occur only if you run it from your application using report viewer . not from visual studio . is this a bugs? anyway to resolve this or work around?

thks

a couple of things..

on your main report, you should probobaly set up a static dataset that always returns data... some like select from table where 1=1 or something like that. You can hide that information.

Secondly, besure to set up a description in the no rows property of the main and sub reports.

Bug? Report Builder returning only unique records!

Our users use Report Builder for writing ad-hoc queries. They have run into a problem where Report Builder is returning only distinct records is the entities unique identifier is not added to the report.

Example:

TransID Type TransQuantity

1 CS 4
2 CS 4
3 CP 2
4 CN 3

Adding the above fields to the report builder canvas will return 4 rows. However, if I were to add only Type and TransQuantity to the canvas as such, Report Builder will only return 3 rows:

Type TransQuantity

CS 4
CP 2
CN 3

Is there any way to have Report Builder return the actual number of records? Our users often will export the results from Report Builder into Excel to slice and dice the data, and with the functionality the Report Builder has right now, incorrect values will be certain.

Thanks,
Taurkon

You need to be aware of what Report Builder is grouping on. If you don't want rows based on distinct values, add the ID field first to make sure you get an entity group, then remove it later.

See this blog post for more info:

http://blogs.msdn.com/bobmeyers/archive/2006/12/20/getting-grouping-right-in-report-builder.aspx

Hope this helps!

|||Thanks Bob for your response.

BUG: provider cannot derive parameter information and setparameter

I create reports on an oracle db. I use the correct oracle provider. When i
create a report parameter and run it in the datatab, it says "provider cannot
derive parameter information and setparameterinfo has not been called".
However if I go to generic query designer or the layout tab, the report
parameter works correctly.
This appears to be a bug!!. Could someone from Microsoft please confirm this.
Much appreciated
Kevin WeirYou will need an Oracle Client 8.1.7 or later installed on the server and
the client machines. Please verify you are not using an older Oracle client.
Regardless of the data provider (OleDB or managed), they will need the
Oracle Client (OCI) to actually talk to the Oracle server.
As indicated in several other discussion threads on this newsgroup, the
visual query designer (with 4 panes) is a shared component of the VS
framework (which is unable to use the managed provider and uses the MS OleDB
provider for Oracle instead). Even if you select "Oracle" from the data
source dialog, the visual query designer will actually use the OleDB
provider, while the generic query designer will *always* use the data
provider you actually selected. I.e. "Oracle" is the managed provider of the
.NET framework. Most likely you are using named parameters (e.g. :par1)
which are only supported by the managed Oracle provider (hence the query
execution works successfully in the generic text-based query designer). The
OleDB provider only supports unnamed parameters.
Some information can also be found in this KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kevin Weir" <KevinWeir@.discussions.microsoft.com> wrote in message
news:D359816A-16DD-4CDD-959D-C5B066474C15@.microsoft.com...
> I create reports on an oracle db. I use the correct oracle provider. When
i
> create a report parameter and run it in the datatab, it says "provider
cannot
> derive parameter information and setparameterinfo has not been called".
> However if I go to generic query designer or the layout tab, the report
> parameter works correctly.
> This appears to be a bug!!. Could someone from Microsoft please confirm
this.
> Much appreciated
> Kevin Weir
>|||Just adding another comment: The graphical query designer in RS is the VDT
component which supports only a limited list of data providers as outlined
in this KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;811241
The text-based generic query designer in RS supports almost any data
provider.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23AOfSgAsEHA.3396@.tk2msftngp13.phx.gbl...
> You will need an Oracle Client 8.1.7 or later installed on the server and
> the client machines. Please verify you are not using an older Oracle
client.
> Regardless of the data provider (OleDB or managed), they will need the
> Oracle Client (OCI) to actually talk to the Oracle server.
> As indicated in several other discussion threads on this newsgroup, the
> visual query designer (with 4 panes) is a shared component of the VS
> framework (which is unable to use the managed provider and uses the MS
OleDB
> provider for Oracle instead). Even if you select "Oracle" from the data
> source dialog, the visual query designer will actually use the OleDB
> provider, while the generic query designer will *always* use the data
> provider you actually selected. I.e. "Oracle" is the managed provider of
the
> .NET framework. Most likely you are using named parameters (e.g. :par1)
> which are only supported by the managed Oracle provider (hence the query
> execution works successfully in the generic text-based query designer).
The
> OleDB provider only supports unnamed parameters.
> Some information can also be found in this KB article:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Kevin Weir" <KevinWeir@.discussions.microsoft.com> wrote in message
> news:D359816A-16DD-4CDD-959D-C5B066474C15@.microsoft.com...
> > I create reports on an oracle db. I use the correct oracle provider.
When
> i
> > create a report parameter and run it in the datatab, it says "provider
> cannot
> > derive parameter information and setparameterinfo has not been called".
> >
> > However if I go to generic query designer or the layout tab, the report
> > parameter works correctly.
> >
> > This appears to be a bug!!. Could someone from Microsoft please confirm
> this.
> >
> > Much appreciated
> > Kevin Weir
> >
>|||Hi Robert
Thanks for your response. Your comments have clarrified this issue for me.
I did not realize the OLE DB provider was being used by Visual Designer
which accounts for different behavior in Generic Query designer.
For others that may read this thread we are using Oracle 9.2.0.4 client with
named parameters. For example, one of our queries might look like this:
SELECT * FROM EMPLOYEES WHERE EMPLOYEE_ID = :EMPLOYEE_ID
Regards
Kevin
"Robert Bruckner [MSFT]" wrote:
> You will need an Oracle Client 8.1.7 or later installed on the server and
> the client machines. Please verify you are not using an older Oracle client.
> Regardless of the data provider (OleDB or managed), they will need the
> Oracle Client (OCI) to actually talk to the Oracle server.
> As indicated in several other discussion threads on this newsgroup, the
> visual query designer (with 4 panes) is a shared component of the VS
> framework (which is unable to use the managed provider and uses the MS OleDB
> provider for Oracle instead). Even if you select "Oracle" from the data
> source dialog, the visual query designer will actually use the OleDB
> provider, while the generic query designer will *always* use the data
> provider you actually selected. I.e. "Oracle" is the managed provider of the
> ..NET framework. Most likely you are using named parameters (e.g. :par1)
> which are only supported by the managed Oracle provider (hence the query
> execution works successfully in the generic text-based query designer). The
> OleDB provider only supports unnamed parameters.
> Some information can also be found in this KB article:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Kevin Weir" <KevinWeir@.discussions.microsoft.com> wrote in message
> news:D359816A-16DD-4CDD-959D-C5B066474C15@.microsoft.com...
> > I create reports on an oracle db. I use the correct oracle provider. When
> i
> > create a report parameter and run it in the datatab, it says "provider
> cannot
> > derive parameter information and setparameterinfo has not been called".
> >
> > However if I go to generic query designer or the layout tab, the report
> > parameter works correctly.
> >
> > This appears to be a bug!!. Could someone from Microsoft please confirm
> this.
> >
> > Much appreciated
> > Kevin Weir
> >
>
>

bug when running sp at package

Dear all

i have a stored procedure which run in package. I find out that the stored

procedure stop at the running after 1 seconds, but the pacakage reports the

success.

this stored procedure can run at query analyzer normally.

I tried to adjust the command time-out at the execute sql task properties

object to 9999 or 0 or 1800. However, I find out it is useless to extend the

executive time.

The case happens in two sql server 2000 which is installed in win 2k server

and nt server 5.0. So, I guess it is a sql server bug.

Please give me some suggestion. whether a sql server has this bug? how can i

fix it?

thx
alex

my code is as follow.

CREATE PROCEDURE usp_UpdateRGNUPC
AS
declare @.upcVar varchar(13), @.skuVar varchar(9), @.strStore varchar(7), @.tempSql varchar(1000)

declare varTempShop cursor
local
static
FOR select distinct Shop from strmst
OPEN varTempShop
fetch next from varTempShop into @.strStore
while @.@.FETCH_STATUS = 0
begin
declare varTemp cursor
FOR SELECT r.upc, r.sku
FROM rgnupc r
INNER JOIN strmst s ON r.rgnid = s.rgnid
WHERE s.Shop = @.strStore
OPEN varTemp
fetch next from varTemp into @.upcVar, @.skuVar
while @.@.FETCH_STATUS = 0
begin
set @.tempSql = 'select * from ' + @.strStore + '.dbo.invupc where upc = ''' + @.upcVar + ''''
exec(@.tempSql)

if (@.@.rowcount>0)
begin
set @.tempSql = 'Update ' + @.strStore + '.dbo.invupc set sku = ''' + @.skuVar + ''' where upc = ''' + @.upcVar + ''''
exec(@.tempSql)
end
else
begin
set @.tempSql = 'Insert into ' + @.strStore + '.dbo.invupc (upc, sku) values (''' + @.upcVar + ''',''' + @.skuVar + ''')'
exec(@.tempSql)
end

fetch next from varTemp into @.upcVar, @.skuVar
end
close varTemp
deallocate varTemp

fetch next from varTempShop into @.strStore
end
close varTempShop
deallocate varTempShop
GO

one sql server 2000 is service pack 3. another is service pack 4.

Alex

Bug using FOR XML AUTO with columns with type char(1)

Hello,
Having some problems with generating xml with "FOR XML AUTO". Rows with
a column with a value char(0) seems to terminate the row!
Try to run the following:
SELECT
*
FROM (
SELECT
1 AS orderItemId,
1 AS orderId,
CHAR(0) AS orderItemStatus --CHAR(0) terminates row!
UNION
SELECT
2 AS orderItemId,
1 AS orderId,
CHAR(49) AS orderItemStatus
) AS orderItem
FOR XML AUTO
Generates:
<orderItem orderItemId="1" orderId="1" orderItemStatus="
Should be(?):
<orderItem orderItemId="1" orderId="1" orderItemStatus=" "/><orderItem
orderItemId="2" orderId="1" orderItemStatus="1"/>
Anyone seen this before?
Regards, Nils
CHAR(0) is not a valid XML character. In FOR XML, we do not detect invalid
characters for performance reasons, so you will pass the XML anyway.
Depending on what the client code uses to read the XML, it may see the
CHAR(0) and decide that it is the end of the string (for instance, if the
client code uses the standard C/C++ string types).
So the recommendation is: Do not generate XML containing invalid characters
such as CHAR(0) since they are not supported by compliant XML parsers and
may result in other unforeseen behaviour.
Best regards
Michael
<nilsflemstrom@.gmail.com> wrote in message
news:1125047051.277443.138730@.z14g2000cwz.googlegr oups.com...
> Hello,
> Having some problems with generating xml with "FOR XML AUTO". Rows with
> a column with a value char(0) seems to terminate the row!
> Try to run the following:
> SELECT
> *
> FROM (
> SELECT
> 1 AS orderItemId,
> 1 AS orderId,
> CHAR(0) AS orderItemStatus --CHAR(0) terminates row!
> UNION
> SELECT
> 2 AS orderItemId,
> 1 AS orderId,
> CHAR(49) AS orderItemStatus
> ) AS orderItem
> FOR XML AUTO
> Generates:
> <orderItem orderItemId="1" orderId="1" orderItemStatus="
> Should be(?):
> <orderItem orderItemId="1" orderId="1" orderItemStatus=" "/><orderItem
> orderItemId="2" orderId="1" orderItemStatus="1"/>
> Anyone seen this before?
> Regards, Nils
>

Bug using FOR XML AUTO with columns with type char(1)

Hello,
Having some problems with generating xml with "FOR XML AUTO". Rows with
a column with a value char(0) seems to terminate the row!
Try to run the following:
SELECT
*
FROM (
SELECT
1 AS orderItemId,
1 AS orderId,
CHAR(0) AS orderItemStatus --CHAR(0) terminates row!
UNION
SELECT
2 AS orderItemId,
1 AS orderId,
CHAR(49) AS orderItemStatus
) AS orderItem
FOR XML AUTO
Generates:
<orderItem orderItemId="1" orderId="1" orderItemStatus="
Should be(?):
<orderItem orderItemId="1" orderId="1" orderItemStatus=" "/><orderItem
orderItemId="2" orderId="1" orderItemStatus="1"/>
Anyone seen this before?
Regards, NilsCHAR(0) is not a valid XML character. In FOR XML, we do not detect invalid
characters for performance reasons, so you will pass the XML anyway.
Depending on what the client code uses to read the XML, it may see the
CHAR(0) and decide that it is the end of the string (for instance, if the
client code uses the standard C/C++ string types).
So the recommendation is: Do not generate XML containing invalid characters
such as CHAR(0) since they are not supported by compliant XML parsers and
may result in other unforeseen behaviour.
Best regards
Michael
<nilsflemstrom@.gmail.com> wrote in message
news:1125047051.277443.138730@.z14g2000cwz.googlegroups.com...
> Hello,
> Having some problems with generating xml with "FOR XML AUTO". Rows with
> a column with a value char(0) seems to terminate the row!
> Try to run the following:
> SELECT
> *
> FROM (
> SELECT
> 1 AS orderItemId,
> 1 AS orderId,
> CHAR(0) AS orderItemStatus --CHAR(0) terminates row!
> UNION
> SELECT
> 2 AS orderItemId,
> 1 AS orderId,
> CHAR(49) AS orderItemStatus
> ) AS orderItem
> FOR XML AUTO
> Generates:
> <orderItem orderItemId="1" orderId="1" orderItemStatus="
> Should be(?):
> <orderItem orderItemId="1" orderId="1" orderItemStatus=" "/><orderItem
> orderItemId="2" orderId="1" orderItemStatus="1"/>
> Anyone seen this before?
> Regards, Nils
>

Bug in Task

Hi all,
I have a job that run 3 task. The first one do a backup, the second one copy those backup files from one drive to another drive, the third one supposed to delete the backup from the first drive. What is happening is as soon as the second task start the third task also start for some reason, it does not wait for all the backup files to be moved, so i end up with one backup file being copied on the second drive (locking the backup file) but all the other backup get deleted except for the lock file. Has anyone encounter the same problem? is there a way i can set up the third task not to start until the second is completed?

axel_2005 wrote:

Hi all,
I have a job that run 3 task. The first one do a backup, the second one copy those backup files from one drive to another drive, the third one supposed to delete the backup from the first drive. What is happening is as soon as the second task start the third task also start for some reason, it does not wait for all the backup files to be moved, so i end up with one backup file being copied on the second drive (locking the backup file) but all the other backup get deleted except for the lock file. Has anyone encounter the same problem? is there a way i can set up the third task not to start until the second is completed?

Do you have any precedence constraints (i.e. blue, red or green lines) between your tasks?

-Jamie

|||the tasks are link by the green arrow|||That's weird. Have you messed with the precedence constraints? When you draw a green arrow between task, by default a 'upon success' precedence is created. Just to make sure, check the options of the precedence constrains by double clicking the green arrow between the 2nd a 3rd task.|||I found a work around. Apparently when the task copy files from one place to another, it somehow return a success even though it did not copy all the files (i would say as soon as it copy the first file) so I removed the maintenance clean up and added another step to delete the files in task 3, that way only when the first step is done it will go to the next step. Thanks for your help.

Bug in DBCC SHRINKDATABASE ?

Hi,
My real DB size is 5 MB and transaction log 30 MB. But transaction log
allocated 900 MB. And if I run
DBCC SHRINKDATABASE (MyDB, 0, TRUNCATEONLY)
it does not shrink me transaction log neither a bit. Why '''?
I do not want to have so big transaction log.BJ
Run DBCC SHRINKFILE instead
"B.J." <BJ@.discussions.microsoft.com> wrote in message
news:0D8B571A-0F7D-4F47-AD2C-3B1FEEB7924B@.microsoft.com...
> Hi,
> My real DB size is 5 MB and transaction log 30 MB. But transaction log
> allocated 900 MB. And if I run
> DBCC SHRINKDATABASE (MyDB, 0, TRUNCATEONLY)
> it does not shrink me transaction log neither a bit. Why
'''?
> I do not want to have so big transaction log.|||I tried
DBCC SHRINKFILE ('IDFROMSysfile..', EMPTYFILE);
and nothing happened.
"Uri Dimant" wrote:
> BJ
> Run DBCC SHRINKFILE instead
> "B.J." <BJ@.discussions.microsoft.com> wrote in message
> news:0D8B571A-0F7D-4F47-AD2C-3B1FEEB7924B@.microsoft.com...
> > Hi,
> >
> > My real DB size is 5 MB and transaction log 30 MB. But transaction log
> > allocated 900 MB. And if I run
> >
> > DBCC SHRINKDATABASE (MyDB, 0, TRUNCATEONLY)
> >
> > it does not shrink me transaction log neither a bit. Why
> '''?
> > I do not want to have so big transaction log.
>
>|||B.J
What are you really trying to do?
You have emptied the file, have you tried to remove it by using EM?
Are you trying to reduce the size of the log file?
Are you trying to delete/remove the log file?
"B.J." <BJ@.discussions.microsoft.com> wrote in message
news:8404C0B7-1D3C-4B71-B22B-D5EEC6C12A69@.microsoft.com...
> I tried
> DBCC SHRINKFILE ('IDFROMSysfile..', EMPTYFILE);
> and nothing happened.
> "Uri Dimant" wrote:
> > BJ
> > Run DBCC SHRINKFILE instead
> >
> > "B.J." <BJ@.discussions.microsoft.com> wrote in message
> > news:0D8B571A-0F7D-4F47-AD2C-3B1FEEB7924B@.microsoft.com...
> > > Hi,
> > >
> > > My real DB size is 5 MB and transaction log 30 MB. But transaction log
> > > allocated 900 MB. And if I run
> > >
> > > DBCC SHRINKDATABASE (MyDB, 0, TRUNCATEONLY)
> > >
> > > it does not shrink me transaction log neither a bit. Why
> > '''?
> > > I do not want to have so big transaction log.
> >
> >
> >|||I want to reduce transaction log size.
when I right click my database and point to all task / shrink database / files
then I have :
Data
current size : 5 MB
Space used : 4 MB
Log
current size : 900,62 MB
Space used : 33,4 MB
And this does not like me. I have allocated to much size. I want to truncate
log to 35 MB. I did all combination of options in all task / shrink database
and no result and also I have not set minimal transaction log so I do not
know wehre is problem.
Hope I said you what you want.
"Uri Dimant" wrote:
> B.J
> What are you really trying to do?
> You have emptied the file, have you tried to remove it by using EM?
> Are you trying to reduce the size of the log file?
> Are you trying to delete/remove the log file?
>
>
>
> "B.J." <BJ@.discussions.microsoft.com> wrote in message
> news:8404C0B7-1D3C-4B71-B22B-D5EEC6C12A69@.microsoft.com...
> > I tried
> >
> > DBCC SHRINKFILE ('IDFROMSysfile..', EMPTYFILE);
> >
> > and nothing happened.
> >
> > "Uri Dimant" wrote:
> >
> > > BJ
> > > Run DBCC SHRINKFILE instead
> > >
> > > "B.J." <BJ@.discussions.microsoft.com> wrote in message
> > > news:0D8B571A-0F7D-4F47-AD2C-3B1FEEB7924B@.microsoft.com...
> > > > Hi,
> > > >
> > > > My real DB size is 5 MB and transaction log 30 MB. But transaction log
> > > > allocated 900 MB. And if I run
> > > >
> > > > DBCC SHRINKDATABASE (MyDB, 0, TRUNCATEONLY)
> > > >
> > > > it does not shrink me transaction log neither a bit. Why
> > > '''?
> > > > I do not want to have so big transaction log.
> > >
> > >
> > >
>
>|||BJ
1) Backup Log file (to truncate a commited transaction (inactive portion)
2) Run DBCC SHRINKFILE
"B.J." <BJ@.discussions.microsoft.com> wrote in message
news:4E607247-C485-468F-B5E7-7EAFAA1C03D9@.microsoft.com...
> I want to reduce transaction log size.
> when I right click my database and point to all task / shrink database /
files
> then I have :
> Data
> current size : 5 MB
> Space used : 4 MB
> Log
> current size : 900,62 MB
> Space used : 33,4 MB
>
> And this does not like me. I have allocated to much size. I want to
truncate
> log to 35 MB. I did all combination of options in all task / shrink
database
> and no result and also I have not set minimal transaction log so I do not
> know wehre is problem.
> Hope I said you what you want.
> "Uri Dimant" wrote:
> > B.J
> > What are you really trying to do?
> > You have emptied the file, have you tried to remove it by using EM?
> >
> > Are you trying to reduce the size of the log file?
> >
> > Are you trying to delete/remove the log file?
> >
> >
> >
> >
> >
> >
> > "B.J." <BJ@.discussions.microsoft.com> wrote in message
> > news:8404C0B7-1D3C-4B71-B22B-D5EEC6C12A69@.microsoft.com...
> > > I tried
> > >
> > > DBCC SHRINKFILE ('IDFROMSysfile..', EMPTYFILE);
> > >
> > > and nothing happened.
> > >
> > > "Uri Dimant" wrote:
> > >
> > > > BJ
> > > > Run DBCC SHRINKFILE instead
> > > >
> > > > "B.J." <BJ@.discussions.microsoft.com> wrote in message
> > > > news:0D8B571A-0F7D-4F47-AD2C-3B1FEEB7924B@.microsoft.com...
> > > > > Hi,
> > > > >
> > > > > My real DB size is 5 MB and transaction log 30 MB. But transaction
log
> > > > > allocated 900 MB. And if I run
> > > > >
> > > > > DBCC SHRINKDATABASE (MyDB, 0, TRUNCATEONLY)
> > > > >
> > > > > it does not shrink me transaction log neither a bit. Why
> > > > '''?
> > > > > I do not want to have so big transaction log.
> > > >
> > > >
> > > >
> >
> >
> >|||Hi B.J.
Try to look up BACKUP LOG and DBCC SHRINKFILE in BOL and make sure that you
do the right things. It could be that you haven't truncated the logfile
correctly and/or haven't shrinked the logfile but the database.
Regards
Steen
B.J. wrote:
> I want to reduce transaction log size.
> when I right click my database and point to all task / shrink
> database / files then I have :
> Data
> current size : 5 MB
> Space used : 4 MB
> Log
> current size : 900,62 MB
> Space used : 33,4 MB
>
> And this does not like me. I have allocated to much size. I want to
> truncate log to 35 MB. I did all combination of options in all task /
> shrink database and no result and also I have not set minimal
> transaction log so I do not know wehre is problem.
> Hope I said you what you want.
> "Uri Dimant" wrote:
>> B.J
>> What are you really trying to do?
>> You have emptied the file, have you tried to remove it by using EM?
>> Are you trying to reduce the size of the log file?
>> Are you trying to delete/remove the log file?
>>
>>
>>
>> "B.J." <BJ@.discussions.microsoft.com> wrote in message
>> news:8404C0B7-1D3C-4B71-B22B-D5EEC6C12A69@.microsoft.com...
>> I tried
>> DBCC SHRINKFILE ('IDFROMSysfile..', EMPTYFILE);
>> and nothing happened.
>> "Uri Dimant" wrote:
>> BJ
>> Run DBCC SHRINKFILE instead
>> "B.J." <BJ@.discussions.microsoft.com> wrote in message
>> news:0D8B571A-0F7D-4F47-AD2C-3B1FEEB7924B@.microsoft.com...
>> Hi,
>> My real DB size is 5 MB and transaction log 30 MB. But
>> transaction log allocated 900 MB. And if I run
>> DBCC SHRINKDATABASE (MyDB, 0, TRUNCATEONLY)
>> it does not shrink me transaction log neither a bit. Why
>> '''? I do not want to have so big transaction log.|||B J
Have a look at these articles on shrinking the Transaction log.
INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/default.aspx?scid=kb;en-us;256650
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/default.aspx?scid=kb;en-us;272318
http://www.mssqlserver.com/faq/logs-shrinklog.asp
Usually a transaction log only needs to be around 10 - 20% of the size of
the database. I assume you have a database in Full recovery mode and you do
not perform transaction log backups. Either set your database to simple
recovery mode or start taking regular transaction log backups.
Hope this helps
John
"B.J." wrote:
> I want to reduce transaction log size.
> when I right click my database and point to all task / shrink database / files
> then I have :
> Data
> current size : 5 MB
> Space used : 4 MB
> Log
> current size : 900,62 MB
> Space used : 33,4 MB
>
> And this does not like me. I have allocated to much size. I want to truncate
> log to 35 MB. I did all combination of options in all task / shrink database
> and no result and also I have not set minimal transaction log so I do not
> know wehre is problem.
> Hope I said you what you want.
> "Uri Dimant" wrote:
> > B.J
> > What are you really trying to do?
> > You have emptied the file, have you tried to remove it by using EM?
> >
> > Are you trying to reduce the size of the log file?
> >
> > Are you trying to delete/remove the log file?
> >
> >
> >
> >
> >
> >
> > "B.J." <BJ@.discussions.microsoft.com> wrote in message
> > news:8404C0B7-1D3C-4B71-B22B-D5EEC6C12A69@.microsoft.com...
> > > I tried
> > >
> > > DBCC SHRINKFILE ('IDFROMSysfile..', EMPTYFILE);
> > >
> > > and nothing happened.
> > >
> > > "Uri Dimant" wrote:
> > >
> > > > BJ
> > > > Run DBCC SHRINKFILE instead
> > > >
> > > > "B.J." <BJ@.discussions.microsoft.com> wrote in message
> > > > news:0D8B571A-0F7D-4F47-AD2C-3B1FEEB7924B@.microsoft.com...
> > > > > Hi,
> > > > >
> > > > > My real DB size is 5 MB and transaction log 30 MB. But transaction log
> > > > > allocated 900 MB. And if I run
> > > > >
> > > > > DBCC SHRINKDATABASE (MyDB, 0, TRUNCATEONLY)
> > > > >
> > > > > it does not shrink me transaction log neither a bit. Why
> > > > '''?
> > > > > I do not want to have so big transaction log.
> > > >
> > > >
> > > >
> >
> >
> >|||I did it and nothing. Read all about how to truncate log from help which is
installed to SQL Server 2000 but it does not work.
"Uri Dimant" wrote:
> BJ
> 1) Backup Log file (to truncate a commited transaction (inactive portion)
> 2) Run DBCC SHRINKFILE
>
>
> "B.J." <BJ@.discussions.microsoft.com> wrote in message
> news:4E607247-C485-468F-B5E7-7EAFAA1C03D9@.microsoft.com...
> > I want to reduce transaction log size.
> >
> > when I right click my database and point to all task / shrink database /
> files
> > then I have :
> > Data
> > current size : 5 MB
> > Space used : 4 MB
> >
> > Log
> > current size : 900,62 MB
> > Space used : 33,4 MB
> >
> >
> > And this does not like me. I have allocated to much size. I want to
> truncate
> > log to 35 MB. I did all combination of options in all task / shrink
> database
> > and no result and also I have not set minimal transaction log so I do not
> > know wehre is problem.
> > Hope I said you what you want.
> >
> > "Uri Dimant" wrote:
> >
> > > B.J
> > > What are you really trying to do?
> > > You have emptied the file, have you tried to remove it by using EM?
> > >
> > > Are you trying to reduce the size of the log file?
> > >
> > > Are you trying to delete/remove the log file?
> > >
> > >
> > >
> > >
> > >
> > >
> > > "B.J." <BJ@.discussions.microsoft.com> wrote in message
> > > news:8404C0B7-1D3C-4B71-B22B-D5EEC6C12A69@.microsoft.com...
> > > > I tried
> > > >
> > > > DBCC SHRINKFILE ('IDFROMSysfile..', EMPTYFILE);
> > > >
> > > > and nothing happened.
> > > >
> > > > "Uri Dimant" wrote:
> > > >
> > > > > BJ
> > > > > Run DBCC SHRINKFILE instead
> > > > >
> > > > > "B.J." <BJ@.discussions.microsoft.com> wrote in message
> > > > > news:0D8B571A-0F7D-4F47-AD2C-3B1FEEB7924B@.microsoft.com...
> > > > > > Hi,
> > > > > >
> > > > > > My real DB size is 5 MB and transaction log 30 MB. But transaction
> log
> > > > > > allocated 900 MB. And if I run
> > > > > >
> > > > > > DBCC SHRINKDATABASE (MyDB, 0, TRUNCATEONLY)
> > > > > >
> > > > > > it does not shrink me transaction log neither a bit. Why
> > > > > '''?
> > > > > > I do not want to have so big transaction log.
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>|||Thank you,
KB help me, exactly
DBCC SHRINKFILE('N_Log', 0);
BACKUP LOG N WITH TRUNCATE_ONLY
DBCC SHRINKFILE('N', 0);
Have a nice day :)
"John Bandettini" wrote:
> B J
> Have a look at these articles on shrinking the Transaction log.
> INF: How to Shrink the SQL Server 7.0 Transaction Log
> http://support.microsoft.com/default.aspx?scid=kb;en-us;256650
> INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
> http://support.microsoft.com/default.aspx?scid=kb;en-us;272318
> http://www.mssqlserver.com/faq/logs-shrinklog.asp
> Usually a transaction log only needs to be around 10 - 20% of the size of
> the database. I assume you have a database in Full recovery mode and you do
> not perform transaction log backups. Either set your database to simple
> recovery mode or start taking regular transaction log backups.
> Hope this helps
> John
> "B.J." wrote:
> > I want to reduce transaction log size.
> >
> > when I right click my database and point to all task / shrink database / files
> > then I have :
> > Data
> > current size : 5 MB
> > Space used : 4 MB
> >
> > Log
> > current size : 900,62 MB
> > Space used : 33,4 MB
> >
> >
> > And this does not like me. I have allocated to much size. I want to truncate
> > log to 35 MB. I did all combination of options in all task / shrink database
> > and no result and also I have not set minimal transaction log so I do not
> > know wehre is problem.
> > Hope I said you what you want.
> >
> > "Uri Dimant" wrote:
> >
> > > B.J
> > > What are you really trying to do?
> > > You have emptied the file, have you tried to remove it by using EM?
> > >
> > > Are you trying to reduce the size of the log file?
> > >
> > > Are you trying to delete/remove the log file?
> > >
> > >
> > >
> > >
> > >
> > >
> > > "B.J." <BJ@.discussions.microsoft.com> wrote in message
> > > news:8404C0B7-1D3C-4B71-B22B-D5EEC6C12A69@.microsoft.com...
> > > > I tried
> > > >
> > > > DBCC SHRINKFILE ('IDFROMSysfile..', EMPTYFILE);
> > > >
> > > > and nothing happened.
> > > >
> > > > "Uri Dimant" wrote:
> > > >
> > > > > BJ
> > > > > Run DBCC SHRINKFILE instead
> > > > >
> > > > > "B.J." <BJ@.discussions.microsoft.com> wrote in message
> > > > > news:0D8B571A-0F7D-4F47-AD2C-3B1FEEB7924B@.microsoft.com...
> > > > > > Hi,
> > > > > >
> > > > > > My real DB size is 5 MB and transaction log 30 MB. But transaction log
> > > > > > allocated 900 MB. And if I run
> > > > > >
> > > > > > DBCC SHRINKDATABASE (MyDB, 0, TRUNCATEONLY)
> > > > > >
> > > > > > it does not shrink me transaction log neither a bit. Why
> > > > > '''?
> > > > > > I do not want to have so big transaction log.
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >

Bug found when updating a one-time scheduled subscription...

When you first create a data-driven sub and schedule it to run "one time" it
works fine. Later, however, if you edit it to try and re-run it, you run
into a problem if the subscription is set to run on a one-time basis only
again. You select "one time" as the schedule and set the time you want it to
fire off. However you can't enter a date. Instead of picking up today as
the default like it does when you first create the subscription, it keeps the
same date that you originally used when you first set it up. So if you are
editing a one-time scheduled subscription and you didn't create the
subscription that same day, the schedule you just created is already in the
past and thus never fires. You can confirm this by checking the "startdate"
field of the "schedule table". I tried working around it by updating the
table manually...
Update Schedule
Set StartDate = '2004-11-10 14:10'
Where ScheduleID = 'whatever'
... but it still didn't fire off the job. Anyone else seen this?
sebring1130you can use the soap api and call rs.firevent on it
"sebring1130" wrote:
> When you first create a data-driven sub and schedule it to run "one time" it
> works fine. Later, however, if you edit it to try and re-run it, you run
> into a problem if the subscription is set to run on a one-time basis only
> again. You select "one time" as the schedule and set the time you want it to
> fire off. However you can't enter a date. Instead of picking up today as
> the default like it does when you first create the subscription, it keeps the
> same date that you originally used when you first set it up. So if you are
> editing a one-time scheduled subscription and you didn't create the
> subscription that same day, the schedule you just created is already in the
> past and thus never fires. You can confirm this by checking the "startdate"
> field of the "schedule table". I tried working around it by updating the
> table manually...
> Update Schedule
> Set StartDate = '2004-11-10 14:10'
> Where ScheduleID = 'whatever'
> ... but it still didn't fire off the job. Anyone else seen this?
> sebring1130
>
>

BUG

Work's fine on my SQL2000 & Query analizer
Any errors messages? How do you run the code?
Maybe the string is too long?
Yes, it does work on SQL2000, but crashes SQL7.
And I need it to run on SQL7
<anonymous@.discussions.microsoft.com> wrote in message
news:577f01c480e8$49111200$a401280a@.phx.gbl...
> Work's fine on my SQL2000 & Query analizer
> Any errors messages? How do you run the code?
> Maybe the string is too long?
|||Could you please post the error numbers and error messages
you get when you run this? Could you also post any
additional errors you have in the SQL log when you run this?
-Sue
On Fri, 13 Aug 2004 05:56:16 +0200, "Lisa Pearlson"
<no@.spam.plz> wrote:

>Yes, it does work on SQL2000, but crashes SQL7.
>And I need it to run on SQL7
><anonymous@.discussions.microsoft.com> wrote in message
>news:577f01c480e8$49111200$a401280a@.phx.gbl...
>

BUG

Work's fine on my SQL2000 & Query analizer
Any errors messages? How do you run the code?
Maybe the string is too long?Yes, it does work on SQL2000, but crashes SQL7.
And I need it to run on SQL7
<anonymous@.discussions.microsoft.com> wrote in message
news:577f01c480e8$49111200$a401280a@.phx.gbl...
> Work's fine on my SQL2000 & Query analizer
> Any errors messages? How do you run the code?
> Maybe the string is too long?|||Could you please post the error numbers and error messages
you get when you run this? Could you also post any
additional errors you have in the SQL log when you run this?
-Sue
On Fri, 13 Aug 2004 05:56:16 +0200, "Lisa Pearlson"
<no@.spam.plz> wrote:

>Yes, it does work on SQL2000, but crashes SQL7.
>And I need it to run on SQL7
><anonymous@.discussions.microsoft.com> wrote in message
>news:577f01c480e8$49111200$a401280a@.phx.gbl...
>

Buffer overrun detected

When I run SQL SP4 in a SQL Server (SQL SP3) running on a Windows 2000
Cluster (Active/Active), I receive the next message:
Buffer Overrun detected!
A buffer overrun has been detected which has corrupted the programs internal
state. The program cannot safely continue execution and must now be
terminated.
In a cluster I have two instances. The first instance installed perfect but
in second instance have a problem describe above.
Thank youHi, we've just come across this too. Has anyone got a solution?
BruceB
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1757341.html|||Hi
You may want to call PSS on this one.
John
"Mario Felix Filho" <Mario Felix Filho@.discussions.microsoft.com> wrote in
message news:DA97BB4C-309E-4CDF-A1F2-A2B4851D264F@.microsoft.com...
> When I run SQL SP4 in a SQL Server (SQL SP3) running on a Windows 2000
> Cluster (Active/Active), I receive the next message:
> Buffer Overrun detected!
> A buffer overrun has been detected which has corrupted the programs
> internal
> state. The program cannot safely continue execution and must now be
> terminated.
> In a cluster I have two instances. The first instance installed perfect
> but
> in second instance have a problem describe above.
> Thank you
>

Buffer overrun detected

When I run SQL SP4 in a SQL Server (SQL SP3) running on a Windows 2000
Cluster (Active/Active), I receive the next message:
Buffer Overrun detected!
A buffer overrun has been detected which has corrupted the programs internal
state. The program cannot safely continue execution and must now be
terminated.
In a cluster I have two instances. The first instance installed perfect but
in second instance have a problem describe above.
Thank you
Hi, we've just come across this too. Has anyone got a solution?|||Hi
You may want to call PSS on this one.
John
"Mario Felix Filho" <Mario Felix Filho@.discussions.microsoft.com> wrote in
message news:DA97BB4C-309E-4CDF-A1F2-A2B4851D264F@.microsoft.com...
> When I run SQL SP4 in a SQL Server (SQL SP3) running on a Windows 2000
> Cluster (Active/Active), I receive the next message:
> Buffer Overrun detected!
> A buffer overrun has been detected which has corrupted the programs
> internal
> state. The program cannot safely continue execution and must now be
> terminated.
> In a cluster I have two instances. The first instance installed perfect
> but
> in second instance have a problem describe above.
> Thank you
>

Buffer overrun detected

When I run SQL SP4 in a SQL Server (SQL SP3) running on a Windows 2000
Cluster (Active/Active), I receive the next message:
Buffer Overrun detected!
A buffer overrun has been detected which has corrupted the programs internal
state. The program cannot safely continue execution and must now be
terminated.
In a cluster I have two instances. The first instance installed perfect but
in second instance have a problem describe above.
Thank youHi
You may want to call PSS on this one.
John
"Mario Felix Filho" <Mario Felix Filho@.discussions.microsoft.com> wrote in
message news:DA97BB4C-309E-4CDF-A1F2-A2B4851D264F@.microsoft.com...
> When I run SQL SP4 in a SQL Server (SQL SP3) running on a Windows 2000
> Cluster (Active/Active), I receive the next message:
> Buffer Overrun detected!
> A buffer overrun has been detected which has corrupted the programs
> internal
> state. The program cannot safely continue execution and must now be
> terminated.
> In a cluster I have two instances. The first instance installed perfect
> but
> in second instance have a problem describe above.
> Thank you
>

Buffer Exception

When running a package created on my local machine i get no errors at all but when i try to run the same package on the server i get an error specifying Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException: The value is too large to fit in the column data area of the buffer.

I have tried changing the defaultbuffersize of the data flow task but this makes no difference. I think that a buffer size for a particular column is being exceed but i cannot find anywhere to set this property.

Has anyone else struck this error?

What key things are different between your local development box and your server? Different locale settings, 32 to 64 bit perhaps?

Broken BI Studio after Office 2k7 install

After an install of Office 2k7 last night, I'm getting some errors in my event log when i run BI Studio. The errors occur when i click a tab that tries to browse the metadata of the cube. IE: The calculations tab, or KPI's, etc..

These are the 2 errors:

Event Type: Error
Event Source: MSOLAP$LocalCube
Event Category: (289)
Event ID: 1
Date: 1/09/07
Time: 8:54:08 AM
User: N/A
Computer: WS124
Description:
The description for Event ID ( 1 ) in Source ( MSOLAP$LocalCube ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Message-handling subsystem: The message manager for the 4105 locale cannot be found..

Event Type: Error
Event Source: MSOLAP$LocalCube
Event Category: (289)
Event ID: 0
Date: 1/09/07
Time: 8:54:08 AM
User: N/A
Computer: WS124
Description:
The description for Event ID ( 0 ) in Source ( MSOLAP$LocalCube ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. Errors in the metadata manager. The configuration property updates were not persisted. Internal error: An unexpected exception occured..

I am going to have BI Studio reinstalled, to see if that fixes the error. I am curious if anyone else has had/heard of this issue?

Thanks,
C

Hello. Here is a blog post that might help.

http://geekswithblogs.net/darrengosbell/archive/2006/11/17/97367.aspx

I am running Office 2007 with SQL Server 2005 SP2 CTP3(december). I never uninstalled the Office 2003 web components when I upgraded to Office 2007. This mix works without any problems.

HTH

Thomas Ivarsson

|||Thanks,
We are getting the hotfix from MS to give it a go. I will certainly post the results.

C|||

Hi

I got the same problem after installing MS Excel 2007 with the option to remove Excel 2003. I reinstalled Excel 2003 again later for testing purposes.

Chris, you never posted the results of the hotfix so I suppose that it worked!

Problem is, which hotfix did you use and where did you get it?

Thomas the link that you've supplied doesn't work ...

Thanks

Kobus

|||

Hi

Sorry Thomas, your link worked the second time around. Our Service Provider is experiencing problems with our connection so now we are on the backup ISDN line, we don't have T1 in South Africa like you guys in the US. The page may have timed out.

Info on the hotfix is here:
http://support.microsoft.com/default.aspx/kb/926421

More info on the workaround here:
http://sqlug.be/forums/339/ShowThread.aspx#339

You have to contact MS for the hotfix. SQL Server 2005 SP2 will solve the problem and since our company has that, that's the way I'll go.

Word Out
Kobus

|||Sorry Kobus,

You're right, i didn't post my results..

After applying the hotfix, i still ended up having to copy some DLL's around, as per your second link.

After i did that, it worked fine. But then i had some other software installed (i can't remember what it is right now) and it reverted the DLL's, so i had to re-copy them back so they were all the same version again.

Regardless, it should be ok if you install the hotfix, and make sure all the DLL's in those locations are the same version.

C

Broken BI Studio after Office 2k7 install

After an install of Office 2k7 last night, I'm getting some errors in my event log when i run BI Studio. The errors occur when i click a tab that tries to browse the metadata of the cube. IE: The calculations tab, or KPI's, etc..

These are the 2 errors:

Event Type: Error
Event Source: MSOLAP$LocalCube
Event Category: (289)
Event ID: 1
Date: 1/09/07
Time: 8:54:08 AM
User: N/A
Computer: WS124
Description:
The description for Event ID ( 1 ) in Source ( MSOLAP$LocalCube ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Message-handling subsystem: The message manager for the 4105 locale cannot be found..

Event Type: Error
Event Source: MSOLAP$LocalCube
Event Category: (289)
Event ID: 0
Date: 1/09/07
Time: 8:54:08 AM
User: N/A
Computer: WS124
Description:
The description for Event ID ( 0 ) in Source ( MSOLAP$LocalCube ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. Errors in the metadata manager. The configuration property updates were not persisted. Internal error: An unexpected exception occured..

I am going to have BI Studio reinstalled, to see if that fixes the error. I am curious if anyone else has had/heard of this issue?

Thanks,
C

Hello. Here is a blog post that might help.

http://geekswithblogs.net/darrengosbell/archive/2006/11/17/97367.aspx

I am running Office 2007 with SQL Server 2005 SP2 CTP3(december). I never uninstalled the Office 2003 web components when I upgraded to Office 2007. This mix works without any problems.

HTH

Thomas Ivarsson

|||Thanks,
We are getting the hotfix from MS to give it a go. I will certainly post the results.

C|||

Hi

I got the same problem after installing MS Excel 2007 with the option to remove Excel 2003. I reinstalled Excel 2003 again later for testing purposes.

Chris, you never posted the results of the hotfix so I suppose that it worked!

Problem is, which hotfix did you use and where did you get it?

Thomas the link that you've supplied doesn't work ...

Thanks

Kobus

|||

Hi

Sorry Thomas, your link worked the second time around. Our Service Provider is experiencing problems with our connection so now we are on the backup ISDN line, we don't have T1 in South Africa like you guys in the US. The page may have timed out.

Info on the hotfix is here:
http://support.microsoft.com/default.aspx/kb/926421

More info on the workaround here:
http://sqlug.be/forums/339/ShowThread.aspx#339

You have to contact MS for the hotfix. SQL Server 2005 SP2 will solve the problem and since our company has that, that's the way I'll go.

Word Out
Kobus

|||Sorry Kobus,

You're right, i didn't post my results..

After applying the hotfix, i still ended up having to copy some DLL's around, as per your second link.

After i did that, it worked fine. But then i had some other software installed (i can't remember what it is right now) and it reverted the DLL's, so i had to re-copy them back so they were all the same version again.

Regardless, it should be ok if you install the hotfix, and make sure all the DLL's in those locations are the same version.

C

brain teaser - stagger the order of the results

This one has been stumping me for several days. I can run a query that
returns several different items from several different manufacturers,
each with a ranking score. Each manufacturer can have any number of
items:

Item_Name Manufacturer rank
Item 1 Manu_A 82
Item 2 Manu_A 65
Item 3 Manu_A 41
Item 4 Manu_B 32
Item 5 Manu_C 21
Item 6 Manu_B 19

However, I would like the records to be ordered so that the highest
ranking item is shown first, then the next highest item from a
different manufacturer is shown second, then the next highest item from
a third manufacturer is show, etc.:

Item 1 Manu_A 82
Item 4 Manu_B 32
Item 5 Manu_C 21
Item 2 Manu_A 65
Item 6 Manu_B 19
Item 3 Manu_A 41

Does anyone have any thoughts on how to order the results in this
fashion?

thanks,

Matt WeinerIt would be useful to see how you compute the Rank value. Perhaps your
result is possible by adapting your existing query. From what you've
given us, try this:

SELECT T1.item_name, T1.manufacturer, T1.rank
FROM (/* Your query */) AS T1
JOIN (/* Your query */) AS T2
ON T1.manufacturer = T2.manufacturer
AND T1.rank <= T2.rank
GROUP BY T1.item_name, T1.manufacturer, T1.rank
ORDER BY COUNT(*), T1.rank DESC

Just substitute your query or a view that contains it after the FROM
and JOIN.

--
David Portas
SQL Server MVP
--|||thanks. It works great. I appreciate the help.

Matt

BPA Install Problem

I'm installing the latest version of BPA and seem to have run into an issue.
I've uninstalled the app and deleted the old BPA database, and while
reinstalling, I'm seeing an error message come up. "One or more rules could
not be installed. There is an error in XML document (55, 15). Invalid SQL
Server edition."
I'm running everything locally, and running SQL 2k, SP3 on WinXP SP1
Where can I start to look to debug this problem?
Steve
Please uninstall and reinstall, but before reinstalling make sure that the
destination folder is empty. At the very least you should make sure that
bpadmin.exe.config file doesn not exist, and that no files or folders are
left under repository folder.
Let me know if that doesn't work.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Steve Carroll" <steve_carroll72@.h_o_t_m_a_i_l.com> wrote in message
news:uELb%23aYTEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I'm installing the latest version of BPA and seem to have run into an
issue.
> I've uninstalled the app and deleted the old BPA database, and while
> reinstalling, I'm seeing an error message come up. "One or more rules
could
> not be installed. There is an error in XML document (55, 15). Invalid
SQL
> Server edition."
> I'm running everything locally, and running SQL 2k, SP3 on WinXP SP1
> Where can I start to look to debug this problem?
>
|||Well,
Its apparent that I'm a database guy and not an application guy!
That worked like a charm. Thanks!
BTW... great app!
-Steve
"Christian Kleinerman [MS]" <ckleiner@.online.microsoft.com> wrote in message
news:e870CqYTEHA.2324@.TK2MSFTNGP10.phx.gbl...
> Steve
> Please uninstall and reinstall, but before reinstalling make sure that the
> destination folder is empty. At the very least you should make sure that
> bpadmin.exe.config file doesn not exist, and that no files or folders are
> left under repository folder.
> Let me know if that doesn't work.
> - Christian
> --
> ___________________________
> Christian Kleinerman
> Program Manager, SQL Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Steve Carroll" <steve_carroll72@.h_o_t_m_a_i_l.com> wrote in message
> news:uELb%23aYTEHA.2908@.TK2MSFTNGP10.phx.gbl...
> issue.
> could
> SQL
>

Both versions of SQL Server on one server

Can I install SQL Server 7.0 SP2 as a Default version and
SQL Server 2000 SP3 as a named version on a WIndows 2000
SP3 server ?
We will run Connect-Care (Customer-First) Application
against SQL Server 7.0 version and Solomon 5.5 against SQL
Server 2000 version.
Anybody see any problem with this ?
Thanks for any help.
Rick,
Yep, should work fine. I have found it preferable to install SQL Server
7.0 first, then install SQL 2000 as a named instance. Remember to
configure your memory settings so that they aren't competing with each
other for RAM.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Rick wrote:
> Can I install SQL Server 7.0 SP2 as a Default version and
> SQL Server 2000 SP3 as a named version on a WIndows 2000
> SP3 server ?
> We will run Connect-Care (Customer-First) Application
> against SQL Server 7.0 version and Solomon 5.5 against SQL
> Server 2000 version.
> Anybody see any problem with this ?
> Thanks for any help.
|||I hope that installing service packs should not be a
problem....

>--Original Message--
>Rick,
>Yep, should work fine. I have found it preferable to
install SQL Server
>7.0 first, then install SQL 2000 as a named instance.
Remember to
>configure your memory settings so that they aren't
competing with each[vbcol=seagreen]
>other for RAM.
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602m.html
>
>Rick wrote:
and[vbcol=seagreen]
2000[vbcol=seagreen]
SQL
>.
>
|||Rick,
No problem! You can even have two instances of SQL Server 2000 running
at different service pack levels. (Not that you'd want to though).
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Rick wrote:[vbcol=seagreen]
> I hope that installing service packs should not be a
> problem....
>
>
> install SQL Server
>
> Remember to
>
> competing with each
>
> and
>
> 2000
>
> SQL