3 triggers into one

Hi,
I want to synchronize some records in one destination table in a
SQL server from some records in 3 source tables in another SQL server.
Instead of building 3 triggers for each source table, how can I make one
trigger and work for 3? Thanks.
supernova,
You need three triggers, one on each source table. I'm not entirely sure
what you're trying to do, but if you're just moving data, then consider
DTS or an INSERT..SELECT statement.
What are you trying to do exactly? Three triggers might not be appropriate.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
supernova wrote:
> Hi,
> I want to synchronize some records in one destination table in a
> SQL server from some records in 3 source tables in another SQL server.
> Instead of building 3 triggers for each source table, how can I make one
> trigger and work for 3? Thanks.
>
|||Hi
I'm afraid you cannot do that or perhaps I did not understand you.
A trigger fires per UPDATE/DELETE/INSERT statement.
If you have a trigger on tableA for INSERT for example and the user did
perform INSERT statement into this table so you don't have a problem to
insert the new rows into another table by server.database.dbo.table.But you
said that you have three tables so how do you want to identify what's rows
to be inserted into a destination server if let me say an INSERT was
performed only on one table?
"supernova" <abc@.yahoo.com> wrote in message
news:%23UOibIh0EHA.424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I want to synchronize some records in one destination table in a
> SQL server from some records in 3 source tables in another SQL server.
> Instead of building 3 triggers for each source table, how can I make one
> trigger and work for 3? Thanks.
>
|||I read your question a little differently from the others, so my answer
differs also, but only slightly..
You would have to have a trigger of EACH of the three tables, but you do
not have to have 3 triggers on each table... You may consolidate the
insert,update, delete triggers for a single table into a single trigger..
A futher way to consolidate is to put common code for the 3 tables into a
stored procedure and have each of the 3 table's triggers call the stored
procedure... Since you can't pass the inserted, deleted tables, you'll have
to pass each row to the sp ( which is a pain.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"supernova" <abc@.yahoo.com> wrote in message
news:%23UOibIh0EHA.424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I want to synchronize some records in one destination table in a
> SQL server from some records in 3 source tables in another SQL server.
> Instead of building 3 triggers for each source table, how can I make one
> trigger and work for 3? Thanks.
>
|||To clarify my question, I want to build something like a view, a combination
fields from 3 tables, and a trigger based on the view for insert and update.
How can I implement this? Thanks.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OHt18di0EHA.1420@.TK2MSFTNGP10.phx.gbl...
>I read your question a little differently from the others, so my answer
> differs also, but only slightly..
> You would have to have a trigger of EACH of the three tables, but you do
> not have to have 3 triggers on each table... You may consolidate the
> insert,update, delete triggers for a single table into a single trigger..
> A futher way to consolidate is to put common code for the 3 tables into a
> stored procedure and have each of the 3 table's triggers call the stored
> procedure... Since you can't pass the inserted, deleted tables, you'll
> have
> to pass each row to the sp ( which is a pain.)
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "supernova" <abc@.yahoo.com> wrote in message
> news:%23UOibIh0EHA.424@.TK2MSFTNGP14.phx.gbl...
>

3 triggers into one

Hi,
I want to synchronize some records in one destination table in a
SQL server from some records in 3 source tables in another SQL server.
Instead of building 3 triggers for each source table, how can I make one
trigger and work for 3? Thanks.supernova,
You need three triggers, one on each source table. I'm not entirely sure
what you're trying to do, but if you're just moving data, then consider
DTS or an INSERT..SELECT statement.
What are you trying to do exactly? Three triggers might not be appropriate.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
supernova wrote:
> Hi,
> I want to synchronize some records in one destination table in a
> SQL server from some records in 3 source tables in another SQL server.
> Instead of building 3 triggers for each source table, how can I make one
> trigger and work for 3? Thanks.
>|||Hi
I'm afraid you cannot do that or perhaps I did not understand you.
A trigger fires per UPDATE/DELETE/INSERT statement.
If you have a trigger on tableA for INSERT for example and the user did
perform INSERT statement into this table so you don't have a problem to
insert the new rows into another table by server.database.dbo.table.But you
said that you have three tables so how do you want to identify what's rows
to be inserted into a destination server if let me say an INSERT was
performed only on one table?
"supernova" <abc@.yahoo.com> wrote in message
news:%23UOibIh0EHA.424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I want to synchronize some records in one destination table in a
> SQL server from some records in 3 source tables in another SQL server.
> Instead of building 3 triggers for each source table, how can I make one
> trigger and work for 3? Thanks.
>|||I read your question a little differently from the others, so my answer
differs also, but only slightly..
You would have to have a trigger of EACH of the three tables, but you do
not have to have 3 triggers on each table... You may consolidate the
insert,update, delete triggers for a single table into a single trigger..
A futher way to consolidate is to put common code for the 3 tables into a
stored procedure and have each of the 3 table's triggers call the stored
procedure... Since you can't pass the inserted, deleted tables, you'll have
to pass each row to the sp ( which is a pain.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"supernova" <abc@.yahoo.com> wrote in message
news:%23UOibIh0EHA.424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I want to synchronize some records in one destination table in a
> SQL server from some records in 3 source tables in another SQL server.
> Instead of building 3 triggers for each source table, how can I make one
> trigger and work for 3? Thanks.
>|||To clarify my question, I want to build something like a view, a combination
fields from 3 tables, and a trigger based on the view for insert and update.
How can I implement this? Thanks.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OHt18di0EHA.1420@.TK2MSFTNGP10.phx.gbl...
>I read your question a little differently from the others, so my answer
> differs also, but only slightly..
> You would have to have a trigger of EACH of the three tables, but you do
> not have to have 3 triggers on each table... You may consolidate the
> insert,update, delete triggers for a single table into a single trigger..
> A futher way to consolidate is to put common code for the 3 tables into a
> stored procedure and have each of the 3 table's triggers call the stored
> procedure... Since you can't pass the inserted, deleted tables, you'll
> have
> to pass each row to the sp ( which is a pain.)
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "supernova" <abc@.yahoo.com> wrote in message
> news:%23UOibIh0EHA.424@.TK2MSFTNGP14.phx.gbl...
>

3 triggers into one

Hi,
I want to synchronize some records in one destination table in a
SQL server from some records in 3 source tables in another SQL server.
Instead of building 3 triggers for each source table, how can I make one
trigger and work for 3? Thanks.supernova,
You need three triggers, one on each source table. I'm not entirely sure
what you're trying to do, but if you're just moving data, then consider
DTS or an INSERT..SELECT statement.
What are you trying to do exactly? Three triggers might not be appropriate.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
supernova wrote:
> Hi,
> I want to synchronize some records in one destination table in a
> SQL server from some records in 3 source tables in another SQL server.
> Instead of building 3 triggers for each source table, how can I make one
> trigger and work for 3? Thanks.
>|||Hi
I'm afraid you cannot do that or perhaps I did not understand you.
A trigger fires per UPDATE/DELETE/INSERT statement.
If you have a trigger on tableA for INSERT for example and the user did
perform INSERT statement into this table so you don't have a problem to
insert the new rows into another table by server.database.dbo.table.But you
said that you have three tables so how do you want to identify what's rows
to be inserted into a destination server if let me say an INSERT was
performed only on one table?
"supernova" <abc@.yahoo.com> wrote in message
news:%23UOibIh0EHA.424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I want to synchronize some records in one destination table in a
> SQL server from some records in 3 source tables in another SQL server.
> Instead of building 3 triggers for each source table, how can I make one
> trigger and work for 3? Thanks.
>|||I read your question a little differently from the others, so my answer
differs also, but only slightly..
You would have to have a trigger of EACH of the three tables, but you do
not have to have 3 triggers on each table... You may consolidate the
insert,update, delete triggers for a single table into a single trigger..
A futher way to consolidate is to put common code for the 3 tables into a
stored procedure and have each of the 3 table's triggers call the stored
procedure... Since you can't pass the inserted, deleted tables, you'll have
to pass each row to the sp ( which is a pain.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"supernova" <abc@.yahoo.com> wrote in message
news:%23UOibIh0EHA.424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I want to synchronize some records in one destination table in a
> SQL server from some records in 3 source tables in another SQL server.
> Instead of building 3 triggers for each source table, how can I make one
> trigger and work for 3? Thanks.
>|||To clarify my question, I want to build something like a view, a combination
fields from 3 tables, and a trigger based on the view for insert and update.
How can I implement this? Thanks.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OHt18di0EHA.1420@.TK2MSFTNGP10.phx.gbl...
>I read your question a little differently from the others, so my answer
> differs also, but only slightly..
> You would have to have a trigger of EACH of the three tables, but you do
> not have to have 3 triggers on each table... You may consolidate the
> insert,update, delete triggers for a single table into a single trigger..
> A futher way to consolidate is to put common code for the 3 tables into a
> stored procedure and have each of the 3 table's triggers call the stored
> procedure... Since you can't pass the inserted, deleted tables, you'll
> have
> to pass each row to the sp ( which is a pain.)
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "supernova" <abc@.yahoo.com> wrote in message
> news:%23UOibIh0EHA.424@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I want to synchronize some records in one destination table in
>> a
>> SQL server from some records in 3 source tables in another SQL server.
>> Instead of building 3 triggers for each source table, how can I make one
>> trigger and work for 3? Thanks.
>>
>

2-way txn replication

Hi,
I am trying to setup a 2-way txn replication from the source & destination
on SQL Server 2000 SP3.
is it possible to set up such replication (i.e 2-way) and how can i do that ?
tks & rdgs
Message posted via http://www.droptable.com
Yes , its possible. I thinks its queue update method in txn replication
have a look at
http://msdn2.microsoft.com/en-us/library/ms151718.aspx
http://www.sqljunkies.com/Article/DA...2E6506A47.scuk
You can get better idea at replication news group.
Regards
Amish
|||Yes. Depends upon what you want to do.
You can use merge, transactional with immediate updating subscriber,
transactional with queued updating subscribers, or bi-directional
transactional replication. BOL has LOTS of information on setting each of
these up.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"maxzsim via droptable.com" <u14644@.uwe> wrote in message
news:5998195cc01d6@.uwe...
> Hi,
> I am trying to setup a 2-way txn replication from the source & destination
> on SQL Server 2000 SP3.
> is it possible to set up such replication (i.e 2-way) and how can i do
> that ?
>
> tks & rdgs
> --
> Message posted via http://www.droptable.com

2-way txn replication

Hi,
I am trying to setup a 2-way txn replication from the source & destination
on SQL Server 2000 SP3.
is it possible to set up such replication (i.e 2-way) and how can i do that
?
tks & rdgs
Message posted via http://www.droptable.comYes , its possible. I thinks its queue update method in txn replication
have a look at
http://msdn2.microsoft.com/en-us/library/ms151718.aspx
http://www.sqljunkies.com/Article/D...82E6506A47.scuk
You can get better idea at replication news group.
Regards
Amish|||Yes. Depends upon what you want to do.
You can use merge, transactional with immediate updating subscriber,
transactional with queued updating subscribers, or bi-directional
transactional replication. BOL has LOTS of information on setting each of
these up.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"maxzsim via droptable.com" <u14644@.uwe> wrote in message
news:5998195cc01d6@.uwe...
> Hi,
> I am trying to setup a 2-way txn replication from the source & destination
> on SQL Server 2000 SP3.
> is it possible to set up such replication (i.e 2-way) and how can i do
> that ?
>
> tks & rdgs
> --
> Message posted via http://www.droptable.com

2-way txn replication

Hi,
I am trying to setup a 2-way txn replication from the source & destination
on SQL Server 2000 SP3.
is it possible to set up such replication (i.e 2-way) and how can i do that ?
tks & rdgs
--
Message posted via http://www.sqlmonster.comYes , its possible. I thinks its queue update method in txn replication
have a look at
http://msdn2.microsoft.com/en-us/library/ms151718.aspx
http://www.sqljunkies.com/Article/DA7CCBA2-4FEF-43B8-AC77-AD82E6506A47.scuk
You can get better idea at replication news group.
Regards
Amish|||Yes. Depends upon what you want to do.
You can use merge, transactional with immediate updating subscriber,
transactional with queued updating subscribers, or bi-directional
transactional replication. BOL has LOTS of information on setting each of
these up.
--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"maxzsim via SQLMonster.com" <u14644@.uwe> wrote in message
news:5998195cc01d6@.uwe...
> Hi,
> I am trying to setup a 2-way txn replication from the source & destination
> on SQL Server 2000 SP3.
> is it possible to set up such replication (i.e 2-way) and how can i do
> that ?
>
> tks & rdgs
> --
> Message posted via http://www.sqlmonster.com

2005/2005Express SQLOLEDB Provider problem

When creating a connection string in ADO (using Delphi7), I insert the provider like this:

Provider=SQLOLEDB;Data Source=.;Initial Catalog=master;Integrated Security=SSPI;User ID=sa;Password=masterkey

Now, when I try to run this on a SQL Server 2005 or SQL2005 Express database, it won't create the connection
unless I use the SQLNCLI provider.

Is there a way to force them to use the OLEDB provider?
I have MDAC2.8-SP1 installed.Try explicitly adding the server name

Provider=SQLOLEDB;Data Source=<Server Name>;Initial Catalog=master;Integrated Security=SSPI;User ID=sa;Password=masterkey

2005 SQL Reporting Service XML Data Source (WebService)

Does anyone know how to ensure a WebService/WebMethod needs to be serialized to ensure is compatible with Reporting Services' new XML Data Source when passing parameters to the report. I have had success on using the Report Server WebService
http://localhost/reportserver/reportservice2005.asmx
and using the Query designer to pass the SoapAction call
<Query><SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren</SoapAction></Query>
and associating the data set parameters to the Designer GUI parameters (which I may say is not documented well on BoL)

But when using ANY OTHER WEB SERVICE that needs parameters, the parameteres are not passed correctly to the WebMehtod, so I am thiking they are comming in the header or as an array instead of an actual item within the SOAP message.... To bad we can't do this in the Query Designer... it is actually SAD this was nto thought out as to be compatible with regular SOAP calls... too bad. Ideally we would use query like the one below, and replace the fixed values with a parameter as defined in the designer (i.e. /Reports = @.ItemParam & False as @.RecursiveParam )... maybe in Orca this can be done right! either thru SOAP

<?xml version="1.0" encoding="utf-16"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<ListChildren xmlns="http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices">
<Item>/</Item>
<Recursive>false</Recursive>
</ListChildren>
</soap:Body>
</soap:Envelope>

Or through whatever "standard' the <Query/> definition is made off!

<Query>
<SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren
</SoapAction>
<Parameter>
<Name>Item</Name>
<Value>/Reports</Value>
</Parameter>
<Parameter>
<Name>Recursive</Name>
<Value>False</Value>
</Parameter>
</Query>

Yes, the docs are very sketchy. And there may be bugs in the provider. But I can get some web services to work. I posted an example of one that does in my blog: http://blogs.msdn.com/bwelcker/archive/2005/11/13/492296.aspx.

|||Regretfully that web service returns data even if there are blanks in the parameters, so is not a real good exception to test this bug|||

I have been trying to get this to work as well. Like you I am having problems with the paramters. I was just wondering if you figured out the magic trick to get the report designer to pass the paramters. Thanks Shawn.

|||I've got Microsoft working on it! I have an incident in the Beta site and on BetaServices.com.
I will post here once they get this bug resolved...|||Thanks!

2005 SQL Reporting Service XML Data Source (WebService)

Does anyone know how to ensure a WebService/WebMethod needs to be serialized
to ensure is compatible with Reporting Services' new XML Data Source when
passing parameters to the report. I have had success on using the Report
Server WebService
http://localhost/reportserver/reportservice2005.asmx
and using the Query designer to pass the SoapAction call
<Query><SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren</SoapAction></Query>
and associating the data set parameters to the Designer GUI parameters
(which I may say is not documented well on BoL)
http://www.enGaugedTraining.com/Parameters.gif
But when using ANY OTHER WEB SERVICE that needs parameters, the parameteres
are not passed correctly to the WebMehtod, so I am thiking they are comming
in the header or as an array instead of an actual item within the SOAP
message... To bad we can't do this in the Query Designer... it is actually
SAD this was nto thought out as to be compatible with regular SOAP calls...
too bad. Ideally we would use query like the one below, and replace the fixed
values with a parameter as defined in the designer (i.e. /Reports = @.ItemParam & False as @.RecursiveParam )... maybe in Orca this can be done
right! either thru SOAP
<?xml version="1.0" encoding="utf-16"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<ListChildren
xmlns="http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices">
<Item>/</Item>
<Recursive>false</Recursive>
</ListChildren>
</soap:Body>
</soap:Envelope>
Or through whatever "standard' the <Query/> definition is made of!
<Query
<SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren
</SoapAction>
<Parameter>
<Name>Item</Name>
<Value>/Reports</Value>
</Parameter>
<Parameter>
<Name>Recursive</Name>
<Value>False</Value>
</Parameter>
</Query>I reported this issue in the early beta lifecycle but it seemed that it
wasn't fixed. I've tried a similar scenario recently with RTM and indeed,
the parameters are not passed. Strangely, if you trace the call, you will
see that the parameters are serialized as a part of the SOAP request but for
some reason they are dropped by the ASP.NET Web service runtime. I couldn't
find a workaround and reported the issue again.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"J. C." <J. C.@.discussions.microsoft.com> wrote in message
news:53FF7A94-1EC0-4EF3-8E45-5391B08F2779@.microsoft.com...
> Does anyone know how to ensure a WebService/WebMethod needs to be
> serialized
> to ensure is compatible with Reporting Services' new XML Data Source when
> passing parameters to the report. I have had success on using the Report
> Server WebService
> http://localhost/reportserver/reportservice2005.asmx
> and using the Query designer to pass the SoapAction call
> <Query><SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren</SoapAction></Query>
> and associating the data set parameters to the Designer GUI parameters
> (which I may say is not documented well on BoL)
> http://www.enGaugedTraining.com/Parameters.gif
> But when using ANY OTHER WEB SERVICE that needs parameters, the
> parameteres
> are not passed correctly to the WebMehtod, so I am thiking they are
> comming
> in the header or as an array instead of an actual item within the SOAP
> message... To bad we can't do this in the Query Designer... it is
> actually
> SAD this was nto thought out as to be compatible with regular SOAP
> calls...
> too bad. Ideally we would use query like the one below, and replace the
> fixed
> values with a parameter as defined in the designer (i.e. /Reports => @.ItemParam & False as @.RecursiveParam )... maybe in Orca this can be done
> right! either thru SOAP
> <?xml version="1.0" encoding="utf-16"?>
> <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:xsd="">http://www.w3.org/2001/XMLSchema">
> <soap:Body>
> <ListChildren
> xmlns="">http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices">
> <Item>/</Item>
> <Recursive>false</Recursive>
> </ListChildren>
> </soap:Body>
> </soap:Envelope>
> Or through whatever "standard' the <Query/> definition is made of!
> <Query>
> <SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren
> </SoapAction>
> <Parameter>
> <Name>Item</Name>
> <Value>/Reports</Value>
> </Parameter>
> <Parameter>
> <Name>Recursive</Name>
> <Value>False</Value>
> </Parameter>
> </Query>
>|||I was wondering if there was any update on this since the product has been
released?
"Teo Lachev [MVP]" wrote:
> I reported this issue in the early beta lifecycle but it seemed that it
> wasn't fixed. I've tried a similar scenario recently with RTM and indeed,
> the parameters are not passed. Strangely, if you trace the call, you will
> see that the parameters are serialized as a part of the SOAP request but for
> some reason they are dropped by the ASP.NET Web service runtime. I couldn't
> find a workaround and reported the issue again.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "J. C." <J. C.@.discussions.microsoft.com> wrote in message
> news:53FF7A94-1EC0-4EF3-8E45-5391B08F2779@.microsoft.com...
> > Does anyone know how to ensure a WebService/WebMethod needs to be
> > serialized
> > to ensure is compatible with Reporting Services' new XML Data Source when
> > passing parameters to the report. I have had success on using the Report
> > Server WebService
> > http://localhost/reportserver/reportservice2005.asmx
> > and using the Query designer to pass the SoapAction call
> > <Query><SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren</SoapAction></Query>
> > and associating the data set parameters to the Designer GUI parameters
> > (which I may say is not documented well on BoL)
> >
> > http://www.enGaugedTraining.com/Parameters.gif
> >
> > But when using ANY OTHER WEB SERVICE that needs parameters, the
> > parameteres
> > are not passed correctly to the WebMehtod, so I am thiking they are
> > comming
> > in the header or as an array instead of an actual item within the SOAP
> > message... To bad we can't do this in the Query Designer... it is
> > actually
> > SAD this was nto thought out as to be compatible with regular SOAP
> > calls...
> > too bad. Ideally we would use query like the one below, and replace the
> > fixed
> > values with a parameter as defined in the designer (i.e. /Reports => > @.ItemParam & False as @.RecursiveParam )... maybe in Orca this can be done
> > right! either thru SOAP
> >
> > <?xml version="1.0" encoding="utf-16"?>
> > <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > xmlns:xsd="">http://www.w3.org/2001/XMLSchema">
> > <soap:Body>
> > <ListChildren
> > xmlns="">http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices">
> > <Item>/</Item>
> > <Recursive>false</Recursive>
> > </ListChildren>
> > </soap:Body>
> > </soap:Envelope>
> >
> > Or through whatever "standard' the <Query/> definition is made of!
> >
> > <Query>
> > <SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren
> > </SoapAction>
> > <Parameter>
> > <Name>Item</Name>
> > <Value>/Reports</Value>
> > </Parameter>
> > <Parameter>
> > <Name>Recursive</Name>
> > <Value>False</Value>
> > </Parameter>
> > </Query>
> >
>
>|||Here is the solution to this puzzle:
http://channel9.msdn.com/ShowPost.aspx?PostID=137650#solution
Let me know if you are still having problems
"Shawn" wrote:
> I was wondering if there was any update on this since the product has been
> released?
> "Teo Lachev [MVP]" wrote:
> > I reported this issue in the early beta lifecycle but it seemed that it
> > wasn't fixed. I've tried a similar scenario recently with RTM and indeed,
> > the parameters are not passed. Strangely, if you trace the call, you will
> > see that the parameters are serialized as a part of the SOAP request but for
> > some reason they are dropped by the ASP.NET Web service runtime. I couldn't
> > find a workaround and reported the issue again.
> >
> > --
> > HTH,
> > ---
> > Teo Lachev, MVP, MCSD, MCT
> > "Microsoft Reporting Services in Action"
> > "Applied Microsoft Analysis Services 2005"
> > Home page and blog: http://www.prologika.com/
> > ---
> > "J. C." <J. C.@.discussions.microsoft.com> wrote in message
> > news:53FF7A94-1EC0-4EF3-8E45-5391B08F2779@.microsoft.com...
> > > Does anyone know how to ensure a WebService/WebMethod needs to be
> > > serialized
> > > to ensure is compatible with Reporting Services' new XML Data Source when
> > > passing parameters to the report. I have had success on using the Report
> > > Server WebService
> > > http://localhost/reportserver/reportservice2005.asmx
> > > and using the Query designer to pass the SoapAction call
> > > <Query><SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren</SoapAction></Query>
> > > and associating the data set parameters to the Designer GUI parameters
> > > (which I may say is not documented well on BoL)
> > >
> > > http://www.enGaugedTraining.com/Parameters.gif
> > >
> > > But when using ANY OTHER WEB SERVICE that needs parameters, the
> > > parameteres
> > > are not passed correctly to the WebMehtod, so I am thiking they are
> > > comming
> > > in the header or as an array instead of an actual item within the SOAP
> > > message... To bad we can't do this in the Query Designer... it is
> > > actually
> > > SAD this was nto thought out as to be compatible with regular SOAP
> > > calls...
> > > too bad. Ideally we would use query like the one below, and replace the
> > > fixed
> > > values with a parameter as defined in the designer (i.e. /Reports => > > @.ItemParam & False as @.RecursiveParam )... maybe in Orca this can be done
> > > right! either thru SOAP
> > >
> > > <?xml version="1.0" encoding="utf-16"?>
> > > <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
> > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > > xmlns:xsd="">http://www.w3.org/2001/XMLSchema">
> > > <soap:Body>
> > > <ListChildren
> > > xmlns="">http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices">
> > > <Item>/</Item>
> > > <Recursive>false</Recursive>
> > > </ListChildren>
> > > </soap:Body>
> > > </soap:Envelope>
> > >
> > > Or through whatever "standard' the <Query/> definition is made of!
> > >
> > > <Query>
> > > <SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren
> > > </SoapAction>
> > > <Parameter>
> > > <Name>Item</Name>
> > > <Value>/Reports</Value>
> > > </Parameter>
> > > <Parameter>
> > > <Name>Recursive</Name>
> > > <Value>False</Value>
> > > </Parameter>
> > > </Query>
> > >
> >
> >
> >|||Here is the solution to this puzzle:
http://channel9.msdn.com/ShowPost.aspx?PostID=137650#solution
Let me know if you are still having problems|||Still doesn't work for me. My namespace is http://AdventureWorks/ and query
is
<Query>
<Method Namespace="http://AdventureWorks/" Name="GetOrders"/>
<SoapAction>http://AdventureWorks/GetOrders</SoapAction>
<ElementPath
IgnoreNamespaces="true">GetOrdersResponse/GetOrdersResult/diffgram/DocumentElement/SalesOrderHeader</ElementPath>
</Query>
The query parameter is never passed. Another issue (perhaps not RS related)
is that trying to debug the web service call in the same solution by putting
the web service in debug mode and executing the dataset query from the
Report Designer Data tab, effectively freezes the VS.NET debugger.
Strangely, if you do iisreset to unfreeze, you will be able to break into
the method just fine :-)
Here is the outgoing POST request:
POST /CustomerImage/CustomerMap.asmx HTTP/1.1
SOAPAction: http://AdventureWorks/GetOrders
Content-Type: text/xml
Host: localhost:8080
Content-Length: 264
Expect: 100-continue
Connection: Keep-Alive
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="">http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<GetOrders xmlns="">http://AdventureWorks/">
<CustomerID>676</CustomerID>
</GetOrders>
</soap:Body>
</soap:Envelope>
And the web service:
==========================================[WebService(Namespace = "http://AdventureWorks/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class CustomerMap : System.Web.Services.WebService {
public CustomerMap()
{
}
[WebMethod]
public CustomerOrders.SalesOrderHeaderDataTable GetOrders(int customerID)
{
CustomerOrdersTableAdapters.SalesOrderHeaderTableAdapter adapter = new
CustomerOrdersTableAdapters.SalesOrderHeaderTableAdapter();
CustomerOrders.SalesOrderHeaderDataTable orders =adapter.GetData(customerID);
return orders;
}
}
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
<Juan.Carlos.Novoa@.gmail.com> wrote in message
news:1132282722.036433.142560@.g49g2000cwa.googlegroups.com...
> Here is the solution to this puzzle:
> http://channel9.msdn.com/ShowPost.aspx?PostID=137650#solution
> Let me know if you are still having problems
>|||You have an element path there that is causing problems:
it should be:
<Query>
<Method Namespace="http://AdventureWorks/" Name="GetOrders"/>
<SoapAction>http://AdventureWorks/GetOrders</SoapAction>
</Query>
Nothing else besides adding the parameters to the DataSet and associating
them to the Report's parameters
If yuo download my sample code from here
and run it, you will see it working
http://channel9.msdn.com/ShowPost.aspx?PostID=137650#solution
I've tried it with all my methods in my WebService and it works like a charm!
"Teo Lachev [MVP]" wrote:
> Still doesn't work for me. My namespace is http://AdventureWorks/ and query
> is
> <Query>
> <Method Namespace="http://AdventureWorks/" Name="GetOrders"/>
> <SoapAction>http://AdventureWorks/GetOrders</SoapAction>
> <ElementPath
> IgnoreNamespaces="true">GetOrdersResponse/GetOrdersResult/diffgram/DocumentElement/SalesOrderHeader</ElementPath>
> </Query>
> The query parameter is never passed. Another issue (perhaps not RS related)
> is that trying to debug the web service call in the same solution by putting
> the web service in debug mode and executing the dataset query from the
> Report Designer Data tab, effectively freezes the VS.NET debugger.
> Strangely, if you do iisreset to unfreeze, you will be able to break into
> the method just fine :-)
> Here is the outgoing POST request:
> POST /CustomerImage/CustomerMap.asmx HTTP/1.1
> SOAPAction: http://AdventureWorks/GetOrders
> Content-Type: text/xml
> Host: localhost:8080
> Content-Length: 264
> Expect: 100-continue
> Connection: Keep-Alive
> <?xml version="1.0" encoding="utf-8"?>
> <soap:Envelope xmlns:soap="">http://schemas.xmlsoap.org/soap/envelope/">
> <soap:Body>
> <GetOrders xmlns="">http://AdventureWorks/">
> <CustomerID>676</CustomerID>
> </GetOrders>
> </soap:Body>
> </soap:Envelope>
> And the web service:
> ==========================================> [WebService(Namespace = "http://AdventureWorks/")]
> [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
> public class CustomerMap : System.Web.Services.WebService {
> public CustomerMap()
> {
> }
> [WebMethod]
> public CustomerOrders.SalesOrderHeaderDataTable GetOrders(int customerID)
> {
> CustomerOrdersTableAdapters.SalesOrderHeaderTableAdapter adapter = new
> CustomerOrdersTableAdapters.SalesOrderHeaderTableAdapter();
> CustomerOrders.SalesOrderHeaderDataTable orders => adapter.GetData(customerID);
> return orders;
> }
> }
>
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> <Juan.Carlos.Novoa@.gmail.com> wrote in message
> news:1132282722.036433.142560@.g49g2000cwa.googlegroups.com...
> > Here is the solution to this puzzle:
> > http://channel9.msdn.com/ShowPost.aspx?PostID=137650#solution
> > Let me know if you are still having problems
> >
>
>|||Thanks for sharing.
I can't take the ElementPath off because the web service returns an ADO.NET
dataset. And I don't think the ElementPath should have anything to do with
the actual call because it is applied on the returned results as an XPATH
expression.
Do you have a working example with a web method that returns an ADO.NET
dataset and takes a parameter?
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"J. C." <JC@.discussions.microsoft.com> wrote in message
news:101AF92C-B8C5-462D-983B-9B3216CD2B0F@.microsoft.com...
> You have an element path there that is causing problems:
> it should be:
> <Query>
> <Method Namespace="http://AdventureWorks/" Name="GetOrders"/>
> <SoapAction>http://AdventureWorks/GetOrders</SoapAction>
> </Query>
> Nothing else besides adding the parameters to the DataSet and associating
> them to the Report's parameters
> If yuo download my sample code from here
> and run it, you will see it working
> http://channel9.msdn.com/ShowPost.aspx?PostID=137650#solution
> I've tried it with all my methods in my WebService and it works like a
> charm!
> "Teo Lachev [MVP]" wrote:
>> Still doesn't work for me. My namespace is http://AdventureWorks/ and
>> query
>> is
>> <Query>
>> <Method Namespace="http://AdventureWorks/" Name="GetOrders"/>
>> <SoapAction>http://AdventureWorks/GetOrders</SoapAction>
>> <ElementPath
>> IgnoreNamespaces="true">GetOrdersResponse/GetOrdersResult/diffgram/DocumentElement/SalesOrderHeader</ElementPath>
>> </Query>
>> The query parameter is never passed. Another issue (perhaps not RS
>> related)
>> is that trying to debug the web service call in the same solution by
>> putting
>> the web service in debug mode and executing the dataset query from the
>> Report Designer Data tab, effectively freezes the VS.NET debugger.
>> Strangely, if you do iisreset to unfreeze, you will be able to break into
>> the method just fine :-)
>> Here is the outgoing POST request:
>> POST /CustomerImage/CustomerMap.asmx HTTP/1.1
>> SOAPAction: http://AdventureWorks/GetOrders
>> Content-Type: text/xml
>> Host: localhost:8080
>> Content-Length: 264
>> Expect: 100-continue
>> Connection: Keep-Alive
>> <?xml version="1.0" encoding="utf-8"?>
>> <soap:Envelope xmlns:soap="">http://schemas.xmlsoap.org/soap/envelope/">
>> <soap:Body>
>> <GetOrders xmlns="">http://AdventureWorks/">
>> <CustomerID>676</CustomerID>
>> </GetOrders>
>> </soap:Body>
>> </soap:Envelope>
>> And the web service:
>> ==========================================>> [WebService(Namespace = "http://AdventureWorks/")]
>> [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
>> public class CustomerMap : System.Web.Services.WebService {
>> public CustomerMap()
>> {
>> }
>> [WebMethod]
>> public CustomerOrders.SalesOrderHeaderDataTable GetOrders(int customerID)
>> {
>> CustomerOrdersTableAdapters.SalesOrderHeaderTableAdapter adapter = new
>> CustomerOrdersTableAdapters.SalesOrderHeaderTableAdapter();
>> CustomerOrders.SalesOrderHeaderDataTable orders =>> adapter.GetData(customerID);
>> return orders;
>> }
>> }
>>
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> <Juan.Carlos.Novoa@.gmail.com> wrote in message
>> news:1132282722.036433.142560@.g49g2000cwa.googlegroups.com...
>> > Here is the solution to this puzzle:
>> > http://channel9.msdn.com/ShowPost.aspx?PostID=137650#solution
>> > Let me know if you are still having problems
>> >
>>|||If you want to create a public webservice that generates a dataset, and let
me know here is at, i will build you a report that reads of it.
A cleaner approach would be for you to convert thet dataset to an array of
objects defined in a class that represents your dataset, where a property
exist for each column, then you can iterate through your datareader, create
new instances of that class, set the properties(columns) and return an array
of objects 9rows) the report will easily be able to parse the data withouth
having to deal with the XSD definition... you are just reading the data after
alll, so who cares what the READ ONLY data types are ;-)
"Teo Lachev [MVP]" wrote:
> Thanks for sharing.
> I can't take the ElementPath off because the web service returns an ADO.NET
> dataset. And I don't think the ElementPath should have anything to do with
> the actual call because it is applied on the returned results as an XPATH
> expression.
> Do you have a working example with a web method that returns an ADO.NET
> dataset and takes a parameter?
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "J. C." <JC@.discussions.microsoft.com> wrote in message
> news:101AF92C-B8C5-462D-983B-9B3216CD2B0F@.microsoft.com...
> > You have an element path there that is causing problems:
> > it should be:
> > <Query>
> > <Method Namespace="http://AdventureWorks/" Name="GetOrders"/>
> > <SoapAction>http://AdventureWorks/GetOrders</SoapAction>
> > </Query>
> > Nothing else besides adding the parameters to the DataSet and associating
> > them to the Report's parameters
> > If yuo download my sample code from here
> > and run it, you will see it working
> > http://channel9.msdn.com/ShowPost.aspx?PostID=137650#solution
> > I've tried it with all my methods in my WebService and it works like a
> > charm!
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> Still doesn't work for me. My namespace is http://AdventureWorks/ and
> >> query
> >> is
> >>
> >> <Query>
> >> <Method Namespace="http://AdventureWorks/" Name="GetOrders"/>
> >> <SoapAction>http://AdventureWorks/GetOrders</SoapAction>
> >> <ElementPath
> >> IgnoreNamespaces="true">GetOrdersResponse/GetOrdersResult/diffgram/DocumentElement/SalesOrderHeader</ElementPath>
> >> </Query>
> >>
> >> The query parameter is never passed. Another issue (perhaps not RS
> >> related)
> >> is that trying to debug the web service call in the same solution by
> >> putting
> >> the web service in debug mode and executing the dataset query from the
> >> Report Designer Data tab, effectively freezes the VS.NET debugger.
> >> Strangely, if you do iisreset to unfreeze, you will be able to break into
> >> the method just fine :-)
> >>
> >> Here is the outgoing POST request:
> >>
> >> POST /CustomerImage/CustomerMap.asmx HTTP/1.1
> >> SOAPAction: http://AdventureWorks/GetOrders
> >> Content-Type: text/xml
> >> Host: localhost:8080
> >> Content-Length: 264
> >> Expect: 100-continue
> >> Connection: Keep-Alive
> >>
> >> <?xml version="1.0" encoding="utf-8"?>
> >> <soap:Envelope xmlns:soap="">http://schemas.xmlsoap.org/soap/envelope/">
> >> <soap:Body>
> >> <GetOrders xmlns="">http://AdventureWorks/">
> >> <CustomerID>676</CustomerID>
> >> </GetOrders>
> >> </soap:Body>
> >> </soap:Envelope>
> >>
> >> And the web service:
> >>
> >> ==========================================> >> [WebService(Namespace = "http://AdventureWorks/")]
> >>
> >> [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
> >>
> >> public class CustomerMap : System.Web.Services.WebService {
> >>
> >> public CustomerMap()
> >>
> >> {
> >>
> >> }
> >>
> >> [WebMethod]
> >>
> >> public CustomerOrders.SalesOrderHeaderDataTable GetOrders(int customerID)
> >>
> >> {
> >>
> >> CustomerOrdersTableAdapters.SalesOrderHeaderTableAdapter adapter = new
> >> CustomerOrdersTableAdapters.SalesOrderHeaderTableAdapter();
> >>
> >> CustomerOrders.SalesOrderHeaderDataTable orders => >> adapter.GetData(customerID);
> >>
> >> return orders;
> >>
> >> }
> >>
> >> }
> >>
> >>
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> <Juan.Carlos.Novoa@.gmail.com> wrote in message
> >> news:1132282722.036433.142560@.g49g2000cwa.googlegroups.com...
> >> > Here is the solution to this puzzle:
> >> > http://channel9.msdn.com/ShowPost.aspx?PostID=137650#solution
> >> > Let me know if you are still having problems
> >> >
> >>
> >>
> >>
>
>|||In a zen moment, it dawned on me that the parameter name is case-sensitive.
It's working fine now. Thanks very much for the sample.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"J. C." <JC@.discussions.microsoft.com> wrote in message
news:2D6AF396-F2A6-4AF4-90D6-3B2C8C788160@.microsoft.com...
> If you want to create a public webservice that generates a dataset, and
> let
> me know here is at, i will build you a report that reads of it.
> A cleaner approach would be for you to convert thet dataset to an array of
> objects defined in a class that represents your dataset, where a property
> exist for each column, then you can iterate through your datareader,
> create
> new instances of that class, set the properties(columns) and return an
> array
> of objects 9rows) the report will easily be able to parse the data
> withouth
> having to deal with the XSD definition... you are just reading the data
> after
> alll, so who cares what the READ ONLY data types are ;-)
> "Teo Lachev [MVP]" wrote:
>> Thanks for sharing.
>> I can't take the ElementPath off because the web service returns an
>> ADO.NET
>> dataset. And I don't think the ElementPath should have anything to do
>> with
>> the actual call because it is applied on the returned results as an XPATH
>> expression.
>> Do you have a working example with a web method that returns an ADO.NET
>> dataset and takes a parameter?
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "J. C." <JC@.discussions.microsoft.com> wrote in message
>> news:101AF92C-B8C5-462D-983B-9B3216CD2B0F@.microsoft.com...
>> > You have an element path there that is causing problems:
>> > it should be:
>> > <Query>
>> > <Method Namespace="http://AdventureWorks/" Name="GetOrders"/>
>> > <SoapAction>http://AdventureWorks/GetOrders</SoapAction>
>> > </Query>
>> > Nothing else besides adding the parameters to the DataSet and
>> > associating
>> > them to the Report's parameters
>> > If yuo download my sample code from here
>> > and run it, you will see it working
>> > http://channel9.msdn.com/ShowPost.aspx?PostID=137650#solution
>> > I've tried it with all my methods in my WebService and it works like a
>> > charm!
>> >
>> > "Teo Lachev [MVP]" wrote:
>> >
>> >> Still doesn't work for me. My namespace is http://AdventureWorks/ and
>> >> query
>> >> is
>> >>
>> >> <Query>
>> >> <Method Namespace="http://AdventureWorks/" Name="GetOrders"/>
>> >> <SoapAction>http://AdventureWorks/GetOrders</SoapAction>
>> >> <ElementPath
>> >> IgnoreNamespaces="true">GetOrdersResponse/GetOrdersResult/diffgram/DocumentElement/SalesOrderHeader</ElementPath>
>> >> </Query>
>> >>
>> >> The query parameter is never passed. Another issue (perhaps not RS
>> >> related)
>> >> is that trying to debug the web service call in the same solution by
>> >> putting
>> >> the web service in debug mode and executing the dataset query from the
>> >> Report Designer Data tab, effectively freezes the VS.NET debugger.
>> >> Strangely, if you do iisreset to unfreeze, you will be able to break
>> >> into
>> >> the method just fine :-)
>> >>
>> >> Here is the outgoing POST request:
>> >>
>> >> POST /CustomerImage/CustomerMap.asmx HTTP/1.1
>> >> SOAPAction: http://AdventureWorks/GetOrders
>> >> Content-Type: text/xml
>> >> Host: localhost:8080
>> >> Content-Length: 264
>> >> Expect: 100-continue
>> >> Connection: Keep-Alive
>> >>
>> >> <?xml version="1.0" encoding="utf-8"?>
>> >> <soap:Envelope xmlns:soap="">http://schemas.xmlsoap.org/soap/envelope/">
>> >> <soap:Body>
>> >> <GetOrders xmlns="">http://AdventureWorks/">
>> >> <CustomerID>676</CustomerID>
>> >> </GetOrders>
>> >> </soap:Body>
>> >> </soap:Envelope>
>> >>
>> >> And the web service:
>> >>
>> >> ==========================================>> >> [WebService(Namespace = "http://AdventureWorks/")]
>> >>
>> >> [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
>> >>
>> >> public class CustomerMap : System.Web.Services.WebService {
>> >>
>> >> public CustomerMap()
>> >>
>> >> {
>> >>
>> >> }
>> >>
>> >> [WebMethod]
>> >>
>> >> public CustomerOrders.SalesOrderHeaderDataTable GetOrders(int
>> >> customerID)
>> >>
>> >> {
>> >>
>> >> CustomerOrdersTableAdapters.SalesOrderHeaderTableAdapter adapter = new
>> >> CustomerOrdersTableAdapters.SalesOrderHeaderTableAdapter();
>> >>
>> >> CustomerOrders.SalesOrderHeaderDataTable orders =>> >> adapter.GetData(customerID);
>> >>
>> >> return orders;
>> >>
>> >> }
>> >>
>> >> }
>> >>
>> >>
>> >> --
>> >> HTH,
>> >> ---
>> >> Teo Lachev, MVP, MCSD, MCT
>> >> "Microsoft Reporting Services in Action"
>> >> "Applied Microsoft Analysis Services 2005"
>> >> Home page and blog: http://www.prologika.com/
>> >> ---
>> >> <Juan.Carlos.Novoa@.gmail.com> wrote in message
>> >> news:1132282722.036433.142560@.g49g2000cwa.googlegroups.com...
>> >> > Here is the solution to this puzzle:
>> >> > http://channel9.msdn.com/ShowPost.aspx?PostID=137650#solution
>> >> > Let me know if you are still having problems
>> >> >
>> >>
>> >>
>> >>
>>

2005 Management Studio Reformats my source!

Minor issues that are driving me crazy about this tool:
1. I type in a new view and format it the way it makes sense to me. I hit
the Save button, and SqlMS decides it wants to format it a completely
different way. How can I turn this feature off, or tell the program how I
want it to format my code? Older versions of EM did not reformat the code.
2. When I create a new view, the Diagram, Results and Criteria panes
automatically display. I have to click the buttons to hide them each time.
I don't need them or want them taking up editing space. How can I make the
program remember that I don't want it to display these "helpful" windows
each time?
Please advise
no help or resolution here?
"ZippyThePinhead" wrote:

> Minor issues that are driving me crazy about this tool:
> 1. I type in a new view and format it the way it makes sense to me. I hit
> the Save button, and SqlMS decides it wants to format it a completely
> different way. How can I turn this feature off, or tell the program how I
> want it to format my code? Older versions of EM did not reformat the code.
> 2. When I create a new view, the Diagram, Results and Criteria panes
> automatically display. I have to click the buttons to hide them each time.
> I don't need them or want them taking up editing space. How can I make the
> program remember that I don't want it to display these "helpful" windows
> each time?
> Please advise
>
|||Why not create the view as a CREATE VIEW statement inside of a Query window? I
don't seem to have any issues when I do that. Of course, you will need to
choose ALTER - Script to New Window/Clipboard in order to modify the code
instead of choosing Modify as Modify defaults to that view.
-Pete Schott
ZippyThePinhead <ZippyThePinhead@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
> no help or resolution here?
> "ZippyThePinhead" wrote:
|||Thanks Peter -- yes that certainly does work, but it's a pain in the rear to
have to manage this myself..which is what I have been doing lately.
There simply needs to be some options available in the program to stop the
auto-formatting of our code. I've noticed that sometimes it even messes
things up by adding "as exp1" expressions on columns the parser thinks are
misnamed!
"Peter A. Schott" wrote:

> Why not create the view as a CREATE VIEW statement inside of a Query window? I
> don't seem to have any issues when I do that. Of course, you will need to
> choose ALTER - Script to New Window/Clipboard in order to modify the code
> instead of choosing Modify as Modify defaults to that view.
> -Pete Schott
> ZippyThePinhead <ZippyThePinhead@.discussions.microsoft.com> wrote:
>

2005 keeps telling me the dababase is restoring

Hello all,

I have been seeing problems in restoring database to SQL Server 2005. The source is a .bak file backuped from SQL 2000. Everything in the process went well and at last the restore window told me the resotre has been successfully complete. But in management studio, it keeps telling me the database is restoring, I can not access it or open the property page. I tried the process many times already.

This occured several times in my Sep CTP platform so I removed it and installed the released version, but no good.

My environment: win xp sp2, SQL 2005

Any ideas?

When you restore the db, make sure you specify WITH NORECOVERY. This keeps the system from attempting to rollback uncommitted transactions.