Can I create subscriptions programatically?

Is that possible? if so please point me in the right direction.There is sample code in a MS KB here that does it. I also think it is a good basis for more research along the same avenue.
|||This article doesnt talk anything about reporting services|||Yes, you can create and manage subscriptions through the SOAP API.
Check MSDN: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_ak_20ft.asp

-- Robert|||I was looking at the example on the MSDN, and on the link provided above, I was trying to reference system.web.services.protols, but it was not found.

I am trying to set up a dynamic subscription application so that users can run a certain report with certain parameters on a monthly basis, or off peak hours, and have the report emailed/placed on a network drive. It seems however, I am missing a key point to getting this application created, since I am unable to reference services.protocols...

Any help plz?

Can I backup SQl server 2005 databases with Shadow Copies (VSS)

Good Day,
I would like to create shadow copies of our SQL databases as a way of
providing temporary point in time backups. I was thinking of doing the
following:-
1) Hidden share of the DB folders (mdf/ldf).
2) Apply NTFS as precaution.
3) Store shadow copies on external drive.
4) Create copies every 30/60 minutes.
Would this cause a problem with the SQL server 2005? Would a restoration be
as simple as restoring the mdf & ldf files? It is a live server and I would
not want to cause any probs so thought I would look/check around. I have
googled but can only find pages with people using VSS programatically.
Kind Regards,
Paul Johnson.
--
<a href="http://links.10026.com/?link=http://www.crossloop.com/PaulJohnson?type=email"
target="_blank"><img border = "0"
src="http://pics.10026.com/?src=http://www.crossloop.com/images/badge-sm-gray.jpg" alt="Get help from
Paul Johnson!" /></a>"Paul Johnson" <paul.johnson@.gaapweb.com> wrote in message
news:e7f$JL8nIHA.2292@.TK2MSFTNGP03.phx.gbl...
> Good Day,
> I would like to create shadow copies of our SQL databases as a way of
> providing temporary point in time backups. I was thinking of doing the
> following:-
> 1) Hidden share of the DB folders (mdf/ldf).
> 2) Apply NTFS as precaution.
> 3) Store shadow copies on external drive.
> 4) Create copies every 30/60 minutes.
> Would this cause a problem with the SQL server 2005? Would a restoration
> be as simple as restoring the mdf & ldf files? It is a live server and I
> would not want to cause any probs so thought I would look/check around. I
> have googled but can only find pages with people using VSS
> programatically.
> Kind Regards,
> Paul Johnson.
>
> --
> <a href="http://links.10026.com/?link=http://www.crossloop.com/PaulJohnson?type=email"
> target="_blank"><img border = "0"
> src="http://pics.10026.com/?src=http://www.crossloop.com/images/badge-sm-gray.jpg" alt="Get help from
> Paul Johnson!" /></a>
Hi Paul
As I understand it, you would need to implement your backup solution using
the VSS API or an application that uses it. NTBackup seems to only be able
to cope with databases that are using SIMPLE recovery mode.
Without backing up the logs, you will not have any ability to rollforward
your transactions, therefore your solution is going to incorporate some data
loss.
John|||I have not looked into shadow copy with SQL Server closely to be able to
comment on your proposed approach intelligently. But one thing I do know is
that your proposed approach is not a common one. So unless you are doing a
POC or just exploring, I'd suggest you don't go there since there are other
much more 'mature' approach to meeting your requirements.
Linchi
"Paul Johnson" wrote:
> Good Day,
> I would like to create shadow copies of our SQL databases as a way of
> providing temporary point in time backups. I was thinking of doing the
> following:-
> 1) Hidden share of the DB folders (mdf/ldf).
> 2) Apply NTFS as precaution.
> 3) Store shadow copies on external drive.
> 4) Create copies every 30/60 minutes.
> Would this cause a problem with the SQL server 2005? Would a restoration be
> as simple as restoring the mdf & ldf files? It is a live server and I would
> not want to cause any probs so thought I would look/check around. I have
> googled but can only find pages with people using VSS programatically.
> Kind Regards,
> Paul Johnson.
>
> --
> <a href="http://links.10026.com/?link=http://www.crossloop.com/PaulJohnson?type=email"
> target="_blank"><img border = "0"
> src="http://pics.10026.com/?src=http://www.crossloop.com/images/badge-sm-gray.jpg" alt="Get help from
> Paul Johnson!" /></a>
>
>|||Good Day Linchi,
Thank you for your reply.
I was hoping to avoid using a backup program to do this Shadow Copies offers
exactly what I want and it works in the background. I guess I will have to
use our regular backup software.
Thanks once again.
Kind Regards,
Paul Johnson.
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:99C5AB60-74B5-4166-A943-C86288A92F1C@.microsoft.com...
>I have not looked into shadow copy with SQL Server closely to be able to
> comment on your proposed approach intelligently. But one thing I do know
> is
> that your proposed approach is not a common one. So unless you are doing a
> POC or just exploring, I'd suggest you don't go there since there are
> other
> much more 'mature' approach to meeting your requirements.
> Linchi
> "Paul Johnson" wrote:
>> Good Day,
>> I would like to create shadow copies of our SQL databases as a way of
>> providing temporary point in time backups. I was thinking of doing the
>> following:-
>> 1) Hidden share of the DB folders (mdf/ldf).
>> 2) Apply NTFS as precaution.
>> 3) Store shadow copies on external drive.
>> 4) Create copies every 30/60 minutes.
>> Would this cause a problem with the SQL server 2005? Would a restoration
>> be
>> as simple as restoring the mdf & ldf files? It is a live server and I
>> would
>> not want to cause any probs so thought I would look/check around. I have
>> googled but can only find pages with people using VSS programatically.
>> Kind Regards,
>> Paul Johnson.
>>
>> --
>> <a href="http://links.10026.com/?link=http://www.crossloop.com/PaulJohnson?type=email"
>> target="_blank"><img border = "0"
>> src="http://pics.10026.com/?src=http://www.crossloop.com/images/badge-sm-gray.jpg" alt="Get help
>> from
>> Paul Johnson!" /></a>
>>|||Thank you for your reply.
I was hoping to avoid using a backup program to do this. Shadow Copies
offers exactly what I want and it works in the background. I guess I will
have to use our regular backup software or just get SQL server to create
backups to the drive on a schedule.
Thanks once again.
Kind Regards,
Paul Johnson.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:u3Ktnr8nIHA.1768@.TK2MSFTNGP03.phx.gbl...
> "Paul Johnson" <paul.johnson@.gaapweb.com> wrote in message
> news:e7f$JL8nIHA.2292@.TK2MSFTNGP03.phx.gbl...
>> Good Day,
>> I would like to create shadow copies of our SQL databases as a way of
>> providing temporary point in time backups. I was thinking of doing the
>> following:-
>> 1) Hidden share of the DB folders (mdf/ldf).
>> 2) Apply NTFS as precaution.
>> 3) Store shadow copies on external drive.
>> 4) Create copies every 30/60 minutes.
>> Would this cause a problem with the SQL server 2005? Would a restoration
>> be as simple as restoring the mdf & ldf files? It is a live server and I
>> would not want to cause any probs so thought I would look/check around. I
>> have googled but can only find pages with people using VSS
>> programatically.
>> Kind Regards,
>> Paul Johnson.
>>
>> --
>> <a href="http://links.10026.com/?link=http://www.crossloop.com/PaulJohnson?type=email"
>> target="_blank"><img border = "0"
>> src="http://pics.10026.com/?src=http://www.crossloop.com/images/badge-sm-gray.jpg" alt="Get help
>> from Paul Johnson!" /></a>
> Hi Paul
> As I understand it, you would need to implement your backup solution using
> the VSS API or an application that uses it. NTBackup seems to only be able
> to cope with databases that are using SIMPLE recovery mode.
> Without backing up the logs, you will not have any ability to rollforward
> your transactions, therefore your solution is going to incorporate some
> data loss.
> John
>|||"Paul Johnson" <paul.johnson@.gaapweb.com> wrote in message
news:e7f$JL8nIHA.2292@.TK2MSFTNGP03.phx.gbl...
> Good Day,
> I would like to create shadow copies of our SQL databases as a way of
> providing temporary point in time backups. I was thinking of doing the
> following:-
Why not use normal SQL Server backups?
Or if you have Enterprise you can also take snapshots.
> 1) Hidden share of the DB folders (mdf/ldf).
> 2) Apply NTFS as precaution.
> 3) Store shadow copies on external drive.
> 4) Create copies every 30/60 minutes.
> Would this cause a problem with the SQL server 2005? Would a restoration
> be as simple as restoring the mdf & ldf files? It is a live server and I
> would not want to cause any probs so thought I would look/check around. I
> have googled but can only find pages with people using VSS
> programatically.
> Kind Regards,
> Paul Johnson.
>
> --
> <a href="http://links.10026.com/?link=http://www.crossloop.com/PaulJohnson?type=email"
> target="_blank"><img border = "0"
> src="http://pics.10026.com/?src=http://www.crossloop.com/images/badge-sm-gray.jpg" alt="Get help from
> Paul Johnson!" /></a>
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||"Paul Johnson" <paul.johnson@.gaapweb.com> wrote in message
news:%23z0$3F%23nIHA.3900@.TK2MSFTNGP05.phx.gbl...
> Good Day Linchi,
> Thank you for your reply.
> I was hoping to avoid using a backup program to do this Shadow Copies
> offers exactly what I want and it works in the background. I guess I will
> have to use our regular backup software.
Unless your regular backup software is SQL Server aware, I would not go down
this route.
> Thanks once again.
> Kind Regards,
> Paul Johnson.
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:99C5AB60-74B5-4166-A943-C86288A92F1C@.microsoft.com...
>>I have not looked into shadow copy with SQL Server closely to be able to
>> comment on your proposed approach intelligently. But one thing I do know
>> is
>> that your proposed approach is not a common one. So unless you are doing
>> a
>> POC or just exploring, I'd suggest you don't go there since there are
>> other
>> much more 'mature' approach to meeting your requirements.
>> Linchi
>> "Paul Johnson" wrote:
>> Good Day,
>> I would like to create shadow copies of our SQL databases as a way of
>> providing temporary point in time backups. I was thinking of doing the
>> following:-
>> 1) Hidden share of the DB folders (mdf/ldf).
>> 2) Apply NTFS as precaution.
>> 3) Store shadow copies on external drive.
>> 4) Create copies every 30/60 minutes.
>> Would this cause a problem with the SQL server 2005? Would a restoration
>> be
>> as simple as restoring the mdf & ldf files? It is a live server and I
>> would
>> not want to cause any probs so thought I would look/check around. I have
>> googled but can only find pages with people using VSS programatically.
>> Kind Regards,
>> Paul Johnson.
>>
>> --
>> <a href="http://links.10026.com/?link=http://www.crossloop.com/PaulJohnson?type=email"
>> target="_blank"><img border = "0"
>> src="http://pics.10026.com/?src=http://www.crossloop.com/images/badge-sm-gray.jpg" alt="Get help
>> from
>> Paul Johnson!" /></a>
>>
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Can i add a back button on report view ?

