Additional articles added ..

I was going through this link and had a question with regards to caveats
when new articles are added
The link is http://www.replicationanswers.com/No...alizations.asp
So Say i have nosync initially setup and everything is going on fine. I now
want to add new articles to the publication.
Can i not just do an sp_addarticle followed by a sp_addsubscription with
@.sync_type='automatic' and then run the snapshot agent.
Will that not apply the snapshot for just these new articles ?
Using Transactional Replication
Thanks
Yes, you're quite right. Section 2.1 is referring to the gui, but it is
possible to mix noinit and automatic in the same publication by scripts.
I've put this in as an interesting aside (attributed to yourself ),
although I maintain that this could lead to unmaintainable publications.
Rgds,
Paul Ibison
sql

adding image dynamically to crystal report

hello
please could anyone help me to insert an image into crystal report if I saved the link in the database . I tried to change the type to "ole object" it works, but i don't have to change the type in my project.If you are using SQL Server then search for TextCopy.exe, you will get lot of related code.|||it is very easy in the Crystal 11.5 and later.

Place the OLE object -> Bitmap Image on the report. Right click the OLE Object -> Format Graphics -> Picture (tab) -> Graphic Location.

And enter the URL where the image file is placed.
Now the crystal Report will show the image on runtime by picking from the location mentioned.|||i'm using v8.0 , i'll download the XI version and I'll try

Adding hyperlinks to rows in a table report

Is it possible to add hyperlinks to a table report.
I have been asked to add a link for each result in a table report to a
specific webpage.
I build the link to the webpage using queried data. (i.e.
="www.mywebsite.com/mypage/transientkey=" & fields.transientkey.value &
"&CompanyNum=" & fields.companynum.value & "&")
Any suggestions are greatly appreciated.
Thank you for your help.
--
SamyraUse the jump to URL action (right click on the control, properties,
navigation tab).
This shows how to make it open up in a new window. Also in this case I am
opening a report but you would just put in yours. I suggest using the
expression builder so you get the appropriate fields properly.
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/IT/HowTo+switch+between+InTouch.doc','_blank'))"
Also, you might try to first hard code the values and then modify the
expression to use the field values.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Samyra" <Samyra@.discussions.microsoft.com> wrote in message
news:639E0563-DEAA-4F3F-8053-72F8B7113D64@.microsoft.com...
> Is it possible to add hyperlinks to a table report.
> I have been asked to add a link for each result in a table report to a
> specific webpage.
> I build the link to the webpage using queried data. (i.e.
> ="www.mywebsite.com/mypage/transientkey=" & fields.transientkey.value &
> "&CompanyNum=" & fields.companynum.value & "&")
> Any suggestions are greatly appreciated.
> Thank you for your help.
> --
> Samyra

Adding additional data to a list of items

I am trying to create a report of inventory items and link sales history to the items. In one table I have all the items. In two other tables I have 30 day sales history and 90 day sales history data for the items that exist in the original list. I would like to add the sales history to the list of all the items. My linking of the items results in just those items with sales history however. I suspect that I am overlooking a simple way to keep the original list in tact and add the sales history to the items for which there is data.

Thanks for your help.

TechRickHave you tried using an outer join?|||Originally posted by proverbs53
Have you tried using an outer join?

Thanks! I'm glad it was that simple. Thanks for pointing the way!

Regards,
TechRick

Adding a user to a database in SQL Server Management Studio Express?

Can someone provide me with instructions or a link on how to add a user to a database using SQL Server Management studio Express?

I also would like to know how you set the db_owner permission to the user?

My host has an sql express database and I would like to use the same connection string on my local machine, but need to set up the username/pw on the database locally.

Thanks

go to the security tab of the management express

in the object explorer. double click logins to expand

right click and then add new user

from there you can grant the user access to database.

you can also open the database to add new user to it when you

already created a login in the security tab