maintenance plan wizard

Friday, March 30, 2012

Managed Stored Procedures

Can anyone point me to a good resource to create managed stored procedures in SQL 2005 Express using VB.NET and VS2003?You could create managed stored procedures only using .NET 2.0.
VS2003 use .NET 1.1.
Good article about VB.NET and SQL/CLR: http://www.devx.com/dotnet/Article/21286

Managed Store Procedure does not deploy

I have created a managed stored procdure in a sql server project in VS. I have put in the corect server name password and login fro the connection to the database.

When I deploy however it doesn't deploy the stored proccdure to the database even though it says it has successfully deployed the stored procedure. Has anyone had this

problem and how can you make sure it is deploying to the correct database.

Did you make sure it is deploying the stored procedure into the correct database? It might be deploying it in master.mdf.

sql

Managed Services?

Hello,
Does anyone know of any companies offering managed type services for SQL
Server?
Thanks in advance.
Any help would be greatly appreciated.I may be thinking too hard or not enough, but what do you mean by managed
services?
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:656FD08C-A27A-448A-AAFD-BFE4180D3610@.microsoft.com...
> Hello,
> Does anyone know of any companies offering managed type services for SQL
> Server?
> Thanks in advance.
> Any help would be greatly appreciated.|||1. Managed Hosting
2. Managed Monitoring
"Kevin3NF" wrote:
> I may be thinking too hard or not enough, but what do you mean by managed
> services?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Mark" <Mark@.discussions.microsoft.com> wrote in message
> news:656FD08C-A27A-448A-AAFD-BFE4180D3610@.microsoft.com...
> > Hello,
> >
> > Does anyone know of any companies offering managed type services for SQL
> > Server?
> >
> > Thanks in advance.
> > Any help would be greatly appreciated.
>
>|||You are wanting someone else to maintain your SQL Server install, or do you
just want hosted SQL Server access?
If you are just looking to outsource the management of your SQL Server admin
tasks...contact me offline :-)
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:E48FC353-E46A-4223-8A0E-F958B20544CF@.microsoft.com...
> 1. Managed Hosting
> 2. Managed Monitoring
> "Kevin3NF" wrote:
>> I may be thinking too hard or not enough, but what do you mean by managed
>> services?
>> --
>> Kevin Hill
>> President
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>> www.experts-exchange.com - experts compete for points to answer your
>> questions
>>
>> "Mark" <Mark@.discussions.microsoft.com> wrote in message
>> news:656FD08C-A27A-448A-AAFD-BFE4180D3610@.microsoft.com...
>> > Hello,
>> >
>> > Does anyone know of any companies offering managed type services for
>> > SQL
>> > Server?
>> >
>> > Thanks in advance.
>> > Any help would be greatly appreciated.
>>

Managed replacement for SQLDMO?

In VS 2003 I used SQLDMO (Com Object) to list all available SQL Servers. Is in SQL Server 2005 a managed .net Component that can do that task?

Thanks,
Rainer.

In SQL Server 2005 SMO(Sql management object) replaces DMO(data management object). I don't use DMO because DMO uses the system tables in the Master database which is Microsoft property. Microsoft make changes with service packs that can affect DMO based code. Try the link below for Microsoft provided tutorial on SMO. Hope this helps.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql_ovyukondev.asp

|||Thanks. Smo was the magic word ;). I found here a good article that solves my problem:http://www.yukonxml.com/articles/smo/

Rainer.

Managed Providers, Is it possible to use one not listed?

