"SQL: The Complete Reference" source?

I purchased a used copy of the SQL book listed in the subject but the
CD is missing. I have access to SQL Server 2000 and so don't need the
trial software but would like to get the source for the database used
in the examples. Does anyone know where I can get this?What's the name of the sample database used in the examples?
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"SteveH" <steve.holle@.gmail.com> wrote in message
news:1139507451.169408.5450@.f14g2000cwb.googlegroups.com...
>I purchased a used copy of the SQL book listed in the subject but the
> CD is missing. I have access to SQL Server 2000 and so don't need the
> trial software but would like to get the source for the database used
> in the examples. Does anyone know where I can get this?
>|||SteveH wrote:
> I purchased a used copy of the SQL book listed in the subject but the
> CD is missing. I have access to SQL Server 2000 and so don't need the
> trial software but would like to get the source for the database used
> in the examples. Does anyone know where I can get this?
Have you checked the publisher's web site. Many publishers post the
source code from books. Also, you might try the author's home page (if
you have it), which may have some information as well.
--
David Gugick - SQL Server MVP
Quest Software

"sql data source" updating

hello all,

I ran into a problem using the "sql data source updating " method. i'm using a form view with about 20 parameters that are bind to controls in the form view and 5 other parameters that i'm setting the value to in the "sql data source updating" method. Every thing updates find execept for the last 5 parameters that i'm setting the values to in the "sql data source updating" method. My store procedure(sp) updates and insert mulitple tables. For some UNKOWN reason the tables that uses the parameteres in the "sql data source updating " are inserting multple records when only 1 record should be inserted. Have anyone have this problem?

Hi,

Please check if the insert command in the stored procedure has been called several times. Also, is there any triggers fired after the insertion?

If that still doesn't work, please let us see the stored procedure and code for Updating event handler.

Also, if you're inserting a record into the database, I suppose you need to handle the SqlDataSource.Inserting event.

"Single Transaction" property of data source

I've got a monstrous beast of a report that has about 15 datasets. I've
figured the only way i can imporve performance is if I could somehow put some
of the parameterized data it pulls into a table that the other data queries
could reuse. (Is it possible to use a temp table? I would think not if the
queries are all in different sprocs). The only way I can see this happening
(from searching the newsgroups) is by making sure that everything is done as
a single transaction in the data source, but I can't find that property
anywhere?! Where do I set that property on the datasource, to do "single
transaction" pulls?
thanks a million if you can help me.
isamuMicrosoft MVPs are you there? I'd really really appreciate it if I could get
some help here. Thanks!
"isamu" wrote:
> I've got a monstrous beast of a report that has about 15 datasets. I've
> figured the only way i can imporve performance is if I could somehow put some
> of the parameterized data it pulls into a table that the other data queries
> could reuse. (Is it possible to use a temp table? I would think not if the
> queries are all in different sprocs). The only way I can see this happening
> (from searching the newsgroups) is by making sure that everything is done as
> a single transaction in the data source, but I can't find that property
> anywhere?! Where do I set that property on the datasource, to do "single
> transaction" pulls?
> thanks a million if you can help me.
> isamu|||bump.
"isamu" wrote:
> Microsoft MVPs are you there? I'd really really appreciate it if I could get
> some help here. Thanks!
> "isamu" wrote:
> > I've got a monstrous beast of a report that has about 15 datasets. I've
> > figured the only way i can imporve performance is if I could somehow put some
> > of the parameterized data it pulls into a table that the other data queries
> > could reuse. (Is it possible to use a temp table? I would think not if the
> > queries are all in different sprocs). The only way I can see this happening
> > (from searching the newsgroups) is by making sure that everything is done as
> > a single transaction in the data source, but I can't find that property
> > anywhere?! Where do I set that property on the datasource, to do "single
> > transaction" pulls?
> >
> > thanks a million if you can help me.
> >
> > isamu|||At the bottom of the Data Source dialog in report designer you will find a
checkbox "Use Single Transaction". This indicates the data sets that use
this data source should be executed in a single transaction. So, if all your
datasets use the same data source and you apply a single transaction - you
are almost there.
Although we don't guarantee a certain execution order across datasets of the
same data source (and it may change in future), you can assume at least for
RS2000 that the order of execution is the order of the <DataSet> elements as
defined in the RDL XML. Just try it.
Hope this helps,
Robert
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"isamu" <isamu@.discussions.microsoft.com> wrote in message
news:A4DF278F-A80A-42C0-A6D8-08B41D81F60F@.microsoft.com...
> bump.
> "isamu" wrote:
>> Microsoft MVPs are you there? I'd really really appreciate it if I could
>> get
>> some help here. Thanks!
>> "isamu" wrote:
>> > I've got a monstrous beast of a report that has about 15 datasets.
>> > I've
>> > figured the only way i can imporve performance is if I could somehow
>> > put some
>> > of the parameterized data it pulls into a table that the other data
>> > queries
>> > could reuse. (Is it possible to use a temp table? I would think not if
>> > the
>> > queries are all in different sprocs). The only way I can see this
>> > happening
>> > (from searching the newsgroups) is by making sure that everything is
>> > done as
>> > a single transaction in the data source, but I can't find that property
>> > anywhere?! Where do I set that property on the datasource, to do
>> > "single
>> > transaction" pulls?
>> >
>> > thanks a million if you can help me.
>> >
>> > isamu

