Showing posts with label install. Show all posts
Showing posts with label install. Show all posts

Sunday, March 11, 2012

dumb question

Just bought a new computer, and want to install vb express. There is an icon in my system tray for Microsoft SQL Server Service Manager ver. 8.00.2039. Does this mean that I won't have to install SQL Server Express? I can't find anything in the Add/Remove programs that shows any version of SQL Server that was pre-installed.

thanks

richard

Hi Richard,

You have SQL Server 2000, probably MSDE. You will want to have SQL Express for tight integration with VB Express. I would go install SQL Express from http://msdn.microsoft.com/vstudio/express/sql/download first, then install VB Express. VB Express will offer to install SQL if it isn't already there, but it is the RTM version, not SP1.

Mike

Friday, March 9, 2012

Dual installation SQL 2005 Std. and Express

Hi everybody,
I had SQL 2005 std. edition installed and I install SQL 2005 express
after that. I have no trace of the express installation. Neither in the
add/remove program nor under \Program files directory!
Is dual installation possible?
Are files copied to the same directories?
thank you very much
sergeHi,
I found that I had to install SQL Server Management Studio Express (SSMSE)
but it cannot be installed when SQL Server Management Studio standard
edition is already installed. How can'I remove SSMS? It does not appear in
the add/remove program. And the Microsoft warning messsage shown during the
installation of SSMSE is truncated!
thank you for your time
serge
Serge Myrand wrote:
> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
> thank you very much
> serge|||> Is dual installation possible?
>
Yes, you can install both. The add/remove programs entry is shared. You
can selectively change/remove instances using the single entry.
> Are files copied to the same directories?
The default location is "C:\Program Files\Microsoft SQL Server". You will
have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44142941.EA94C30F@.softdelirium.qc.ca...
> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
>
> thank you very much
> serge
>Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!|||No need for SSMSE in this case since you can use SSMS for the SQL Express
instance. For example, connect to instance 'MyServer\SQLExpress'.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44143B91.DA5D61B0@.softdelirium.qc.ca...
> Hi,
> I found that I had to install SQL Server Management Studio Express (SSMSE)
> but it cannot be installed when SQL Server Management Studio standard
> edition is already installed. How can'I remove SSMS? It does not appear in
> the add/remove program. And the Microsoft warning messsage shown during
> the
> installation of SSMSE is truncated!
> thank you for your time
> serge
>
> Serge Myrand wrote:
>> Hi everybody,
>> I had SQL 2005 std. edition installed and I install SQL 2005 express
>> after that. I have no trace of the express installation. Neither in the
>> add/remove program nor under \Program files directory!
>> Is dual installation possible?
>> Are files copied to the same directories?
>> thank you very much
>> serge
>|||Thank you very much.
Dan Guzman wrote:
> > Is dual installation possible?
> >
> Yes, you can install both. The add/remove programs entry is shared. You
> can selectively change/remove instances using the single entry.
> > Are files copied to the same directories?
> The default location is "C:\Program Files\Microsoft SQL Server". You will
> have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
> news:44142941.EA94C30F@.softdelirium.qc.ca...
> > Hi everybody,
> >
> > I had SQL 2005 std. edition installed and I install SQL 2005 express
> > after that. I have no trace of the express installation. Neither in the
> > add/remove program nor under \Program files directory!
> >
> > Is dual installation possible?
> >
> > Are files copied to the same directories?
> >
> >
> > thank you very much
> > serge
> >Neither in the
> > add/remove program nor under \Program files directory!Neither in the
> > add/remove program nor under \Program files directory!Neither in the
> > add/remove program nor under \Program files directory!Neither in the
> > add/remove program nor under \Program files directory!

Dual installation SQL 2005 Std. and Express

Hi everybody,
I had SQL 2005 std. edition installed and I install SQL 2005 express
after that. I have no trace of the express installation. Neither in the
add/remove program nor under \Program files directory!
Is dual installation possible?
Are files copied to the same directories?
thank you very much
serge
Hi,
I found that I had to install SQL Server Management Studio Express (SSMSE)
but it cannot be installed when SQL Server Management Studio standard
edition is already installed. How can'I remove SSMS? It does not appear in
the add/remove program. And the Microsoft warning messsage shown during the
installation of SSMSE is truncated!
thank you for your time
serge
Serge Myrand wrote:

> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
> thank you very much
> serge
|||> Is dual installation possible?
>
Yes, you can install both. The add/remove programs entry is shared. You
can selectively change/remove instances using the single entry.

> Are files copied to the same directories?
The default location is "C:\Program Files\Microsoft SQL Server". You will
have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44142941.EA94C30F@.softdelirium.qc.ca...
> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
>
> thank you very much
> serge
>Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!
|||No need for SSMSE in this case since you can use SSMS for the SQL Express
instance. For example, connect to instance 'MyServer\SQLExpress'.
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44143B91.DA5D61B0@.softdelirium.qc.ca...
> Hi,
> I found that I had to install SQL Server Management Studio Express (SSMSE)
> but it cannot be installed when SQL Server Management Studio standard
> edition is already installed. How can'I remove SSMS? It does not appear in
> the add/remove program. And the Microsoft warning messsage shown during
> the
> installation of SSMSE is truncated!
> thank you for your time
> serge
>
> Serge Myrand wrote:
>
|||Thank you very much.
Dan Guzman wrote:
[vbcol=seagreen]
> Yes, you can install both. The add/remove programs entry is shared. You
> can selectively change/remove instances using the single entry.
>
> The default location is "C:\Program Files\Microsoft SQL Server". You will
> have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
> news:44142941.EA94C30F@.softdelirium.qc.ca...

Dual installation SQL 2005 Std. and Express

Hi everybody,
I had SQL 2005 std. edition installed and I install SQL 2005 express
after that. I have no trace of the express installation. Neither in the
add/remove program nor under \Program files directory!
Is dual installation possible?
Are files copied to the same directories?
thank you very much
sergeHi,
I found that I had to install SQL Server Management Studio Express (SSMSE)
but it cannot be installed when SQL Server Management Studio standard
edition is already installed. How can'I remove SSMS? It does not appear in
the add/remove program. And the Microsoft warning messsage shown during the
installation of SSMSE is truncated!
thank you for your time
serge
Serge Myrand wrote:

> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
> thank you very much
> serge|||> Is dual installation possible?
>
Yes, you can install both. The add/remove programs entry is shared. You
can selectively change/remove instances using the single entry.

> Are files copied to the same directories?
The default location is "C:\Program Files\Microsoft SQL Server". You will
have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44142941.EA94C30F@.softdelirium.qc.ca...
> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
>
> thank you very much
> serge
>Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!|||No need for SSMSE in this case since you can use SSMS for the SQL Express
instance. For example, connect to instance 'MyServer\SQLExpress'.
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44143B91.DA5D61B0@.softdelirium.qc.ca...
> Hi,
> I found that I had to install SQL Server Management Studio Express (SSMSE)
> but it cannot be installed when SQL Server Management Studio standard
> edition is already installed. How can'I remove SSMS? It does not appear in
> the add/remove program. And the Microsoft warning messsage shown during
> the
> installation of SSMSE is truncated!
> thank you for your time
> serge
>
> Serge Myrand wrote:
>
>|||Thank you very much.
Dan Guzman wrote:
[vbcol=seagreen]
> Yes, you can install both. The add/remove programs entry is shared. You
> can selectively change/remove instances using the single entry.
>
> The default location is "C:\Program Files\Microsoft SQL Server". You will
> have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
> news:44142941.EA94C30F@.softdelirium.qc.ca...

Dual CPU Machine and SQL 7.0

We have a complex query that runs in 3-5 seconds on a single CPU machine. When we install the query on a Dual CPU machine, Optimizer selects a totally different execution plan that causes table scans and takes about 45 - 360 seconds to execute.
Any ideas on what to do?
ThanksWhen was the last time you updated statistics, re-built indexes and re-compiled your sps on the dual box?|||We have performed several analyses and traces on the system. We tore apart the Stored Procedure (and ended up re-assembling it the same way).

We dropped and rebuilt all indexes. Update Stats and recompile runs daily on all DBs.

We determined that on dual cpu machines, SQL Optimizer decides to use a bad Execution Path that includes Table Scans (thus the 30-40 minutes).

The data is the same across all the machines, as are the indexes, primary keys, security permissions etc.

We've eliminated flags/settings differences within SQL itself.

We eliminated the raid configuration as on single-cpu machines it runs on any raid config and won't run on dual-cpu any raid or non raid config.

