How to detect INSTALLED SQL version?

Hello,
I need to detect whether the computer has SQL Server 2000 SP3 installed
before
attempting to connect to it, for example during my custom setup program. Wha
t
is the recommended way of doing this?
TIA,
A.SELECT TOP 0 NULL AS Property , NULL AS Variable
UNION ALL SELECT 'Version' , SERVERPROPERTY( 'ProductVersion' )
UNION ALL SELECT 'Level' , SERVERPROPERTY( 'ProductLevel' )
UNION ALL SELECT 'Engine Edition' , SERVERPROPERTY( 'Edition' )
"Abbey" <Abbey@.discussions.microsoft.com> wrote in message
news:1D2E126E-B6FE-411C-B157-FD3BBB49CE82@.microsoft.com...
> Hello,
> I need to detect whether the computer has SQL Server 2000 SP3 installed
> before
> attempting to connect to it, for example during my custom setup program.
What
> is the recommended way of doing this?
> TIA,
> A.
>|||HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQLServer\MSSQLServer\CurrentVe
rsion\
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server\<instance
name>\MSSQLServer\CurrentVersion\
Key name = CSDVersion (not CurrentVersion).
"Abbey" <Abbey@.discussions.microsoft.com> wrote in message
news:1D2E126E-B6FE-411C-B157-FD3BBB49CE82@.microsoft.com...
> Hello,
> I need to detect whether the computer has SQL Server 2000 SP3 installed
> before
> attempting to connect to it, for example during my custom setup program.
> What
> is the recommended way of doing this?
> TIA,
> A.
>|||This won't work "before attempting to connect to it"... you have to be
connected to the server to run your query...

> SELECT TOP 0 NULL AS Property , NULL AS Variable
> UNION ALL SELECT 'Version' , SERVERPROPERTY( 'ProductVersion' )
> UNION ALL SELECT 'Level' , SERVERPROPERTY( 'ProductLevel' )
> UNION ALL SELECT 'Engine Edition' , SERVERPROPERTY( 'Edition' )|||Hello Aaron,
Thanks for that suggestion - I'll try it and let you know...
Regards,
Abbey
"Aaron Bertrand [SQL Server MVP]" wrote:

> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
> Server\MSSQLServer\MSSQLServer\CurrentVe
rsion\
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server\<instance
> name>\MSSQLServer\CurrentVersion\
> Key name = CSDVersion (not CurrentVersion).
>
> "Abbey" <Abbey@.discussions.microsoft.com> wrote in message
> news:1D2E126E-B6FE-411C-B157-FD3BBB49CE82@.microsoft.com...
>
>|||Is there any harm in opening a connection to check the database version?
If it's the wrong version you can always run "wrong version" code and
disconnect the connection.
"Rebecca York" <rebecca.york {at} 2ndbyte.com> wrote in message
news:4362481f$0$134$7b0f0fd3@.mistral.news.newnet.co.uk...
> SELECT TOP 0 NULL AS Property , NULL AS Variable
> UNION ALL SELECT 'Version' , SERVERPROPERTY( 'ProductVersion' )
> UNION ALL SELECT 'Level' , SERVERPROPERTY( 'ProductLevel' )
> UNION ALL SELECT 'Engine Edition' , SERVERPROPERTY( 'Edition' )
>
> "Abbey" <Abbey@.discussions.microsoft.com> wrote in message
> news:1D2E126E-B6FE-411C-B157-FD3BBB49CE82@.microsoft.com...
> What
>sql

How to detect and add exceptions to Firewall programmatically?

I've been successful at installing a customized SQLexpress using setup.exe /settings template.ini.

What I'd like to do now is see if I can progammatically detect a Firewall on the SQLexpress machine and if there is one to add the exceptions for sqlservr and sqlbrowser programmatically so that the user doesn't have to do anything.

Is this possible and how would I do it?

Thanks,

jerry

You'll have to use the Windows Firewall API to do this. There is a topic on adding Program Exceptions here.

Mike

|||

Thanks Mike... that puts me on the right track.

/jerry

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 SQL server Database to another PC while creating SetUP package in .Net VB

How to Deploy SQL server Database to another PC, How to create a
package that craetes Database as well as ODBC driver for accessing data
at enduser PC, using .Net VBhi,
<hitendra15@.gmail.com> ha scritto nel messaggio
news:1102241845.011857.112670@.c13g2000cwb.googlegr oups.com
> How to Deploy SQL server Database to another PC, How to create a
> package that craetes Database as well as ODBC driver for accessing
> data at enduser PC, using .Net VB

