Question about sp_addscriptexec

Hi,
I'm running SQL Server 2000 EE SP3 on Windows Server 2003.
I have multiple named pull subscribers to a Transactional replication model.
I have written a script that adds and drops fields from several tables using
sp_repladdcolumn and sp_repldropcolumn. I also have some commands in my
script that are removing tables from the replication model. I also have some
commands that are adding new tables to the replication model.
After the commands that are adding and removing the fields and tables, I am
issuing a sp_refreshsubscriptions.
I am then starting the snapshot agent so that the subscribers will get the
new tables that I have added.
I then issue an sp_addscriptexec to run a script on the subscriber.
My question is why does this script that I am executing via the
sp_addscriptexec run on the subscriber before the snapshot ever gets applied
to the subscriber? I need to have the script run after the snapshot has been
created and delivered to the subscriber.
Thanks in advance,
Stephen
Probably because the sp_addscriptexec is added to the distribution database
before the snapshot is generated and the sync commands make it there, You
should perhaps use the post snapshot command for this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Stephen Schissler" <StephenSchissler@.discussions.microsoft.com> wrote in
message news:9CD0B3BB-6EE6-46DF-8CDE-C8B860890EE1@.microsoft.com...
> Hi,
> I'm running SQL Server 2000 EE SP3 on Windows Server 2003.
> I have multiple named pull subscribers to a Transactional replication
model.
> I have written a script that adds and drops fields from several tables
using
> sp_repladdcolumn and sp_repldropcolumn. I also have some commands in my
> script that are removing tables from the replication model. I also have
some
> commands that are adding new tables to the replication model.
> After the commands that are adding and removing the fields and tables, I
am
> issuing a sp_refreshsubscriptions.
> I am then starting the snapshot agent so that the subscribers will get the
> new tables that I have added.
> I then issue an sp_addscriptexec to run a script on the subscriber.
> My question is why does this script that I am executing via the
> sp_addscriptexec run on the subscriber before the snapshot ever gets
applied
> to the subscriber? I need to have the script run after the snapshot has
been
> created and delivered to the subscriber.
> Thanks in advance,
> Stephen
|||I already have a post snapshot command tied to my replication publication.
Since I am already replicating to the subscriber and just adding new tables
and fields, it seems as though the post snapshot command that was orginally
tied to the publication does not get run. I'm saying this as I already have
a post snapshot script applied to my publication and it is not getting run
when I regen the snapshot to create the definitions of the new tables.
So, I do not think that adding the additional script as a post script will
get run either, but in any case, I do not want to tie this script to the
publication definition as I do not want this script to be run whenever a
snapshot has been applied.
Thanks again,
Stephen
"Hilary Cotter" wrote:

> Probably because the sp_addscriptexec is added to the distribution database
> before the snapshot is generated and the sync commands make it there, You
> should perhaps use the post snapshot command for this.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Stephen Schissler" <StephenSchissler@.discussions.microsoft.com> wrote in
> message news:9CD0B3BB-6EE6-46DF-8CDE-C8B860890EE1@.microsoft.com...
> model.
> using
> some
> am
> applied
> been
>
>
|||You might want to set your distribution job to run scheduled as opposed to
continuous, stop the log reader agent, and then have the sp_addscriptexec
command run as your final job step. Stop and start your distribution agent.
After the distribution agent has stopped, remove this last step, start up
your log reader agent.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Stephen Schissler" <StephenSchissler@.discussions.microsoft.com> wrote in
message news:E7C9D59C-D82B-412E-9B5B-55DA93574C79@.microsoft.com...
> I already have a post snapshot command tied to my replication publication.
> Since I am already replicating to the subscriber and just adding new
tables
> and fields, it seems as though the post snapshot command that was
orginally
> tied to the publication does not get run. I'm saying this as I already
have[vbcol=seagreen]
> a post snapshot script applied to my publication and it is not getting run
> when I regen the snapshot to create the definitions of the new tables.
> So, I do not think that adding the additional script as a post script will
> get run either, but in any case, I do not want to tie this script to the
> publication definition as I do not want this script to be run whenever a
> snapshot has been applied.
> Thanks again,
> Stephen
> "Hilary Cotter" wrote:
database[vbcol=seagreen]
You[vbcol=seagreen]
in[vbcol=seagreen]
my[vbcol=seagreen]
have[vbcol=seagreen]
I[vbcol=seagreen]
the[vbcol=seagreen]
has[vbcol=seagreen]