When we pop out one of the CPUs, then the stored procedure runs in 3-5 seconds.|||I'm not quit sure that it's a because of a dual processor. Our development machine and UAT machine are single processors. Our Production and Reporting servers are dual processors and they created the same query plan as those on development and UAT. There is this one instance, about a month ago where a production stored procedure created a different query plan from development, UAT and the Reporting server. But there was one thing different and that was the Production server's indexes where created as CONTRAINTS, whereas on the other machines they where created with CREATE INDEX. The reason Production had to change was because transactional replication requires keys to be defined via PRIMARY KEY constraints. So to rectify the problem I coded tables in the FROM statement in the order of query optimization and adding the FORCE ORDER option.
This cleared up the problem. I never use HINTS or any of those FORCE options before, this is my first time. I'm not one to tamper with query plans, however in this one instance it helped.|||Thanks for the idea, but we have already tried the FORCE and hints options and Optimizer still overrides them. The data is the same across all the machines, as are the indexes, primary keys, security permissions etc.|||Dumb question here but is your hardware and os configured for one or two cpus?

I talked to one of our surver guys and he said you can't just reomve a cpu, reboot and expect NT to run properly.

In fact based on what you said I am wondering if NT was installed for one processor while the hardware is configured for 2 cpus!|||Thanks for the suggestion. We tried 2 different dual-cpu machines.

When configuring the machines both were wiped and WIN 2K SP2+ and SQL 7.0 SP3 were re-installed for a 2-cpu environment.

One machine (Dev) is AN HP LH4R w/Dual Pentium II Xeon 400 mhz CPUs. 2Ghz mem w/HP Netraid controller running a Raid 5 array.

The other machine (Production) is a IX Systems Tyan Motherboard Thunder model LES2510 with 2 Pentium III 1Ghz CPUs. Symbios SCSI Controller hooked to Infotran Raid Controller Model 3102 running Raid 5 array.

When the machines were taken back to 1 CPU, WIN 2K and SQL were again wiped and re-installed.|||Another "Is it Plugged in?" Question...

Are the settings correct for Paralellism in the 'Properties'
under your server in EM... Minimum query plan threshold setting...
defaults at 5 seconds (cost estimate)... for multi-CPU machines|||Hi all,

If the machine can be restarted - then boot to a single processor mode and run the tests...

just a shot...

take care
tony|||We have an sql application that runs perfecly on single processor machines. we recently installed on a dual processor capable server with only one Xeon 1.8 Ghz processor, windows2000 server. Suprisingly we find the sql performance has degraded dramatically( when compared to running it on 1 Ghz, single processpor)
I went through a number of message postings and detrmined that a number of other people have seen performace degradation or at least no increase in performance. Here are the links, the common thread is all of them have xeon processors

Wondering if this is a setup issue on the server or ....

http://216.239.33.100/search?q=cache:GokRMOJ5XtQC:dbforums.com/t363432.html+CONFIGURING+DUAL+PROCESSOR+SQL&hl=en&ie=UTF-8

http://webforums.sybase.com/nntp/nd000049.nsf/85255e6f0052055e85255d7f005ed8bc/dac80f4be40abe7352192d6d624343b1?OpenDocument

http://www.sqlmag.com/Forums/messageview.cfm?catid=5&threadid=4383

http://www.sqlmag.com/Forums/messageview.cfm?catid=5&threadid=5970

http://www.sqlmag.com/Forums/messageview.cfm?catid=5&threadid=4466

http://www.sqlmag.com/Forums/messageview.cfm?catid=22&threadid=3358

http://www.winnetmag.com/Forums/Application/Thread.cfm?CFID=19669352&CFTOKEN=65475496&CFApp=70&Thread_ID=88250|||We still haven't fixed the problem. We're currently trying different tests with setting the parallelism. I'll investigate the latest suggestions and incorporate them into our tests.

Thanks for all your help.

Dual CPU install

We have a new server with 2 CPU's but our SQL Server 2005 license is for a
single CPU. Do I have to buy a 2nd license or can I disable the setup to
only use 1 CPU? Any help on this is appreciated. Thank you.
DavidThe license states that if the edition is capable of using all the procs
then you need a license for it regardless of if you intend on using it or
not. However dual cores only count as 1 proc not two.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"David C" <dlchase@.lifetimeinc.com> wrote in message
news:%239UjrtYeIHA.288@.TK2MSFTNGP02.phx.gbl...
> We have a new server with 2 CPU's but our SQL Server 2005 license is for a
> single CPU. Do I have to buy a 2nd license or can I disable the setup to
> only use 1 CPU? Any help on this is appreciated. Thank you.
> David
>

