how to determine sp level at app install time?

Hi,
I have an application that uses an instance of MSDE we create. What should
our installer check to find out if we need to install msde sp3, when our
users upgrade our software?
thanks,
David
Hi,
Installation of ur application require a valid login to sql server right,
then you could verify the service pack by executing the below query.
SELECT SERVERPROPERTY('PRODUCTLEVEL')
This returns SP3 if the service pack installed is SP3. Based on this u could
continue the installation.
Thanks
Hari
SQL Server Mvp
"David Burson" <DavidBurson@.discussions.microsoft.com> wrote in message
news:C52717FF-A27E-4686-89ED-01AA4FDAF179@.microsoft.com...
> Hi,
> I have an application that uses an instance of MSDE we create. What
> should
> our installer check to find out if we need to install msde sp3, when our
> users upgrade our software?
> thanks,
> David
|||Thanks Hari,
We have a problem with that solution though. I guess we need to use osql to
run the serverproperty query, but we don't know how to run it so that the
user doesn't see it run, and also we don't know how to get the response from
osql back into our installer code.
Do you have any suggestions on how to handle those issues?
Thanks very much!
David
"Hari Prasad" wrote:

> Hi,
> Installation of ur application require a valid login to sql server right,
> then you could verify the service pack by executing the below query.
> SELECT SERVERPROPERTY('PRODUCTLEVEL')
> This returns SP3 if the service pack installed is SP3. Based on this u could
> continue the installation.
> Thanks
> Hari
> SQL Server Mvp
> "David Burson" <DavidBurson@.discussions.microsoft.com> wrote in message
> news:C52717FF-A27E-4686-89ED-01AA4FDAF179@.microsoft.com...
>
>

how to determine if Cross DB Ownership Chaining

During the SQL Server install the Cross DB Ownership Chaining option can be
turned on at the server level. How can I determine if the server has it
turned on?
Thanks.
EXEC sp_dboption 'database_name','db chaining'
David Portas
SQL Server MVP
|||That should be the sp_configure setting. Please read about this setting in Books Online so you
understand the relationship with the database setting as well...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
news:2504E3E6-5757-476B-BA57-E3AC890D9FBF@.microsoft.com...
> During the SQL Server install the Cross DB Ownership Chaining option can be
> turned on at the server level. How can I determine if the server has it
> turned on?
> Thanks.
|||Sorry, you asked for the server setting. Use sp_configure as Tibor says.
David Portas
SQL Server MVP
|||Thanks Tibor and David!!!

how to determine if Cross DB Ownership Chaining

During the SQL Server install the Cross DB Ownership Chaining option can be
turned on at the server level. How can I determine if the server has it
turned on?
Thanks.EXEC sp_dboption 'database_name','db chaining'
--
David Portas
SQL Server MVP
--|||That should be the sp_configure setting. Please read about this setting in Books Online so you
understand the relationship with the database setting as well...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
news:2504E3E6-5757-476B-BA57-E3AC890D9FBF@.microsoft.com...
> During the SQL Server install the Cross DB Ownership Chaining option can be
> turned on at the server level. How can I determine if the server has it
> turned on?
> Thanks.|||Sorry, you asked for the server setting. Use sp_configure as Tibor says.
--
David Portas
SQL Server MVP
--|||Thanks Tibor and David!!!

how to determine if Cross DB Ownership Chaining

During the SQL Server install the Cross DB Ownership Chaining option can be
turned on at the server level. How can I determine if the server has it
turned on?
Thanks.EXEC sp_dboption 'database_name','db chaining'
David Portas
SQL Server MVP
--|||That should be the sp_configure setting. Please read about this setting in B
ooks Online so you
understand the relationship with the database setting as well...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
news:2504E3E6-5757-476B-BA57-E3AC890D9FBF@.microsoft.com...
> During the SQL Server install the Cross DB Ownership Chaining option can b
e
> turned on at the server level. How can I determine if the server has it
> turned on?
> Thanks.|||Sorry, you asked for the server setting. Use sp_configure as Tibor says.
David Portas
SQL Server MVP
--|||Thanks Tibor and David!!!

How to determinate if I have install sp1 of SqlExpress

Hi,
How to determinate if I have install the sp1 of SqlServer 2005 Express?ad
SELECT @.@.Version?
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:uC8pZYHfGHA.1276@.TK2MSFTNGP03.phx.gbl...
> Hi,
> How to determinate if I have install the sp1 of SqlServer 2005 Express?
>

How to determinate if I have install sp1 of SqlExpress

Hi,
How to determinate if I have install the sp1 of SqlServer 2005 Express?ad
SELECT @.@.Version?
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:uC8pZYHfGHA.1276@.TK2MSFTNGP03.phx.gbl...
> Hi,
> How to determinate if I have install the sp1 of SqlServer 2005 Express?
>sql

How to detect whether SMO is installed?

