Can I Deploy a report to a client who doesn't have SQL server license.

How can I Deploy a report with my visual Studio.Net application to a company
who doesn't have SQL server license?
I plan to use SQL Server 2005 Express.SQL Server Express does not yet have support for this. Supposedly Q1. Then
the data needs to reside locally as well.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> How can I Deploy a report with my visual Studio.Net application to a
> company who doesn't have SQL server license?
> I plan to use SQL Server 2005 Express.
>|||VS2005 provide a report viewer control which allow you to render reports.
does your application is web or windows based?
"Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> How can I Deploy a report with my visual Studio.Net application to a
> company who doesn't have SQL server license?
> I plan to use SQL Server 2005 Express.
>|||Hi Roberto,
As Bruce mentioned, the SQL Server reporting service is not available for
EXPRESS edition so far. Also, what's your application's detailed structure,
does it require a local SQL Server instance? If it is just a client
application which can consume reporting service reports through those
remote accessible programming interfaces, we can consider separate the
application from the backend SQL Server database... Thus, there need a
certain DataBase server which have SQL Server 2005 instance installed
already...
Regards,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| From: "Jéj? <willgart@.BBBhotmailAAA.com>
| References: <#uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl>
| Subject: Re: Can I Deploy a report to a client who doesn't have SQL
server license.
| Date: Thu, 26 Jan 2006 21:35:45 -0500
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Response
| Message-ID: <emzDhpuIGHA.424@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: modemcable008.41-80-70.mc.videotron.ca 70.80.41.8
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67651
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| VS2005 provide a report viewer control which allow you to render reports.
| does your application is web or windows based?
|
| "Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
| news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
| > How can I Deploy a report with my visual Studio.Net application to a
| > company who doesn't have SQL server license?
| >
| > I plan to use SQL Server 2005 Express.
| >
|
|
||||RDLC reports doesn't required any server.
its standalone reports generated on the client side, not the server side.
Also, I think that the report control can render RDL reports without using a
reportserver.
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:TUqDfawIGHA.1236@.TK2MSFTNGXA02.phx.gbl...
> Hi Roberto,
> As Bruce mentioned, the SQL Server reporting service is not available for
> EXPRESS edition so far. Also, what's your application's detailed
> structure,
> does it require a local SQL Server instance? If it is just a client
> application which can consume reporting service reports through those
> remote accessible programming interfaces, we can consider separate the
> application from the backend SQL Server database... Thus, there need a
> certain DataBase server which have SQL Server 2005 instance installed
> already...
> Regards,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>
> --
> | From: "Jéj? <willgart@.BBBhotmailAAA.com>
> | References: <#uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl>
> | Subject: Re: Can I Deploy a report to a client who doesn't have SQL
> server license.
> | Date: Thu, 26 Jan 2006 21:35:45 -0500
> | Lines: 12
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | X-RFC2646: Format=Flowed; Response
> | Message-ID: <emzDhpuIGHA.424@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: modemcable008.41-80-70.mc.videotron.ca 70.80.41.8
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:67651
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | VS2005 provide a report viewer control which allow you to render
> reports.
> | does your application is web or windows based?
> |
> | "Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
> | news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> | > How can I Deploy a report with my visual Studio.Net application to a
> | > company who doesn't have SQL server license?
> | >
> | > I plan to use SQL Server 2005 Express.
> | >
> |
> |
> |
>

Can dump file naming convention be specified using Maintence Plan

Hi,
For a 'complete backup' using Maintenance Plan the naming convention
now is
DBNAMEmo.dy.yr_hr_sc
Can this changed or is it hardcoded?
TIA
-Roman
Management Console 2.0
SQL Enterpise Manager 8.0To the best of my knowledge, it is hardcoded. Only thing you can change is extension of the files.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<romandvoskin@.gmail.com> wrote in message
news:1150912826.206544.128420@.i40g2000cwc.googlegroups.com...
> Hi,
> For a 'complete backup' using Maintenance Plan the naming convention
> now is
> DBNAMEmo.dy.yr_hr_sc
> Can this changed or is it hardcoded?
> TIA
> -Roman
> Management Console 2.0
> SQL Enterpise Manager 8.0
>

Can dump file naming convention be specified using Maintence Plan

Hi,
For a 'complete backup' using Maintenance Plan the naming convention
now is
DBNAMEmo.dy.yr_hr_sc
Can this changed or is it hardcoded?
TIA
-Roman
Management Console 2.0
SQL Enterpise Manager 8.0To the best of my knowledge, it is hardcoded. Only thing you can change is e
xtension of the files.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<romandvoskin@.gmail.com> wrote in message
news:1150912826.206544.128420@.i40g2000cwc.googlegroups.com...
> Hi,
> For a 'complete backup' using Maintenance Plan the naming convention
> now is
> DBNAMEmo.dy.yr_hr_sc
> Can this changed or is it hardcoded?
> TIA
> -Roman
> Management Console 2.0
> SQL Enterpise Manager 8.0
>|||To the best of my knowledge, it is hardcoded. Only thing you can change is e
xtension of the files.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<romandvoskin@.gmail.com> wrote in message
news:1150912826.206544.128420@.i40g2000cwc.googlegroups.com...
> Hi,
> For a 'complete backup' using Maintenance Plan the naming convention
> now is
> DBNAMEmo.dy.yr_hr_sc
> Can this changed or is it hardcoded?
> TIA
> -Roman
> Management Console 2.0
> SQL Enterpise Manager 8.0
>

calling stored procedures on different servers

I'm using reporting services to build a report and I plan on using a stored procedure to gather my data for the report. My question is:

I know it's possible to call a stored procedure from a stored procedure, both within the same dB and in different dB's, but is it possible to call a SP that's on a different server? My gut says "definitely not. at least not easily." But I wanted to see if anyone had any thoughts on this before I pursue a different course of action.Lookup "Linked Server" in books online and you will get lots of information on linking servers, which should then allow you to execute the SP on another server.|||Do you have any examples or know where I can find some of a stored procedure that uses a linked server? thanks for the help!

jonathan|||Actually, I got it to work. Thanks again!

jonathan