Does anybody know where I can download the samples ? What I mean is not the Northwind or pubs database but samples that are usually installed in "C:Program FilesMicrosoft SQL Server90Samples" directory; I am missing them.
Thanks
I went to install SQL 2005 and did not have sufficient memory, I registered prior to the download, will i still be able to down load it after nov 7 and after i buy more memory ( there is no iso file to save )
Thanks
Ray
Dear all
Where can I download Sql Server Books Online for any versions of 6.5 or 6.0 or 4.
thanks
Hi, Just a quick note for all that the SSIS team has started to post fresh content for download.
We will be adding some links to various pages so you can easily see things when looking at the the SSIS portal on MSDN http://msdn.microsoft.com/SQL/bi/integration/default.aspx
For now if you search for "ssis" on the microsoft downloads site you will find the current content. Sample Logging reports, jump start training, Meta Data info, and sample components. More coming over the next few weeks...
http://www.microsoft.com/downloads/search.aspx?displaylang=en
Thank you and I hope everyone enjoys winding down 2005, or blowing it out, depending on your likes :)
SSIS team
I have a Package that downloads apprx 15 data archives from an FTP site using FTP Tasks.
My problem is that the data contained within these archives (.Z) are becoming corrupt after download/extracting. I have isolated the problem to the FTP File Task by manually downloading the archives myself from IE's built-in FTP client and disabling the downloads in the Control Flow. The Control Flow will then execute the extracting script and continue without any problems.
If I run the Package with the FTP Tasks enabled it will get to a random spot in the validation (I haven't been able to see any consistency with where it errors) of the flat files and error with either a truncation error or a (don't remember exactly what it was) error that talks about an unexpected end in the file. I believe this is because the data has become corrupt and has started skipping/excluding columns. I have opened the flat file and examined it, and sure enough, the data at the end seems to just end.
I have tried setting the FTP Connection to Use Passive Mode in the config file - doesn't work.
So, my question is: Has anyone encountered similar problems? If so, what did you do to fix the problem? I'd really like to use the FTP Task rather than reinventing it with a custom script.
When attempting to use the FTP task to download a file from a Mainframe system the task fails stating the filename as invalid because it doesn't begin with a "/".
Adding the slash to the front of the file name causes the mainframe to be unable to locate the file.
Commandline version of FTP.exe mimicks this behavior by working perfectly when the filename has no slash, and being unable to find the file when the slash is present.
Why does microsoft force a filename to start with a "/" and is there a way to make SSIS skip the validation phase for the FTP task?
1. The download links shown below for the Starter Kits found at this URL do not work:
http://msdn2.microsoft.com/en-us/express/aa718396.aspx
Teacher Starter Kit
VB http://msdn.microsoft.com/vstudio/eula.aspx?id=4d31bb50-22da-411f-b747-a7b2288fc720
C# http://msdn.microsoft.com/vstudio/eula.aspx?id=06b20449-cbba-4f2f-ab8c-b99c1266cc7e
Collection Manager Starter Kit
http://msdn.microsoft.com/vstudio/eula.aspx?id=98c8074d-d28e-49e1-be44-94f0114f372a
Club Web Site EventCalendar control source code
http://www.asp.net/starterkits/downloads/eventcalendar.zip
2. None of the download links shown below for the Sample Applications found at this URL work:
http://msdn2.microsoft.com/en-us/express/bb403187.aspx
Internet Explorer Favorites Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=3bdccf1b-88c6-45a6-9dcf-7499ad664dab
Skills Manager Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=09305c92-890f-4dc7-a20d-f58b611d23c7
Survey Manager Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=98171070-e0f6-4fcd-948e-9c5af497ab4f
Help Desk Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=009e3b2d-98b1-46dc-8476-676a2519eafa
Reports for Web Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=79610b4f-fc7e-4ca8-9ae2-8ca8a5a6de0d
Reports for Windows Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=9c9a8d75-58b1-4be7-91be-50fefbe5d28c
Are there any really good pocket pc database samples that I can get access to using VB?
View 1 Replies View RelatedHello,
I am a total beginner to SQL and I'm unable to load the samples. I downloaded the .msi file and installed it but I don't know where to go from here.
Am I importing one of the samples in SQL or do I open them in Visual Basic?
The samples folder has several sub-folders with no executable so I don't know where to begin.
Can someone point me in the right direction?
thanks in advance.
Chris
Hi guys,
I am about 1 day old when it comes to undertanding stored procedures so I'm at your mercy for a kick start once again :)
For my next trick I shall be attempting to create a stored procedure that will accept a whole bunch of paramaters but will not work until one paramater is tested against the database. I have no idea how to do "If/then/else" style code in a stored procedure even though I was reading up on Drop_Procedure.
I want to pass in nickname, fullname, address but if nickname already exists then return appropriate error otherwise return success symbol (maybe new rowid or num records affected).
If Not exists nickname in MyTable then
Insert nickname, fullname, address
Return Success
else
return error "Nick name already exists"
End if
The second part my problem is how do I handle this in ASP.NET? I can call a stored procedure with paramaters and collect the return value but how do I deal with errors?
Any tips on sites for Sql Server as good as www.ASP.net would also help me out.
Thank you.
Ray Brennan.
Dublin, Ireland.
I still can not get the samples databases installed. I am tring to following step 3 from
Ten Things
You Need To Know To Get Started with SQL Server 2005 Sampleswhich is
3 €“ To install the samples and sample databases
from the SQL Server 2005 Setup, you need to click the Advanced button on the Components to Install page, then expand
Books Online and Samples and select Samples. This only installs the
Samples MSI on your machine. To complete the installation, you need to
run the Samples MSI. You can do this from the Start menu: click All
Programs, click Microsoft SQL Server 2005, click Documentation and Tutorials,
click Samples, and then click Microsoft SQL Server 2005 Samples.
By copying the SQLEXPR.EXE to the directory containing the SQL .exe I can get to "SQL Server 2005 Express Setup" (note it is not SQL Server 2005 Setup) using CHANGE from ADD/REMOVE programs; however, there is no Advanced button so I can't complete step three.
All the databases and tuturials seem to be in the right directories. I have explored SSME and the config utility and do not see anyway to do this using them.
Has anyone installed and used the sample databases?
Thanks,
R
I am trying to run the Readme_HelloWorld sample on the SQL server 2005 Books online. But don't know where I can get the setup.sql, SendMessage.sql, ReceiveMessage.sql scripts.
I followed two examples on the blog, but they did not work at all. Here are the scripts:
/* example 1 */
create database TestSB
go
use TestSB
go
create queue TxQ
create queue RxQ
create message type Msg
create contract MsgContract(Msg SENT BY ANY)
create service TxSve on Queue TxQ
Create service RxSve on Queue RxQ
declare @h uniqueidentifier
begin dialog conversation @h
from service TxSve to Service 'RxSve'
on contract MsgContract;
send on conversation @h Message type Msg ('<hello>World</hello>')
end conversation @h with CLEANUP;
select *
from RxQ
/* example 2 */
use testsb
go
create message type HelloMessage
validation = NONE
go
/** 2. create contract **/
create contract HelloContract
(HelloMessage SENT by initiator)
/** 3. create queue **/
create queue SenderQueue
create queue ReceiverQueue
/** 4. create service **/
create service sender
on queue SenderQueue
create service receiver
on queue ReceiverQueue(HelloContract)
declare @handle uniqueidentifier
declare @message nvarchar(100)
begin
begin transaction;
begin dialog conversation @handle
from service sender
to service 'receiver'
on contract HelloContract
set @message = N'Hello, World';
send on conversation @handle
message type HelloMessage(@message)
end conversation @handle
commit transaction
end
go
Receive convert(nvarchar(max), message_body) as message1
from ReceiverQueue
select convert(nvarchar(max), message_body) as message1
from ReceiverQueue
select *
from SenderQueue
select *
from Receiverqueue
Any assistance or WORKING samples are greatly appreciated.
I have installed SQL Server 2005 on Windows Server 2003 Standard SP1. THe SAMPLES folder within the C:/Program Files/Microsoft SQL Server/90 folder is missing. I installed SQL Server 2005 SP2 thinking that this might create the SAMPLES folder, but it didn't get created.
Please let me know what should I do to create it. Thanks in advance.
My current query has the following fields.:
Analyte, Sample, Result, MDL, SRL
The query results currently look like this.
Benzene, 01, 3.50, 2.00, 2.1
Benzene, 02, 2.34, 1.99, 2.1
Benzene, 03, 5.34, 1.99, 2.1
Carbon, 01, 4.20, 2.00, 1.1
Chloroform, 02, 3.1, 2.09, 1.8
Chloroform, 03, 9.1, 7.09, 1.8
Carbon, 03, 5.20, 1.00, 2.1
Chloroform, 01, 6.1, 2.09, 1.8
Ultimately, the above query will need to be exported to Excel using VB and I looked at pivot tables, but no result will allow me to generate a query in the following fashion.
Analyte, Sample1, Result, MDL SRL Sample2,Result, MDL SRL Sample3,Result, MDL SRL
Benzene, 01, 3.50, 2.00, 2.1 02, 2.34, 1.99, 2.1 03, 5.34, 1.99, 2.1
Carbon, 01, 4.20, 2.00, 1.1 03, 5.20, 1.00, 2.1
Chloroform 01, 6.1, 2.09, 1.8 02, 3.1, 2.09, 1.8 03, 9.1, 7.09, 1.8
The analyte needs to be listed only once, and if there are results, they will need to be displayed from left to right since the analyte will be listed just on a row, the number of samples go from left to right. Please note, I have no way of knowing how many samples will be listed it could be 3 or 20. Thanks kindly for your help on this, I have worked on it for a week already and looked at doing it from VB, but that got more complicated than it needs to be.
Hi every body!
I'm doing a topic about "Merge raplication". But i can't find a sample script in : C:Microsoft SQL Server80ToolsDevtoolsSamplessqlrepldeflt_sp
If anybody has it, please sent it to me! Please!
Thanks a lot!
My enail: vinhphuocptit@gmail.com
Hi All,
I have installed SQL 2005, but there is not a,
Integration Services Samples.
The SQL 2005 manuals says:
"By default, the Integration Services samples are installed onto the local hard disk drive in the following folder: C:Program FilesMicrosoft SQL Server90Samples"
But there is not "Samples" dir inder C:Program FilesMicrosoft SQL Server90
Where I could get the samples ?
Sergiy
the book "microsoft sql server 2005 integration services" by kirk haselden claims you can download examples and source code at www.samspublishing.com
er no
what happens is this
go to the site
look for the 'downloads' link
see there isn't one
search for authors
h etc.... lose a few minutes of your life
find the book
yay
it forces you to sign up for an account in order to get the samples - outrageous
prepare for endless spam from sams
sign up
click on download samples
find the configedit folder
load into vs
run it
it doesn't work!!
thanks
Warning 1 The referenced component 'SourceLibrary' could not be found.
Warning 2 The referenced component 'SourceGrid2' could not be found.
Error 3 Unable to find source file 'K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigurationsEditorinDebugConfigurationsEditor.exe' for assembly 'ConfigurationsEditor.exe', located in '[TARGETDIR]' K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditSetupConfigEditSetupConfigEdit.vdproj SetupConfigEdit
Error 4 The type or namespace name 'SourceGrid2' could not be found (are you missing a using directive or an assembly reference?) K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigEditControlConfigEdit.cs 9 7 ConfigEdit
Error 5 The type or namespace name 'SourceGrid2' could not be found (are you missing a using directive or an assembly reference?) K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigEditControlConfigEdit.cs 10 7 ConfigEdit
Error 6 The type or namespace name 'SourceGrid2' could not be found (are you missing a using directive or an assembly reference?) K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigEditControlConfigEdit.cs 87 40 ConfigEdit
Error 7 The type or namespace name 'SourceGrid2' could not be found (are you missing a using directive or an assembly reference?) K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigEditControlConfigEdit.cs 11 15 ConfigEdit
Error 8 The type or namespace name 'SourceGrid2' could not be found (are you missing a using directive or an assembly reference?) K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigEditControlConfigEdit.cs 24 17 ConfigEdit
Error 9 The type or namespace name 'SourceGrid2' could not be found (are you missing a using directive or an assembly reference?) K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigEditControlConfigEdit.cs 25 11 ConfigEdit
Error 10 The type or namespace name 'SourceGrid2' could not be found (are you missing a using directive or an assembly reference?) K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigEditControlConfigEdit.Designer.cs 318 17 ConfigEdit
Error 11 Metadata file 'K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigEditControlinDebugConfigEdit.dll' could not be found ConfigurationsEditor
Warning 12 Could not resolve this reference. Could not locate the assembly "SourceGrid2". Check to make sure the assembly exists on disk. If this reference is required by your code, you may get compilation errors. ConfigEdit
Warning 13 Could not resolve this reference. Could not locate the assembly "SourceLibrary". Check to make sure the assembly exists on disk. If this reference is required by your code, you may get compilation errors. ConfigEdit
one could argue that ssis should have a config editor supplied with it, instead of having to go into notepad
Hi,
I'm looking for the sample application : IBuySpy Delivery Sample Application (SQL Server Compact). But I could not find this sample file anywhere.
The only sample which is available in my local directory below is Northwind.sdf file
C:Program FilesMicrosoft SQL Server Compact Editionv3.5Samples
The link in the Book Online is pointing to this URL below :
http://www.microsoft.com/downloads/details.aspx?FamilyID=1ff0529a-eb1f-4044-b4b7-40b00710f7b7&displaylang=en
Can anyone help me on this?
Thanks,
I have installed the documentation and samples and the management studio for sql 2005 express edition, but when trying to work through the samples, I get this error message, for some reason I can't include the Adventure works db. Whatn I'm I not doing right? Please can someone help!
1> SELECT name from sys.databases
2> Go
name
--------------------------------------------------------------------------------
------------------------------------------------
master
tempdb
model
msdb
1> CREATE DATABASE [AdventureWorks] ON
2> (AdventureWorks = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData
< AdventureWorks>.mdf' ),
3> (AdventureWorks = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData
< AdventureWorks>.ldf' )
4> FOR ATTACH ;
5> GO
Msg 153, Level 15, State 1, Server YOUR-V7OY5L24PGSQLEXPRESS, Line 2
Invalid usage of the option AdventureWorks in the CREATE/ALTER DATABASE statemen
t.
1> USE [master]
2> GO
Changed database context to 'master'.
1> CREATE DATABASE [AdventureWorks] ON
2> (AdventureWorks = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData
< AdventureWorks>.mdf' ),
3> (AdventureWorks = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData
< AdventureWorks>.ldf' )
4> FOR ATTACH ;
5> GO
Msg 153, Level 15, State 1, Server YOUR-V7OY5L24PGSQLEXPRESS, Line 2
Invalid usage of the option AdventureWorks in the CREATE/ALTER DATABASE statemen
t.
1> select name from sys.databases
2> go
name
--------------------------------------------------------------------------------
------------------------------------------------
master
tempdb
model
msdb
(4 rows affected)
1>
There are five msi files listed for downloading.
SqlServerSamples.msi
AdventureWorksDB.msi
AdventureWorksDBCI.msi
AdventureWorksBI.msi
AdventureWorksBICI.msi
What are the AdventureWorksDBCI.ms and AdventureWorksBICI.msi used for? I try to run it, but it return the message "Another version of this product is already installed" and ask me remove the old version of this product. Anybody know what I should remove?
Thanks,
I would like to have more info on UserInstances concept of SQLExpress 2005.
Can i find any code samples for this feature in MSDN.
I have tried using the following links..
http://msdn2.microsoft.com/en-us/library/ms143401(SQL.90).aspx
http://msdn2.microsoft.com/en-us/library/ms143684(SQL.90).aspx
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sqlexpuserinst.asp
http://msdn2.microsoft.com/en-us/library/ms254504.aspx
http://msdn2.microsoft.com/en-us/library/ms165690(SQL.90).aspx
http://msdn2.microsoft.com/en-us/library/ms143446(SQL.90).aspx
any other links will be helpful for me in this regard.
Thanks,
Vaishu
Hi,I have installed the Sql server 2005 standerd edition to my computer
but i cant find this folder to view report service authentication samples ?
C:Program FilesMicrosoft SQL Server90Samples ?
but i can see C:Program FilesMicrosoft SQL Server90 folder !
any idea ?
sujithf
Edited by SomeNewKid. Please post code between <code> and </code> tags.
Right now i'm just trying to get the page to update SQL, but its not working no errors or anything but still not updating?!?!
Any ideas? Thanks in advance
Ben
<%
Dim cnnSimple ' ADO connection
Dim rstSimple ' ADO recordset
Set cnnSimple = Server.CreateObject("ADODB.Connection")
cnnSimple.Open Blah Blah Blah
Set rstSimple = cnnSimple.Execute("SELECT * FROM WK_DATA WHERE WEEK_NUM = 2")
%>
<input name="Submit" type="button" value="Add">
<%
If Request.Form("Submit") = "Add" Then
cnnSimple.Execute("UPDATE WK_DATA SET PRICE = (PRICE + 1) WHERE WEEK_NUM = 2")
rstSimple.update
End If
cnnSimple.Close
Set cnnSimple = Nothing
%>
Hi,
Do anybody have sample packages of how to use Import Column Transformation?
I couldn't make any sample package by going through the information present in the Microsoft site.
Can anybody help me out?
Thanks,
Sreekanth Ammisetty
ok, I've installed sql server, run the install samples and database, but when I go into SQL Server, the database and samples are not there. How do I connect the two?
thx,
Kat
Hi,
Can someone tell me where I can download the "SQL Server 2005 BI Metadata Samples toolkit"? Seems the old ulr doesn't work right now.
Thanks in advance.
Mike
Hi all
I am working as Production DBA (SLA based),I want Project matrix samples
Could you some body help me by sending Project matrix.
Any advice or Sample appreciated
Downloaded the file for the Adventure Works DB Sample. Which folder do I need to install it in to have show up in SQL Server Express 2005??
View 5 Replies View RelatedHi, i read article on how to install the AdventureWorks on my PC, basically i downloaded the sample db from microsoft website, but after i install several times, i seems cant get to see it in my sql server 2005, please assist on this, i have been craking head for this. Thanks :)
View 1 Replies View RelatedI downloaded the sample reports for report execution from http://technet.microsoft.com/en-us/library/ms161561.aspx
to display reporting services report execution data which worked fine until I'd written a report with multi-valued parameters. As soon as this was designed and more importantly run by an user the package used to create the reports crashed.
I've found out why it's breaking mainly through digging around in the script task where the package crashes and also through surfing the net and finding this
https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=967081&SiteID=1
thread. I've tried their fix but it still crashes unfortunately.
It seems like the issue is populating an array indexes in the script component in the update parameters data flow task. I think this was written to deal with minimal parameter requests, however I've recently written a multi-valued parameter report and it's made the string containing the parameter details has now hit the maximum length for the string. Changing the WSTR 4000 to a different size doesn't seem to have an effect, and the forum entry above doesn't hint at what the problem is apart from the script not being able to deal with the length.
The error I now get is as follows:
at MyComponent1.ScriptMain.Input0_ProcessInputRow(Input0Buffer Row) in dts://Scripts/MyComponent1/ScriptMain:line 35
at MyComponent1.UserComponent.Input0_ProcessInput(Input0Buffer Buffer) in dts://Scripts/MyComponent1/ComponentWrapper:line 68
at MyComponent1.UserComponent.ProcessInput(Int32 InputID, PipelineBuffer Buffer) in dts://Scripts/MyComponent1/ComponentWrapper:line 25
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)
Anyone have any ideas on how to fix this?
Today, I download SQL Server 2005 Business Intelligence Metadata Samples Toolkit from Microsoft download center, per readme.txt instructions, build the project, but there was an error as below:
Error 1 The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0
After then, I just build the project,but didn't deploy it, then I try to launch
DependencyAnalyzer console application, there was also an there:
Error occurred: A connection cannot be made. Ensure that the server is running.
Are you success on this Toolkit?
Thank you in advance.
I have been using the ServiceBrokerInterface example for a project of mine and so far it has been very successfull. However , I recently attempted to use it to send a large-ish message (32K xml file from MS Word) to SQL. The message is recieved but the Body member of the message is null when I try to retrieve the data from within my stored procedure CLR method.
The only differences I can see between the message that does not work and those that do are that the one that doesn't is large and it is XML data that I read from a .xml file produced by MS Word as opposed to internally generated strings in the other working messages.
Does anybody have any suggestions as to why the body of the message is not being sent in this case?
Is there something about the example code that precludes sending this type of message?
This is the code that sends the message (extracted from Conversation.cs in ServiceBrokerExample)
string query = "SEND ON CONVERSATION @ch MESSAGE TYPE @mt ";
param = cmd.Parameters.Add("@ch", SqlDbType.UniqueIdentifier);
param.Value = m_handle;
param = cmd.Parameters.Add("@mt", SqlDbType.NVarChar, 255);
param.Value = message.Type;
if (message.Body != null)
{
query += " (@msg)";
param = cmd.Parameters.Add("@msg", SqlDbType.VarBinary);
param.Value = new SqlBytes(message.Body);
param.Size = -1;
}
cmd.CommandText = query;
cmd.ExecuteNonQuery();
This is the code that reads the message from the SQL queue (extracted from Message.cs in ServiceBrokerExample)
m_reader = reader;
m_convGroupId = reader.GetGuid(0);
m_conv = new Conversation(service, reader.GetGuid(1));
m_sequenceNumber = reader.GetInt64(2);
m_serviceName = reader.GetString(3);
m_contractName = reader.GetString(4);
m_type = reader.GetString(5);
m_validation = reader.GetString(6);
if (!reader.IsDBNull(7))
{
SqlBytes sb = reader.GetSqlBytes(7);
Body = sb.Stream;
}
else
Body = null;
This is the MESSAGE TYPE used by this message.
CREATE MESSAGE TYPE CreateReport_Command VALIDATION = None;
Here is the code where msgReceived.Body == null in the SQL CLR method invoked by this message.
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Design", "CA1062:ValidateArgumentsOfPublicMethods"), System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Performance", "CA1822:MarkMembersAsStatic"), BrokerMethod("AssessmentContract", "CreateReport_Command")]
public void CreateReport_Command(
Message msgReceived,
SqlConnection connection,
SqlTransaction transaction)
{
StreamReader reader = null;
try
{
reader = new StreamReader(msgReceived.Body);
And finally here is the code snippet that creates the stream that gets loaded into the message to be sent.
if (Report != null && ReportName != null)
{
MemoryStream ReportBody = new MemoryStream();
if (ReportID == null)
{
ReportID = Guid.NewGuid().ToString();
}
ReportBody.Write(Encoding.ASCII.GetBytes(ReportID), 0, ReportID.Length);
ReportBody.Write(Encoding.ASCII.GetBytes("|".ToCharArray()), 0, 1);
ReportBody.Write(Encoding.ASCII.GetBytes(ReportName), 0, ReportName.Length);
ReportBody.Write(Encoding.ASCII.GetBytes("|".ToCharArray()), 0, 1);
ReportBody.Write(Encoding.ASCII.GetBytes(Report), 0, Report.Length);
Microsoft.Samples.SqlServer.Message request = new Microsoft.Samples.SqlServer.Message("CreateAssessmentReport_Command", ReportBody);
// Send the message to the service
dialog.Send(request, conn, tran);