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

Microsft Development Environment - Missing Toolbox Items

Hi,
I had some problems with the MDE application used to create reporting services reports, and rectified the problem by running the program with the command switch /resetskippkgs. Since doing this, my toolbox has lost all the controls used to design a reporting services report (e.g. Matrix, Table, Image etc).
Anyone know how I can get these back? I've tried doing a repair on the installation of the application, but no joy.
Thanks.
SimonRight-click in the toolbox, choose Add/Remove Items, and click the Reset
button.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:F7117049-4270-49A4-A9D0-08CDAB6D70A9@.microsoft.com...
> Hi,
> I had some problems with the MDE application used to create reporting
services reports, and rectified the problem by running the program with the
command switch /resetskippkgs. Since doing this, my toolbox has lost all
the controls used to design a reporting services report (e.g. Matrix, Table,
Image etc).
> Anyone know how I can get these back? I've tried doing a repair on the
installation of the application, but no joy.
> Thanks.
> Simon

message box in reporting services

I have used this code pasted below to show message box in reports in Reporting services 2000.It works and pops up but only in development environment but not in production.I mean to say it works in Preview mode but when I have deployed the report it doesn't work.Doesn't even show any error message.

I don't know what would be the code and which assembly file should i Include. Any Ideas ......

Public Function FixDigits(ByVal s As string)
dim msg1 as string
msg1="Parameter is not a 20 digit number"
dim msg2 as string
msg2= "Parameter is not a number"

Dim title As String
title="Attention"
Dim style As MsgBoxStyle
Dim response As MsgBoxResult

style = MsgBoxStyle.OKONLY
if len(s)<>20 then
response = MsgBox(msg1, style, title)

elseif IsNumeric(s)=false then
response = MsgBox(msg2, style, title)

else
end if

End Function

It depends on the client you use to generate the reports. If it is an IDE (Visual Studio), the message box is displayed as it has VB runtime loaded on it. If it is a browser or a client application thru web services, it cannot be communicated to the client as they dont have VB runtime (it is available only on the report server).

Shyam

|||I guess that this is actually releated to another problem. The Messagebox command is executed on the server not on the client, so if the server and the client is one box (as in local development) you probably see the error message while after deploying the report to the report server you won′t see it.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||Thanks a lot .Now it makes sense to me .