"image/jpeg; charset=utf-8", which is not a valid MIMEType

I am trying to use an image with a "Web" source, the url points to an
aspx page on the same machine as the reporting server, this page
returns a jpeg image (a chart) created by some C# code. On the
"Layout" tab of VS.NET the image is displayed but when I switch to the
"Preview" tab I just get the dreaded Red X.
The following warnings are written to the Output window.
Images with external URL references will not display if the report is
published to a report server without an UnattendedExecutionAccount or
the target image(s) are not enabled for anonymous access.
The value of the MIMEType property for the image ?image1' is
"image/jpeg; charset=utf-8", which is not a valid MIMEType.
I have configured the UnattendedExecuionAccount (rsconfig -e...) and
the page which returns the image allows anonymous access but it
doesn't seem to make any difference. What I don't understand is the
message about the invalid MIMEType, the code which returns the image
sets the ContentType="image/jpeg".
Any help much appreciated.I began to get this error right after I installed "Office 2003 Pro".
Do you use MS Office 2003?
"Mark" wrote:
> I am trying to use an image with a "Web" source, the url points to an
> aspx page on the same machine as the reporting server, this page
> returns a jpeg image (a chart) created by some C# code. On the
> "Layout" tab of VS.NET the image is displayed but when I switch to the
> "Preview" tab I just get the dreaded Red X.
> The following warnings are written to the Output window.
> Images with external URL references will not display if the report is
> published to a report server without an UnattendedExecutionAccount or
> the target image(s) are not enabled for anonymous access.
> The value of the MIMEType property for the image â'image1' is
> "image/jpeg; charset=utf-8", which is not a valid MIMEType.
> I have configured the UnattendedExecuionAccount (rsconfig -e...) and
> the page which returns the image allows anonymous access but it
> doesn't seem to make any difference. What I don't understand is the
> message about the invalid MIMEType, the code which returns the image
> sets the ContentType="image/jpeg".
> Any help much appreciated.
>

"Data Source=%?SERVER%"... ?

Hi all...

I have a data source string being passed to a SqlConnection object in the format "Data Source=%?SERVER%[...]". Now, to me this kind of looks like an environment variable query, but I'm not sure (and I can't find any system environment variables with that name on the server. Can anyone tell me, specifically, what the "?" is for?

This project uses VS2005, C# 2.0

Thanks in advance.

It looks to me like it is meant to be a value that is prompted for. Where are you getting the connection string from?

|||

There's no prompting going on - that's just the value in the string. Here's a sample:

1string strCon ="Data Source=%?SERVER%;Initial Catalog=MyDatabase;Integrated Security=False;Persist Security Info=True;User ID=sa;Password=%?SAPWD%;Encrypt=False";2SqlConnection con =new SqlConnection(strCon);

Thanks again.|||Data Source is the name of your sqlserver instance. like connectionString="Data Source= MSHOME\SQLEXPRESS;Initial Catalog=....|||

Well if you don't know of any reason why that is there and you know the connection information put the connection string in the web.config and call it a day. :)

|||

Guess that's what I'm going to have to go with (web.config) :P

Was just hoping somebody knew if there was something along the lines of a search-&-replace-before-compile feature in VS2005...

Thanks

"Custom" Report Model Data Source?

Hello,
Is this a true statement: "The only Data Sources available to a Report Model
are SQL Server 2000, SQL Server 2005, and SQL Server Analysis Services 2005"?
I had read somewhere that there was going to be an ability to specify a
"custom" query processors so that you could use data sources in addition to
the items listed above.
Thanks!I don't think so...
Since you can use ADO.Net every supported DataRpovider should work with
it... at least in local reports
"brianpmccullough" <bmccullough11@.comcast.net> wrote in message
news:2A5B524A-176B-4BD2-ACC2-75C9C3DDB2DA@.microsoft.com...
> Hello,
> Is this a true statement: "The only Data Sources available to a Report
> Model
> are SQL Server 2000, SQL Server 2005, and SQL Server Analysis Services
> 2005"?
> I had read somewhere that there was going to be an ability to specify a
> "custom" query processors so that you could use data sources in addition
> to
> the items listed above.
> Thanks!
>