As I understand it, when setting up the data provider, even though it says
OLEDB that it is really using managed providers. The managed provider for
ODBC, for OLEDB, for SQL Server and for Oracle. So even though it says OLEDB
provider for Oracle it is really the managed provider. And even though it
says OLEDB Provider for SQL Server it is really the dotnet managed provider
for SQL Server.
First, is what I said correct?
Second. I have the dotnet managed provider for Sybase. I would like to use
this. Is it possible to use additional managed providers with RS? If so, how
do I do this? Thanks,
Bruce L-C#1:
What matters for the ReportServer is only the contents of the RDL file. If
the RDL says:
<ConnectionProperties>
<DataProvider>ORACLE</DataProvider>
<ConnectString>data source=server</ConnectString>
</ConnectionProperties>
it will use the managed Oracle provider.
This provider is registered in the config files (designer, server) as:
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
er,Microsoft.ReportingServices.DataExtensions" />
Note: the behavior of PREVIEW in Report Designer is identical to the
ReportServer behavior!
However the DATA view in Report Designer is different for the visual
designer:
* the visual query designer with 4 panes will internally always use OleDB
providers for verifying and executing queries directly in "Data" view. (Main
reason: the visual query designer does not work with managed providers).
Example: if you choose "Oracle" in the data source dialog, the Data view has
to use the OleDB provider for Oracle behind the scenes, but Preview and
Server will use the managed Oracle provider.
* the generic text-based query designer (2 panes) will _always_ use the data
provider you specified.
#2:
Yes, in general you can use managed third party data providers. I'm not
familiar with the managed Sybase provider, but here is how you would
register the Oracle ODP.NET provider in RSReportServer.config:
<Extension Name="ODP"
Type="Oracle.DataAccess.Client.OracleConnection,Oracle.DataAccess"/>
See also:
http://msdn.microsoft.com/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_8iqq.asp
When using a managed provider, you can either use it directly (by just
registering it correctly in the config file as shown above) or write a
custom data extension which internally uses the provider. If the managed
Sybase provider behaves similarly as the MS managed providers, then you will
be able to use it in both, Report Designer and Report Server.
However, if it is implemented similar to the Oracle ODP.NET provider, you
can only use it directly within the report server right now, but it won't
work with report designer to design queries. The reason for this is related
to the way the ODP.NET provider is implemented by Oracle (and the way it
modifies database connection properties after the connection is opened). We
will try to avoid this issue by a code change for our SP2, so it should then
be possible to use ODP.NET in Report Designer also.
Would be very interesting to know if the managed Sybase provider works in
both, designer and server. At least it will work with the server.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23wAdnlQaEHA.752@.TK2MSFTNGP09.phx.gbl...
> As I understand it, when setting up the data provider, even though it says
> OLEDB that it is really using managed providers. The managed provider for
> ODBC, for OLEDB, for SQL Server and for Oracle. So even though it says
OLEDB
> provider for Oracle it is really the managed provider. And even though it
> says OLEDB Provider for SQL Server it is really the dotnet managed
provider
> for SQL Server.
> First, is what I said correct?
> Second. I have the dotnet managed provider for Sybase. I would like to use
> this. Is it possible to use additional managed providers with RS? If so,
how
> do I do this? Thanks,
> Bruce L-C
>|||Thanks for the detailed reply. I'll let you know how I fare.
Bruce L-C
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:Omp0wbRaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> #1:
> What matters for the ReportServer is only the contents of the RDL file. If
> the RDL says:
> <ConnectionProperties>
> <DataProvider>ORACLE</DataProvider>
> <ConnectString>data source=server</ConnectString>
> </ConnectionProperties>
> it will use the managed Oracle provider.
> This provider is registered in the config files (designer, server) as:
> <Extension Name="ORACLE"
>
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
> er,Microsoft.ReportingServices.DataExtensions" />
> Note: the behavior of PREVIEW in Report Designer is identical to the
> ReportServer behavior!
> However the DATA view in Report Designer is different for the visual
> designer:
> * the visual query designer with 4 panes will internally always use OleDB
> providers for verifying and executing queries directly in "Data" view.
(Main
> reason: the visual query designer does not work with managed providers).
> Example: if you choose "Oracle" in the data source dialog, the Data view
has
> to use the OleDB provider for Oracle behind the scenes, but Preview and
> Server will use the managed Oracle provider.
> * the generic text-based query designer (2 panes) will _always_ use the
data
> provider you specified.
>
> #2:
> Yes, in general you can use managed third party data providers. I'm not
> familiar with the managed Sybase provider, but here is how you would
> register the Oracle ODP.NET provider in RSReportServer.config:
> <Extension Name="ODP"
> Type="Oracle.DataAccess.Client.OracleConnection,Oracle.DataAccess"/>
> See also:
>
http://msdn.microsoft.com/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_8iqq.asp
> When using a managed provider, you can either use it directly (by just
> registering it correctly in the config file as shown above) or write a
> custom data extension which internally uses the provider. If the managed
> Sybase provider behaves similarly as the MS managed providers, then you
will
> be able to use it in both, Report Designer and Report Server.
> However, if it is implemented similar to the Oracle ODP.NET provider, you
> can only use it directly within the report server right now, but it won't
> work with report designer to design queries. The reason for this is
related
> to the way the ODP.NET provider is implemented by Oracle (and the way it
> modifies database connection properties after the connection is opened).
We
> will try to avoid this issue by a code change for our SP2, so it should
then
> be possible to use ODP.NET in Report Designer also.
> Would be very interesting to know if the managed Sybase provider works in
> both, designer and server. At least it will work with the server.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23wAdnlQaEHA.752@.TK2MSFTNGP09.phx.gbl...
> > As I understand it, when setting up the data provider, even though it
says
> > OLEDB that it is really using managed providers. The managed provider
for
> > ODBC, for OLEDB, for SQL Server and for Oracle. So even though it says
> OLEDB
> > provider for Oracle it is really the managed provider. And even though
it
> > says OLEDB Provider for SQL Server it is really the dotnet managed
> provider
> > for SQL Server.
> >
> > First, is what I said correct?
> >
> > Second. I have the dotnet managed provider for Sybase. I would like to
use
> > this. Is it possible to use additional managed providers with RS? If so,
> how
> > do I do this? Thanks,
> >
> > Bruce L-C
> >
> >
>sql

Friday, March 30, 2012

Managed Stored Procedures

Managed Store Procedure does not deploy

Managed Services?

Managed Services?

Managed Services?

Managed replacement for SQLDMO?

Managed Providers, Is it possible to use one not listed?

maintenance plan wizard

Blog Archive

About Me