John already answered you about drivers...
as regard database installation, personally I do not like backup/restore
practice, nor detach/attach...
and Ialways go for executing the DDL scripts to recreate the dbs and related
objects as long as performing BCP in and/or INSERT INTO scripts in order to
populate pre-loaded tables...
the best "universal" approach I've seen so far explained in a public article
is
http://msdn.microsoft.com/sql/archi...er/default.aspx
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--- remove DMO to reply|||To add on to Andrea's response, we keep all of our DDL scripts under source
control and run these scripts during installation with a .Net custom action.

Depending on your requirements, you can include the scripts in a .Net
project as either content files or as embedded resources. You can then
include that project in your Setup and Deployment project. Your custom
action can read and execute the scripts from either the resource assembly or
from the file system.

--
Hope this helps.

Dan Guzman
SQL Server MVP

<hitendra15@.gmail.com> wrote in message
news:1102241845.011857.112670@.c13g2000cwb.googlegr oups.com...
> How to Deploy SQL server Database to another PC, How to create a
> package that craetes Database as well as ODBC driver for accessing data
> at enduser PC, using .Net VB

How to deploy Reports.

Hi,

I have a web project and created a setup project for it. And I have to create reports using sql server reporting services. For this I have created an reportserver project and created two reports.

I have to create a setup file to install these reports in a remote machine.

How to do this?

where this .rdl and .rds files will be stored in the reportserver.

Regards,

Murali

You're in the wrong forum. Moving to SQL Server Reporting Services.|||

Russell Christopher has a blog post in which he gives a sample and outlines the process of using his sample to deploy RDLs via an MSI: http://blogs.msdn.com/bimusings/archive/2006/03/01/541599.aspx

I believe, however, that you may be better served embedding the ReportViewer control and building the reports into your web project. Here are a couple of resources for the ReportViewer control:

Report Authoring Tips and Tricks

http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050609SQLServerBW/manifest.xml

Getting started with SQL Server 2005 Reporting Services or the new report controls in Visual Studio 2005? Brian Welcker demonstrates some tips and tricks that you can use to add interactive features to your own reports. MSDN Webcast: Intelligent Reporting: Using the Visual Studio 2005 Report Viewer Controls (Level 200)

http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032284444&EventCategory=5&culture=en-US&CountryCode=US

This explains integrating the ReportViewer control into your 2005 Web or Windows applications.

Larry|||

I left out a great resource:

http://www.gotreportviewer.com/

Larry

|||

Thanks for your help.

It helps me to find the solution.

Murali.

how to deploy reports on report server other then using rerport mg

hey, Is there any way to making a setup of report project, to deploy reports
on server.
I have used both vs.net and report manager, but in both ways i have to has
access to report server.
I want to deply reports on the server on which i am not having access.
How to make a setup.
thanksSee if Reporting Services Scripter helps.
http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"vibha" <vibha@.discussions.microsoft.com> wrote in message
news:89560410-2E89-469D-85DF-695657E57E8F@.microsoft.com...
> hey, Is there any way to making a setup of report project, to deploy
> reports
> on server.
> I have used both vs.net and report manager, but in both ways i have to has
> access to report server.
> I want to deply reports on the server on which i am not having access.
> How to make a setup.
> thanks|||Even with the scripter you will have to have some sort of Access. VS.net is
using web services to deploy. As long as your account has the rights in RS
to deploy you will be able to do this. Your account does not have to be
admin on the server (if it is then it automatically has deploy rights).
I suggest you look at how RS implement roles.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"vibha" <vibha@.discussions.microsoft.com> wrote in message
news:89560410-2E89-469D-85DF-695657E57E8F@.microsoft.com...
> hey, Is there any way to making a setup of report project, to deploy
> reports
> on server.
> I have used both vs.net and report manager, but in both ways i have to has
> access to report server.
> I want to deply reports on the server on which i am not having access.
> How to make a setup.
> thanks

How to deploy an assembly (CLR)?

Good day to ALL,

I have already setup a db to my client.

My sp's are all created using CLR.

If my sp's are changed, how do I deploy them back to my client?

I usually send them a backup of the DB during the first few implementation.

But currently, their DB now contains live data, so I can't just let them restore the backup.

Is there another way?

Thanks and more power!

Arthur

If you just changed the code without adding any param on any other object you just need to issue an ALTER ASSEMBLY

If you added some object then you need to
- ALTER ASSEMBLY
- CREATE PROCEDURE or FUNCTION

If your changes are very hard, say you have modified SP params you need to drop all your objects, drop the assembly and recreate all from scartch.