Dual CPU install

We have a new server with 2 CPU's but our SQL Server 2005 license is for a
single CPU. Do I have to buy a 2nd license or can I disable the setup to
only use 1 CPU? Any help on this is appreciated. Thank you.
David
The license states that if the edition is capable of using all the procs
then you need a license for it regardless of if you intend on using it or
not. However dual cores only count as 1 proc not two.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"David C" <dlchase@.lifetimeinc.com> wrote in message
news:%239UjrtYeIHA.288@.TK2MSFTNGP02.phx.gbl...
> We have a new server with 2 CPU's but our SQL Server 2005 license is for a
> single CPU. Do I have to buy a 2nd license or can I disable the setup to
> only use 1 CPU? Any help on this is appreciated. Thank you.
> David
>

Sunday, February 26, 2012

DTSing Oracle data into SQL Server

I need to import some data from Oracle into Sql Server.
I've installed the Oracle's OleDB provider (OraOLEDB_92020.exe).
Do I need to install anything else on the SQL Server so that I can import the data?
Cheers
NickOriginally posted by riggers
I need to import some data from Oracle into Sql Server.

I've installed the Oracle's OleDB provider (OraOLEDB_92020.exe).

Do I need to install anything else on the SQL Server so that I can import the data?

Cheers

Nick
I don't think so|||linked server|||I've tried just installing the OleDb provider but it appears from furthering reading on the web that I need to install the oracle client tools aswell as the OleDb provider.

I've been told that we are running Oracle 10.7 and I can not appear to find the client tools for this on Oracle's website.

Does anyone know where the client tools for this version of Oracle are?

Cheers

Nick

Friday, February 24, 2012

DTS/ SQL Agent question

We're having to install new SQL servers on a new naming convention. We
know the changes we have to make on the applications that hit the SQL boxes.
However, we are not sure what DTS or SQL Agent jobs would need to be
changed.
Is there a way that we can search the DTS & SQL Agent jobs for a literal
that would refer to our old SQL server name and could identify & change
it to run on the new one?
Or,
is there a way to pass a parameter into the DTS or the Agent jobs that
would point them to the new server?
We're running Windows 2000, SQL 2000. We'll be moving to Windows 2003
and SQL 2000.
Any ideas appreciated.
Thanks,
BCFor the agent jobs, you can script them out and search through the SQL that
is created. For DTS, you could probably save it as a VB file and search
through that.
Hope this helps!
Chuck Heinzelman
MCSD, MCDBA
I support the Professional Association for SQL Server (www.sqlpass.org)
This posting is not an endoresment of any product.
Information is provided as-is, and carries no warranties - either express or
implied.
Please respond in newsgroups only.
"Blasting Cap" <goober@.christian.net> wrote in message
news:OtNNUaXaGHA.4780@.TK2MSFTNGP02.phx.gbl...
> We're having to install new SQL servers on a new naming convention. We
> know the changes we have to make on the applications that hit the SQL
> boxes.
> However, we are not sure what DTS or SQL Agent jobs would need to be
> changed.
> Is there a way that we can search the DTS & SQL Agent jobs for a literal
> that would refer to our old SQL server name and could identify & change it
> to run on the new one?
> Or,
> is there a way to pass a parameter into the DTS or the Agent jobs that
> would point them to the new server?
> We're running Windows 2000, SQL 2000. We'll be moving to Windows 2003 and
> SQL 2000.
> Any ideas appreciated.
> Thanks,
> BC

DTS/ SQL Agent question