Hi, folks --
I am working on an install bootstrapper that (among other things)
will install Server Management Objects (SQLServer2005_XMO.msi from SQL
Server 2005 Feature Pack) iff it's not already installed.
So, how to detect programmatically whether or not it's already
installed?
What files/version/registry keys/usual suspects should I be looking
for?
Thanks in advance for your help.
-- Davidson
Hello n7dai@.comcast.net,
I normally look for C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\Microsoft.SqlServer.Smo.d ll.
I believe current-most is 9.0.3042.0.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
|||What about:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=577731&SiteID=1
Jens K. Suessmeyer.
http://www.sqlserver2005.de
<n7dai@.comcast.net> wrote in message
news:1175273193.753957.182290@.e65g2000hsc.googlegr oups.com...
> Hi, folks --
> I am working on an install bootstrapper that (among other things)
> will install Server Management Objects (SQLServer2005_XMO.msi from SQL
> Server 2005 Feature Pack) iff it's not already installed.
> So, how to detect programmatically whether or not it's already
> installed?
> What files/version/registry keys/usual suspects should I be looking
> for?
> Thanks in advance for your help.
> -- Davidson
>

How to Deploye VB.net Application Along With Database....Please Help.

Hi Guys,
I had a little Problem With My Application Deployment.

I want To Make Setup For My Application(VB.NET) Such that When it begins To Install,The Database Of the Application Will Automaticallly Get Installed.....
Even I have Generated Script For That But I dont Know How to Execute It With Installation File.I have made Complete Setup Of My Application Exept Database.

Now,I want Few Code Lines To Execute My Database Script.
So how can i Execute My Script Through Installation..

And Also If there is another Way To Accomplish This Please Suggest Me.

All Suggestions Will be Accepted...

Thanx In Advance..WOuld C# code also be ok for you ? :-)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||yes it will be ok for me..

How to deploy an report and connection string from some xml file

Suppose we are two developer.Who have SSRS install at there own system.
Our database server is intalled on our main db server.

1,First thing does it necessay to create a shared datasource.
I have a web application in which I want's to add a folder say My reports in which i will put my reports {that is .rdl file}
Then I want's to hit a url with render format as excel this will bring down my report in excel format.

2,How to configure a connection
I want's to pass the connection string in the rdl via some xml file let say myconnectionn xml file
which look like
<connection-sources>
<source name="Mycon1" default="true" >
Data Source=abc\yukon;User ID=sa;Password=as;Initial Catalog=MyDbName1
</source>
<source name="Mycon2" skip="true" >
Data Source=asdsadabc\yukon;User ID=sa;Password=as;Initial Catalog=MyDbName2
</source>
</connection-sources>

connection string would be where attribute default of source should be true.

1. Shared data sources are used to define a connection once, and share it among multiple reports. That way, if the connection information changes, you only have to update the shared data source, and not each report. You don't have to use shared data sources, though. Data sources can be defined at a report level as well.

2. You can create a connection string from an expression, which would allow you to change the connect string at runtime based on parameters passed to the report. However, as far as I am aware, you cannot use an XML file directly to set the connect string.

|||

Thanks jwelch.

Then any work around ?

|||Use an expression based connection and pass your connection string (or components of it) in as parameters.|||

What is an expression based connection and how can I pass my connection string (or components of it) in as parameters.

Please let it clear a little bit ?

|||

You can create an expression based connection by going to the data tab of your report. Open up the dataset properties (by clicking the ellipsis (...) beside the dataset dropdown), and then click the ellipsis next to the data source. If the Use shared reference option is checked, uncheck it. You should then be able to select the fx button next to the connection string box. You can enter an expression into the resulting dialog, such as:

Dynamic Connection String

="Data Source="+Parameters!Server.Value+";Initial Catalog="+Parameters!Database.Value

You'll need to create the parameters on the report to hold the values you want, and you may need to alter the connection string in my example to match your database provider.

Hope this helps.

How to deploy an report and connection string from some xml file

Suppose we are two developer.Who have SSRS install at there own system.
Our database server is intalled on our main db server.

1,First thing does it necessay to create a shared datasource.
I have a web application in which I want's to add a folder say My reports in which i will put my reports {that is .rdl file}
Then I want's to hit a url with render format as excel this will bring down my report in excel format.

2,How to configure a connection
I want's to pass the connection string in the rdl via some xml file let say myconnectionn xml file
which look like
<connection-sources>
<source name="Mycon1" default="true" >
Data Source=abc\yukon;User ID=sa;Password=as;Initial Catalog=MyDbName1
</source>
<source name="Mycon2" skip="true" >
Data Source=asdsadabc\yukon;User ID=sa;Password=as;Initial Catalog=MyDbName2
</source>
</connection-sources>

connection string would be where attribute default of source should be true.

1. Shared data sources are used to define a connection once, and share it among multiple reports. That way, if the connection information changes, you only have to update the shared data source, and not each report. You don't have to use shared data sources, though. Data sources can be defined at a report level as well.

2. You can create a connection string from an expression, which would allow you to change the connect string at runtime based on parameters passed to the report. However, as far as I am aware, you cannot use an XML file directly to set the connect string.

|||

Thanks jwelch.

Then any work around ?

|||Use an expression based connection and pass your connection string (or components of it) in as parameters.|||

What is an expression based connection and how can I pass my connection string (or components of it) in as parameters.

Please let it clear a little bit ?

|||

You can create an expression based connection by going to the data tab of your report. Open up the dataset properties (by clicking the ellipsis (...) beside the dataset dropdown), and then click the ellipsis next to the data source. If the Use shared reference option is checked, uncheck it. You should then be able to select the fx button next to the connection string box. You can enter an expression into the resulting dialog, such as:

Dynamic Connection String

="Data Source="+Parameters!Server.Value+";Initial Catalog="+Parameters!Database.Value

You'll need to create the parameters on the report to hold the values you want, and you may need to alter the connection string in my example to match your database provider.

Hope this helps.