Question about snapshot replication and monitoring of msrepl_transactions in the dist.db

OK.
We have this 1 publisher db that is pushing out to two separate
subscribers (one is transactional the other is snapshot). In the
distribution db the publisher_database_id is going to be the same. We
monitor this transaction count by publisher id with the following (
Select count(1) from dbo.MSrepl_transactions where
publisher_database_id = 17). Now that we have added snapshot
replication to one subscriber and transactional to another we have
noticed that this transaction count is not correct. It always says that
there are like 100+ in there waiting, but this is not true. The
transactional publications are always up to date with 0 latency.
It was my understanding that snapshot replication literally just makes a
bcp and push's it over at whatever time you tell it to push. However,
it looks like these extra transactions sitting in my distribution
database have everything to do with the snapshot replication and not the
transactional replication. Does snapshot replication work differently
then i thought? Does snapshot replication actually post transactions to
the distribution db?
Thanks
-comb
what shows up in sp_browsereplcmds. I suspect what you will see there are
the commands which are used for the sync - i.e. to build the tables and
other objects on the subscriber, and the bcp the data there. IIRC the
distribution clean up agent does not clean these up until you are past the
retention period.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"combfilter" <asdf@.adsf.com> wrote in message
news:MPG.1e4953894a6972969896eb@.news.newsreader.co m...
> OK.
> We have this 1 publisher db that is pushing out to two separate
> subscribers (one is transactional the other is snapshot). In the
> distribution db the publisher_database_id is going to be the same. We
> monitor this transaction count by publisher id with the following (
> Select count(1) from dbo.MSrepl_transactions where
> publisher_database_id = 17). Now that we have added snapshot
> replication to one subscriber and transactional to another we have
> noticed that this transaction count is not correct. It always says that
> there are like 100+ in there waiting, but this is not true. The
> transactional publications are always up to date with 0 latency.
> It was my understanding that snapshot replication literally just makes a
> bcp and push's it over at whatever time you tell it to push. However,
> it looks like these extra transactions sitting in my distribution
> database have everything to do with the snapshot replication and not the
> transactional replication. Does snapshot replication work differently
> then i thought? Does snapshot replication actually post transactions to
> the distribution db?
> Thanks
> -comb
|||In article <Oq2WvQxJGHA.3064@.TK2MSFTNGP10.phx.gbl>,
hilary.cotter@.gmail.com says...
> what shows up in sp_browsereplcmds. I suspect what you will see there are
> the commands which are used for the sync - i.e. to build the tables and
> other objects on the subscriber, and the bcp the data there. IIRC the
> distribution clean up agent does not clean these up until you are past the
> retention period.
>
why would the bcp data be in the distribution db? wouldn't it just push
that across the net to the subscriber straight up as a .bcp file? why
would a snapshot need to put anything in the distribution db other then
"hey you need to push this .bcp across".
ok so what you are saying is that snapshot replication DOES actually
post transactions to the distribution db? I thought it just generated
the .bcp, idx and whatever that 3rd file is and pushed those across the
net with just a few instructions on where to put them.?
sp_browsereplcmds times out for me. We have a lot of subscribers on
this box. Is there anyway I can use that sp and just look at a certain
db id?
thanks.

Question about snapshot article defaults and indexes

I have recently been comparing the size of the source and replicated
tables and realized that indexes are not being replicated. The GLOBAL
(Applies to all) article defaults for the snapshot are set as follows:
Copy objects to destination
Indexes for primary keys are always copied
Include declared referential integrityCHECKED
Clustered indexesCHECKED
Nonclustered indexesCHECKED
User triggersNOT CHECKED
Extended propertiesNOT CHECKED
CollationNOT CHECKED
I these defaults should transfer the indexes correctly so I had to look
for another culprit. We have a script which creates three tables daily
so I decided to look at the article defaults for those tables and found
that only the 'Include declared referential integrity box is CHECKED.
QUESTION: What is the stored procedure where these variables can be
set? Is it sp_addarticle and if so what fields?
If we need to use the replicated db what would have been the
implication of not having the proper indexing. Performance?
to set them use the schemaoption parameter of sp_addarticle.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