We're having to install new SQL servers on a new naming convention. We
know the changes we have to make on the applications that hit the SQL boxes.
However, we are not sure what DTS or SQL Agent jobs would need to be
changed.
Is there a way that we can search the DTS & SQL Agent jobs for a literal
that would refer to our old SQL server name and could identify & change
it to run on the new one?
Or,
is there a way to pass a parameter into the DTS or the Agent jobs that
would point them to the new server?
We're running Windows 2000, SQL 2000. We'll be moving to Windows 2003
and SQL 2000.
Any ideas appreciated.
Thanks,
BCFor the agent jobs, you can script them out and search through the SQL that
is created. For DTS, you could probably save it as a VB file and search
through that.
Hope this helps!
Chuck Heinzelman
MCSD, MCDBA
I support the Professional Association for SQL Server (www.sqlpass.org)
This posting is not an endoresment of any product.
Information is provided as-is, and carries no warranties - either express or
implied.
Please respond in newsgroups only.
"Blasting Cap" <goober@.christian.net> wrote in message
news:OtNNUaXaGHA.4780@.TK2MSFTNGP02.phx.gbl...
> We're having to install new SQL servers on a new naming convention. We
> know the changes we have to make on the applications that hit the SQL
> boxes.
> However, we are not sure what DTS or SQL Agent jobs would need to be
> changed.
> Is there a way that we can search the DTS & SQL Agent jobs for a literal
> that would refer to our old SQL server name and could identify & change it
> to run on the new one?
> Or,
> is there a way to pass a parameter into the DTS or the Agent jobs that
> would point them to the new server?
> We're running Windows 2000, SQL 2000. We'll be moving to Windows 2003 and
> SQL 2000.
> Any ideas appreciated.
> Thanks,
> BC

DTS/ SQL Agent question

We're having to install new SQL servers on a new naming convention. We
know the changes we have to make on the applications that hit the SQL boxes.
However, we are not sure what DTS or SQL Agent jobs would need to be
changed.
Is there a way that we can search the DTS & SQL Agent jobs for a literal
that would refer to our old SQL server name and could identify & change
it to run on the new one?
Or,
is there a way to pass a parameter into the DTS or the Agent jobs that
would point them to the new server?
We're running Windows 2000, SQL 2000. We'll be moving to Windows 2003
and SQL 2000.
Any ideas appreciated.
Thanks,
BCFor the agent jobs, you can script them out and search through the SQL that
is created. For DTS, you could probably save it as a VB file and search
through that.
Hope this helps!
--
Chuck Heinzelman
MCSD, MCDBA
I support the Professional Association for SQL Server (www.sqlpass.org)
This posting is not an endoresment of any product.
Information is provided as-is, and carries no warranties - either express or
implied.
Please respond in newsgroups only.
"Blasting Cap" <goober@.christian.net> wrote in message
news:OtNNUaXaGHA.4780@.TK2MSFTNGP02.phx.gbl...
> We're having to install new SQL servers on a new naming convention. We
> know the changes we have to make on the applications that hit the SQL
> boxes.
> However, we are not sure what DTS or SQL Agent jobs would need to be
> changed.
> Is there a way that we can search the DTS & SQL Agent jobs for a literal
> that would refer to our old SQL server name and could identify & change it
> to run on the new one?
> Or,
> is there a way to pass a parameter into the DTS or the Agent jobs that
> would point them to the new server?
> We're running Windows 2000, SQL 2000. We'll be moving to Windows 2003 and
> SQL 2000.
> Any ideas appreciated.
> Thanks,
> BC

Sunday, February 19, 2012

DTS, driver ODBC for Btrieve

Hi,
I need transformation data from files Btrieve (.dt) to any other formats. Where i can download driver ODBC or OLE DB for Btrieve?
And how install this driver?
Thank.See the vendors list (http://www.sqlsummit.com/oledbVen.htm) and get it.|||Originally posted by Satya
See the vendors list (http://www.sqlsummit.com/oledbVen.htm) and get it.
You have already used this Vendors list?
Exist of the shareware or freeware drivers?|||I've used Data Direct Technologies and for the shareware ensure to test them before deploying on production server.

Freeware/shareware are easy to get but make sure there is no security threat to the server.|||Originally posted by Satya
I've used Data Direct Technologies and for the shareware ensure to test them before deploying on production server.

Freeware/shareware are easy to get but make sure there is no security threat to the server.
What to do Data Direct Technologies? This is alternative DTS?
Give me links for downloads Data Direct Technologies, pls.|||I think you're not interested in the referred link, where this http://www.datadirect-technologies.com/ link is listed there.

Originally posted by Cancer
What to do Data Direct Technologies? This is alternative DTS?
Give me links for downloads Data Direct Technologies, pls.|||I looked only those links, which support Btrieve.
I have not found still shareware/freeware driver.

Thank for discussion|||Then may contact vendors listed, for further information.