Microsoft SQL 6.5

I need to refresh data from a SQL 6.5 environment for QA purposes (hopefully generic solution should work for 7 & 2K). I need to select blocks of data in demand or in an automated fashion.
I would like to know the experiences of anyone who has done this.The SQL commands DUMP and RESTORE work well.

-PatP|||I don't think you can RESTORE on 7.0/2K from a dump device created on 6.5

Use a combination of BCP...OUT/BULK INSERT preceeded by either DELETE or TRUNCATE on the target.|||Minor brain fart there... In 6.5 it ought to be DUMP and LOAD. The use of BACKUP and RESTORE didn't start until 7.0.

rdjabarov raises a good point though, in that BCP could be used with all three platforms (assuming you are using the BCP that ships with SQL-2000). A bit of script for OSQL and some BCP action, and you could be in business!

-PatP

Microsoft Reporting Services - Error - Expects Parameter - Stored Procedure

Solution:
This happens to me quite a bit...its because the designer removes the
code that defines what
values are passed to your stored procedure.
You have to select the report you're working on > Right-Click 'Code' >
Locate the <Query> XML tag...and you'll have to re-define the
<QueryParameters>.
<Query>
<DataSourceName>GPS</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>spLRGetLeadRotationSummary</CommandText>
<QueryParameters>
<QueryParameter Name="@.StartDate">
<Value>=Parameters!StartDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@.EndDate">
<Value>=Parameters!EndDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@.RegionID">
<Value>=Parameters!RegionID.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>You can also do this by clicking on the ..., parameters tab. Modifying the
xml is dangerous. Although if you have a lot of query parameters and RS
keeps losing it then I have sometimes saved the section off so I could copy
it back in.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<petejk@.gmail.com> wrote in message
news:1135124852.986963.63390@.f14g2000cwb.googlegroups.com...
> Solution:
> This happens to me quite a bit...its because the designer removes the
> code that defines what
> values are passed to your stored procedure.
> You have to select the report you're working on > Right-Click 'Code' >
> Locate the <Query> XML tag...and you'll have to re-define the
> <QueryParameters>.
>
> <Query>
> <DataSourceName>GPS</DataSourceName>
> <CommandType>StoredProcedure</CommandType>
> <CommandText>spLRGetLeadRotationSummary</CommandText>
> <QueryParameters>
> <QueryParameter Name="@.StartDate">
> <Value>=Parameters!StartDate.Value</Value>
> </QueryParameter>
> <QueryParameter Name="@.EndDate">
> <Value>=Parameters!EndDate.Value</Value>
> </QueryParameter>
> <QueryParameter Name="@.RegionID">
> <Value>=Parameters!RegionID.Value</Value>
> </QueryParameter>
> </QueryParameters>
> </Query>
>

Microsoft Analysis Services on the web problem

Hi All!

We are trying to implement a web solution which include some OLAP cubes. We are using the followings applications and components:

Server: Windows 2000 - Microsoft Internet Information Server - SQL Server 2000 - Microsoft Analysis Services

Client: Active X Cube Browser included with Office 2000 - Pivot Table Services

For access the cubes, we developed an ASP which includes the Active X, and connect to the Analysis Services server. If i access this web page from the server, i can view the cube, and use it without any problem, but if i try to access the cube accross internet, i am having the following problem:

"The operation requested failed due to security problems - the user could not be authenticated"

If you have any idea or suggestion about this problem, let me know.
Thanks!

IgnacioIt depends on the secuity mode you are using with SQL server most sane people wont let NT authentication through their firewall which leaves SQL logins only.

Try setting up the accounts to use SQL only authentication & see how you go.

Post back if probs

J.|||Thanks for your advice, but we already solve the problem.

We need to install SQL Server 2000 Enterprise Edition, because it has http connection and it works.

Thanks again,

Ignacio|||HII
Can u tell me what was the permissions in the cube.

1) if the cube gave has access to everyone . How did u restrict people on the network to access the cube.
2) if it was specific domain users. How did u manage to propagate security of a user accessing from the page.

Regds
Ram

Originally posted by isbampato
Thanks for your advice, but we already solve the problem.

We need to install SQL Server 2000 Enterprise Edition, because it has http connection and it works.

Thanks again,

Ignacio|||Ram,

we didn't configure a secure environment yet, because the cubes were prepared only for a demo in our intranet. We have created a test database, and a test set of cubes, and added a new user only for use in this test environment, and with full control over it.

Besides, we added basic web authentication to the web page with the online cubes.

We didn't analyze yet how to secure this because it's still at a test phase.

Best regards,

Ignacio

messages.sql error during upgrade

I found the solution to this on Microsoft's site.
http://support.microsoft.com/?scid=kb;en-us;Q300676
But I can't download the file s80305i.exe , can anyone send me this file
please ?
Thank you,
FulyaHi Funda,
I tried to send it to your e-mail account with removing nospam stuff from yo
ur e-mail address.
Hope you'll get it..
Umut Nazl?ca, (MCSE 2000/NT; MCDBA; MCSA; MCP+I)|||Thank you so much but it didn't pass our spam filter. If I give you an ftp ,
can you please put it there'
Fulya
"Umut Nazlica" <anonymous@.discussions.microsoft.com> wrote in message
news:4A4F6755-768F-4079-ADAE-E8DF09449BB5@.microsoft.com...
> Hi Funda,
> I tried to send it to your e-mail account with removing nospam stuff from
your e-mail address.
> Hope you'll get it..
> Umut Nazlica, (MCSE 2000/NT; MCDBA; MCSA; MCP+I)
>|||It didn't pass our spam filter.You can send it also to the following
address;
fulyaerol888@.hotmail.com
Thank you.
Fulya
"Umut Nazlica" <anonymous@.discussions.microsoft.com> wrote in message
news:4A4F6755-768F-4079-ADAE-E8DF09449BB5@.microsoft.com...
> Hi Funda,
> I tried to send it to your e-mail account with removing nospam stuff from
your e-mail address.
> Hope you'll get it..
> Umut Nazlica, (MCSE 2000/NT; MCDBA; MCSA; MCP+I)
>|||Hi,
i send it to your hotmail account..|||Hi Umut,
I couldn't receive it also at my hotmail account. I need that file badly.
can you please send it to my ftp account? I would appreciate it so much.Can
you please send me your email address so that I can send you the ftp info?
Thank you.
Fulya
"Umut Nazlica" <anonymous@.discussions.microsoft.com> wrote in message
news:38C89CCE-2937-4B28-BCE2-E8A0CE413867@.microsoft.com...
> Hi,
> i send it to your hotmail account..
>|||Hi,
I wasn't at my desk for a while.
You can send your ftp info to umutn@.hotmail.com (if you're still looking for
the file.)