Question about simple query..

How are you ? Please give me an advice :)
It's been bothering me for three days. I'm new SQL user.

I have the following table, which has name, address, city,state,zip
code, and phone number.

kim 3134 n. chatham ellicott city md 21042
410-222-2222
justin 3134 n. chatham rd. ellicott city md 21042
410-222-2222
hong 4343 antonio ln. ellicott city md 21042
555-341-3412
woo 1123 cedar ln. columbiamd21044 410-111-1358

The problem is that the table should not contain the same phone
number.
Phone number 410-222-2222 is duplicated.

How can I erase that extra data, and get the table like this ? :

kim 3134 n. chatham ellicott city md 21042
410-222-2222
*******************the data that has same phone number is
gone*****************
hong 4343 antonio ln. ellicott city md 21042
555-341-3412
woo 1123 cedar ln. columbiamd21044 410-111-1358

First, I used this query, but it turned out all of my data was gone. :
(

delete FROM address WHERE exists (
select * from address where address.phone = address.phone
);

Please help !What is the criteria that you would use to pic which row to keep?
jaehwang wrote:

Quote:

Originally Posted by

How are you ? Please give me an advice :)
It's been bothering me for three days. I'm new SQL user.
>
I have the following table, which has name, address, city,state,zip
code, and phone number.
>
>
kim 3134 n. chatham ellicott city md 21042
410-222-2222
justin 3134 n. chatham rd. ellicott city md 21042
410-222-2222
hong 4343 antonio ln. ellicott city md 21042
555-341-3412
woo 1123 cedar ln. columbiamd21044 410-111-1358
>
>
The problem is that the table should not contain the same phone
number.
Phone number 410-222-2222 is duplicated.
>
How can I erase that extra data, and get the table like this ? :
>
kim 3134 n. chatham ellicott city md 21042
410-222-2222
*******************the data that has same phone number is
gone*****************
hong 4343 antonio ln. ellicott city md 21042
555-341-3412
woo 1123 cedar ln. columbiamd21044 410-111-1358
>
First, I used this query, but it turned out all of my data was gone. :
(
>
delete FROM address WHERE exists (
select * from address where address.phone = address.phone
);
>
Please help !
>

|||You would have to define a criteria based on which a row will be kept or
deleted (that is another column or combination of columns that is unique).
Here is just an example based on your sample data (in this case the row with
the MIN name will be kept, but this assumes no duplicate names with the same
phone):

DELETE FROM Address
WHERE EXISTS (
SELECT *
FROM Address AS A
WHERE A.phone = Address.phone
AND A.name < Address.name)

You can easily reverse the above condition to A.name Address.name to keep
the MAX name.

After you are done you can alter the table and add UNIQUE constraint on the
phone column to prevent duplicate data in the future, something like this:

ALTER TABLE Address ADD CONSTRAINT uphone UNIQUE (phone)

HTH,

Plamen Ratchev
http://www.SQLStudio.comsql

Question about setuping replication

Hi Guys,
I have two questions regarging setuping replication.
1. Do I need to configure Recovery Model as full when I want use
transactional replication.
2. Do I need to setup linked server when I use more than two servers for
replication.
3. Is there any doc about how to setup replication?
Thanks.
(1) No
(2) No but look at this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;274098
(3) BOL, Hilary's book and some general links on my site (eg
http://www.mssqlcity.com/Articles/Replic/Replic.htm)
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Question about setup

what accounts are required for SQL cluster setup?
I was trying to install SQL Server and ran into some prompts that I did not
see in the books that I read about SQL cluster setup.
I know about SQLservice account. However, I didn't know it requires a domain
group for each service, SQL Server, Agent and Full text search. Can someone
explain? And are there other accounts that I need to be aware that are needed?
Also, can both nodes access the database file at the same time? I read that
if you use database mirror it is not recommended. I didn't think having both
db servers accessing the database files at the same time was a good idea.
We are going to use SQL Cluster and database mirror for SQL 2005.
Cluster Service Account - must be in a domain.
SQL Service Account - must be in a domain.
3 Groups for SQL 2005 install.
http://support.microsoft.com/kb/910228 Section 2.5.11.
I will let a SQL MVP/DBA answer the can a DB that is mirrored be accessed
from 2 nodes at a time, I know I would not ever recommend it.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"SAM" <SAM@.discussions.microsoft.com> wrote in message
news:AE8105A3-C2E7-41C0-A4E1-7189399BC548@.microsoft.com...
> what accounts are required for SQL cluster setup?
> I was trying to install SQL Server and ran into some prompts that I did
> not
> see in the books that I read about SQL cluster setup.
> I know about SQLservice account. However, I didn't know it requires a
> domain
> group for each service, SQL Server, Agent and Full text search. Can
> someone
> explain? And are there other accounts that I need to be aware that are
> needed?
> Also, can both nodes access the database file at the same time? I read
> that
> if you use database mirror it is not recommended. I didn't think having
> both
> db servers accessing the database files at the same time was a good idea.
> We are going to use SQL Cluster and database mirror for SQL 2005.
|||Hi Rodney, thanks for helpful. Another question, the account I used to
install sql, this account needs to have privileges to create these group
accounts, right?
"Rodney R. Fournier [MVP]" wrote:

> Cluster Service Account - must be in a domain.
> SQL Service Account - must be in a domain.
> 3 Groups for SQL 2005 install.
> http://support.microsoft.com/kb/910228 Section 2.5.11.
> I will let a SQL MVP/DBA answer the can a DB that is mirrored be accessed
> from 2 nodes at a time, I know I would not ever recommend it.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "SAM" <SAM@.discussions.microsoft.com> wrote in message
> news:AE8105A3-C2E7-41C0-A4E1-7189399BC548@.microsoft.com...
>
>
|||I like to have them pre-staged. So no it doesn't. You could have an admin
create the groups for you.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"SAM" <SAM@.discussions.microsoft.com> wrote in message
news:EC84C8C7-D22C-4380-BFF8-7EE9232E8CFD@.microsoft.com...[vbcol=seagreen]
> Hi Rodney, thanks for helpful. Another question, the account I used to
> install sql, this account needs to have privileges to create these group
> accounts, right?
> "Rodney R. Fournier [MVP]" wrote:
|||Actually, the SQL install account will need to set permissions on those
groups locally for the host nodes. Your install account must be a
domain-level account and should be local admin on all host nodes.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:O2GCoBV7GHA.3412@.TK2MSFTNGP04.phx.gbl...
>I like to have them pre-staged. So no it doesn't. You could have an admin
>create the groups for you.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "SAM" <SAM@.discussions.microsoft.com> wrote in message
> news:EC84C8C7-D22C-4380-BFF8-7EE9232E8CFD@.microsoft.com...
>
|||Thanks Rodney. I was able to install SQL 2005 on the nodes.
I want to install Analysis Services on the second node to be our Analysis
Server. Is there any reason that I shouldn't? If I install it on the second
node would it cause a problem for anything?
"Rodney R. Fournier [MVP]" wrote:

> I like to have them pre-staged. So no it doesn't. You could have an admin
> create the groups for you.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "SAM" <SAM@.discussions.microsoft.com> wrote in message
> news:EC84C8C7-D22C-4380-BFF8-7EE9232E8CFD@.microsoft.com...
>
>
|||Thanks, I was able to get the correct groups and permissions set.
"Geoff N. Hiten" wrote:

> Actually, the SQL install account will need to set permissions on those
> groups locally for the host nodes. Your install account must be a
> domain-level account and should be local admin on all host nodes.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:O2GCoBV7GHA.3412@.TK2MSFTNGP04.phx.gbl...
>
>
|||It does not create local groups, it assigns local permissions to domain
groups. Slight but distinct difference.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%236bd$$W7GHA.2380@.TK2MSFTNGP02.phx.gbl...
> Really? Not the SQL Service account, but the installation user creates
> local groups on the clustered nodes? Hmm, did not know that, time to do
> more research.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:%231iWp3W7GHA.728@.TK2MSFTNGP04.phx.gbl...
>
|||I see, that is why I missed it. Cool. Thanks!
Rod
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uSQlYqZ7GHA.3644@.TK2MSFTNGP03.phx.gbl...
> It does not create local groups, it assigns local permissions to domain
> groups. Slight but distinct difference.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:%236bd$$W7GHA.2380@.TK2MSFTNGP02.phx.gbl...
>
|||Client tools install (including SSMS) is not cluster aware. It only
installs to the local node.
The installer is pretty smart and will only add or remove stuff that you
mark different on each run. You can install just the client tools on the
"other" nodes any time. Personally, I prefer to do it before the
cluster-aware elements.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"SAM" <SAM@.discussions.microsoft.com> wrote in message
news:7BFA9BFF-1EDA-49BB-B18E-F7018A2E8B4A@.microsoft.com...[vbcol=seagreen]
> Rodney,
> I completed the install; however, when I launched SQL 2005 - I do not see
> Management Studio. Do I need to run the install again?
> When I installed 2005 on the test system, I did not have a problem but
> they
> were not configured with clustering so the setup option is different.
> "Rodney R. Fournier [MVP]" wrote:

Question about Service Pack 1

Maybe my question is stupid, but I still post it here. Hope somebody can give
me an answer. MS released Service Pack 1 for Reporting services. Should I
only install the SP 1 into the server machine, or should I ask each user
install the SP 1 in his/her computer to run reports?
Thanks!server only .
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:4069EC0F-4D3B-46B6-A3F5-2D91CC0F4C12@.microsoft.com...
> Maybe my question is stupid, but I still post it here. Hope somebody can
give
> me an answer. MS released Service Pack 1 for Reporting services. Should I
> only install the SP 1 into the server machine, or should I ask each user
> install the SP 1 in his/her computer to run reports?
> Thanks!|||But why my report runs very different in different computers? The same report
runs well in some users' computers, but doesn't work in other users'
computers? That makes me so frustrating.
Thanks!
"Dennis Redfield" wrote:
> server only .
> "Jean" <Jean@.discussions.microsoft.com> wrote in message
> news:4069EC0F-4D3B-46B6-A3F5-2D91CC0F4C12@.microsoft.com...
> > Maybe my question is stupid, but I still post it here. Hope somebody can
> give
> > me an answer. MS released Service Pack 1 for Reporting services. Should I
> > only install the SP 1 into the server machine, or should I ask each user
> > install the SP 1 in his/her computer to run reports?
> >
> > Thanks!
>
>|||You should upgrade all development machines as well. And you definitely do
not do anything at the clients. If the users computers are acting
differently the first thing I would do is see what version of IE they are
on.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:567BAAD6-6C11-4C2E-9548-46DE8A3814FA@.microsoft.com...
> But why my report runs very different in different computers? The same
report
> runs well in some users' computers, but doesn't work in other users'
> computers? That makes me so frustrating.
>
> Thanks!
> "Dennis Redfield" wrote:
> > server only .
> >
> > "Jean" <Jean@.discussions.microsoft.com> wrote in message
> > news:4069EC0F-4D3B-46B6-A3F5-2D91CC0F4C12@.microsoft.com...
> > > Maybe my question is stupid, but I still post it here. Hope somebody
can
> > give
> > > me an answer. MS released Service Pack 1 for Reporting services.
Should I
> > > only install the SP 1 into the server machine, or should I ask each
user
> > > install the SP 1 in his/her computer to run reports?
> > >
> > > Thanks!
> >
> >
> >|||How different? Define "doesn't work"
Jeff
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:567BAAD6-6C11-4C2E-9548-46DE8A3814FA@.microsoft.com...
> But why my report runs very different in different computers? The same
report
> runs well in some users' computers, but doesn't work in other users'
> computers? That makes me so frustrating.
>
> Thanks!
> "Dennis Redfield" wrote:
> > server only .
> >
> > "Jean" <Jean@.discussions.microsoft.com> wrote in message
> > news:4069EC0F-4D3B-46B6-A3F5-2D91CC0F4C12@.microsoft.com...
> > > Maybe my question is stupid, but I still post it here. Hope somebody
can
> > give
> > > me an answer. MS released Service Pack 1 for Reporting services.
Should I
> > > only install the SP 1 into the server machine, or should I ask each
user
> > > install the SP 1 in his/her computer to run reports?
> > >
> > > Thanks!
> >
> >
> >|||Actually, I posted the question this morning.
I have a report generated in Matrix. One of data field is a Hyperlink. I
used rs:LinkTarget=_blank to open a new window for a subreport. It works in
some computers, but not in other some computers. It really looks like work in
Win. 2000, but not Win XP. All of us use the updated IE.
Any suggestion?
Thanks to everyone!
"Jeff Dillon" wrote:
> How different? Define "doesn't work"
> Jeff
> "Jean" <Jean@.discussions.microsoft.com> wrote in message
> news:567BAAD6-6C11-4C2E-9548-46DE8A3814FA@.microsoft.com...
> > But why my report runs very different in different computers? The same
> report
> > runs well in some users' computers, but doesn't work in other users'
> > computers? That makes me so frustrating.
> >
> >
> > Thanks!
> >
> > "Dennis Redfield" wrote:
> >
> > > server only .
> > >
> > > "Jean" <Jean@.discussions.microsoft.com> wrote in message
> > > news:4069EC0F-4D3B-46B6-A3F5-2D91CC0F4C12@.microsoft.com...
> > > > Maybe my question is stupid, but I still post it here. Hope somebody
> can
> > > give
> > > > me an answer. MS released Service Pack 1 for Reporting services.
> Should I
> > > > only install the SP 1 into the server machine, or should I ask each
> user
> > > > install the SP 1 in his/her computer to run reports?
> > > >
> > > > Thanks!
> > >
> > >
> > >
>
>|||Again, define "not works"!!
What happens' It doesn't open a new window? It opens a new window but
doesn't display? ?
Jeff
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:1393708D-AAD3-4807-9575-414EF2CE44CF@.microsoft.com...
> Actually, I posted the question this morning.
> I have a report generated in Matrix. One of data field is a Hyperlink. I
> used rs:LinkTarget=_blank to open a new window for a subreport. It works
in
> some computers, but not in other some computers. It really looks like work
in
> Win. 2000, but not Win XP. All of us use the updated IE.
> Any suggestion?
>
> Thanks to everyone!
> "Jeff Dillon" wrote:
> > How different? Define "doesn't work"
> >
> > Jeff
> > "Jean" <Jean@.discussions.microsoft.com> wrote in message
> > news:567BAAD6-6C11-4C2E-9548-46DE8A3814FA@.microsoft.com...
> > > But why my report runs very different in different computers? The same
> > report
> > > runs well in some users' computers, but doesn't work in other users'
> > > computers? That makes me so frustrating.
> > >
> > >
> > > Thanks!
> > >
> > > "Dennis Redfield" wrote:
> > >
> > > > server only .
> > > >
> > > > "Jean" <Jean@.discussions.microsoft.com> wrote in message
> > > > news:4069EC0F-4D3B-46B6-A3F5-2D91CC0F4C12@.microsoft.com...
> > > > > Maybe my question is stupid, but I still post it here. Hope
somebody
> > can
> > > > give
> > > > > me an answer. MS released Service Pack 1 for Reporting services.
> > Should I
> > > > > only install the SP 1 into the server machine, or should I ask
each
> > user
> > > > > install the SP 1 in his/her computer to run reports?
> > > > >
> > > > > Thanks!
> > > >
> > > >
> > > >
> >
> >
> >|||It doesn't open a new window. It always open the subreport in the old window.
"Jeff Dillon" wrote:
> Again, define "not works"!!
> What happens' It doesn't open a new window? It opens a new window but
> doesn't display? ?
> Jeff
> "Jean" <Jean@.discussions.microsoft.com> wrote in message
> news:1393708D-AAD3-4807-9575-414EF2CE44CF@.microsoft.com...
> > Actually, I posted the question this morning.
> >
> > I have a report generated in Matrix. One of data field is a Hyperlink. I
> > used rs:LinkTarget=_blank to open a new window for a subreport. It works
> in
> > some computers, but not in other some computers. It really looks like work
> in
> > Win. 2000, but not Win XP. All of us use the updated IE.
> >
> > Any suggestion?
> >
> >
> > Thanks to everyone!
> >
> > "Jeff Dillon" wrote:
> >
> > > How different? Define "doesn't work"
> > >
> > > Jeff
> > > "Jean" <Jean@.discussions.microsoft.com> wrote in message
> > > news:567BAAD6-6C11-4C2E-9548-46DE8A3814FA@.microsoft.com...
> > > > But why my report runs very different in different computers? The same
> > > report
> > > > runs well in some users' computers, but doesn't work in other users'
> > > > computers? That makes me so frustrating.
> > > >
> > > >
> > > > Thanks!
> > > >
> > > > "Dennis Redfield" wrote:
> > > >
> > > > > server only .
> > > > >
> > > > > "Jean" <Jean@.discussions.microsoft.com> wrote in message
> > > > > news:4069EC0F-4D3B-46B6-A3F5-2D91CC0F4C12@.microsoft.com...
> > > > > > Maybe my question is stupid, but I still post it here. Hope
> somebody
> > > can
> > > > > give
> > > > > > me an answer. MS released Service Pack 1 for Reporting services.
> > > Should I
> > > > > > only install the SP 1 into the server machine, or should I ask
> each
> > > user
> > > > > > install the SP 1 in his/her computer to run reports?
> > > > > >
> > > > > > Thanks!
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>|||Did you look at the URLs generated? If they are correct, then something else
is wrong.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:87B7A2BE-866E-4C3E-8835-E0129918D2B2@.microsoft.com...
> It doesn't open a new window. It always open the subreport in the old
> window.
> "Jeff Dillon" wrote:
>> Again, define "not works"!!
>> What happens' It doesn't open a new window? It opens a new window but
>> doesn't display? ?
>> Jeff
>> "Jean" <Jean@.discussions.microsoft.com> wrote in message
>> news:1393708D-AAD3-4807-9575-414EF2CE44CF@.microsoft.com...
>> > Actually, I posted the question this morning.
>> >
>> > I have a report generated in Matrix. One of data field is a Hyperlink.
>> > I
>> > used rs:LinkTarget=_blank to open a new window for a subreport. It
>> > works
>> in
>> > some computers, but not in other some computers. It really looks like
>> > work
>> in
>> > Win. 2000, but not Win XP. All of us use the updated IE.
>> >
>> > Any suggestion?
>> >
>> >
>> > Thanks to everyone!
>> >
>> > "Jeff Dillon" wrote:
>> >
>> > > How different? Define "doesn't work"
>> > >
>> > > Jeff
>> > > "Jean" <Jean@.discussions.microsoft.com> wrote in message
>> > > news:567BAAD6-6C11-4C2E-9548-46DE8A3814FA@.microsoft.com...
>> > > > But why my report runs very different in different computers? The
>> > > > same
>> > > report
>> > > > runs well in some users' computers, but doesn't work in other
>> > > > users'
>> > > > computers? That makes me so frustrating.
>> > > >
>> > > >
>> > > > Thanks!
>> > > >
>> > > > "Dennis Redfield" wrote:
>> > > >
>> > > > > server only .
>> > > > >
>> > > > > "Jean" <Jean@.discussions.microsoft.com> wrote in message
>> > > > > news:4069EC0F-4D3B-46B6-A3F5-2D91CC0F4C12@.microsoft.com...
>> > > > > > Maybe my question is stupid, but I still post it here. Hope
>> somebody
>> > > can
>> > > > > give
>> > > > > > me an answer. MS released Service Pack 1 for Reporting
>> > > > > > services.
>> > > Should I
>> > > > > > only install the SP 1 into the server machine, or should I ask
>> each
>> > > user
>> > > > > > install the SP 1 in his/her computer to run reports?
>> > > > > >
>> > > > > > Thanks!
>> > > > >
>> > > > >
>> > > > >
>> > >
>> > >
>> > >
>>