Hi all:

I have a asp.net webpage , which has a button to point to a report (by using URL)

Now what i want is another way around , having a back button on report view page, so

that user can click back button to vew the web page.

Is that possible to do it in Report Service?

Thanks

Nick

Hi Nick,

While I would say using the back button in IE is the easy way, there is another way to add a button to a report. Take a look at the custom report item functionality of RS.

Informative link:

http://msdn.microsoft.com/msdnmag/issues/06/10/SQLServer2005/default.aspx

Can disable DTC or Transactions when I use OLEDB provider for Oracle?

Hi,
I am trying to improve my data export operation. At this point I need to
disable implicit transactions when I use insert into [Linked Table] command.
How can disable transactions when I do a distributed insert or use DTS to
export table data ?
Thank you,
MaxHello Max,
You could disable transaction by right click the
package->Properties->Advanced, uncheck "transaction"
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Maxwell2006" <alanalan@.newsgroup.nospam>
>Subject: Can disable DTC or Transactions when I use OLEDB provider for
Oracle?
>Date: Tue, 4 Apr 2006 14:18:01 -0400
>Lines: 19
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.1830
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Message-ID: <eES89OBWGHA.5044@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: mtl-hse-ppp170505.qc.sympatico.ca 65.94.105.17
>Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP0
9.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:426864
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hi,
>
>I am trying to improve my data export operation. At this point I need to
>disable implicit transactions when I use insert into [Linked Table]
command.
>
>How can disable transactions when I do a distributed insert or use DTS to
>export table data ?
>
>Thank you,
>Max
>
>