Database

Installing sql server 2005 and an old one is installed

10-May-10 2:21

I think that maybe I do not understand your question.

The where clause determine which records are included and the having clause determines that you don't want to see any dates which' records do not add up to (at least) 1000. That is simple and clear logic.

So if you suspect that this query is not giving you the desired result, you can use Excel as a tool to check the outcome, and visually see each single record.

My advice is free, and you may get what you paid for.

Abdul-Rhman Alsri9-May-10 0:20

Abdul-Rhman Alsri

9-May-10 0:20

1 - Visual studio 2008 is already installed with sql server 2005 express edition installed implicity with it.

2 - Sql server 2005 management studion Express Edition is already installed.

3 - Today, I downloaded the one with Advanced Services and installed it but it did not compledte installation, please see following snapshots and guide me:

A) http://tareemnet.com/pic/full-text-search1.jpg
B) http://tareemnet.com/pic/full-text-search2.jpg

C) http://tareemnet.com/pic/full-text-search3.jpg

D) http://tareemnet.com/pic/full-text-search4.jpg

Re: Installing sql server 2005 and an old one is installed

Johan Hakkesteegt10-May-10 1:39

Re: Installing sql server 2005 and an old one is installed

10-May-10 1:39

This is a very common problem with MS SQL Server (all versions I think).

Because an Express edition was installed first, you are pretty much screwed. You are going to have to uninstall the express edition, manually delete all the folders it leaves behind, reboot, and install the new version with the advanced services, etc.

For what its worth, this has happened to me twice already. Looking for other solutions will only give you a headache.

My advice is free, and you may get what you paid for.

Corporal Agarn10-May-10 8:05

Corporal Agarn

10-May-10 8:05

I was able to not delete all the folders but did a regedit to clear that.

Re: Installing sql server 2005 and an old one is installed

Johan Hakkesteegt10-May-10 20:49

Re: Installing sql server 2005 and an old one is installed

10-May-10 20:49

But you did have to uninstall, right?

My advice is free, and you may get what you paid for.

Corporal Agarn11-May-10 0:33

Corporal Agarn

11-May-10 0:33

Yes uninstall was necessary and a big pain as MS does not clean-up well.

Re: Installing sql server 2005 and an old one is installed

Johan Hakkesteegt11-May-10 0:34

Trying to hide taskbar and desktop in Vista and Seven

11-May-10 0:34

That was my experience as well, but at least you managed to do it with one step less than me. Wink | ;)

My advice is free, and you may get what you paid for.

Sh@rpShooter7-May-10 9:13

Sh@rpShooter

7-May-10 9:13

Well, as the title of the post can state, I'm trying to hide the taskbar and the desktop in vista and Seven. I already did it in Win XP and older OSes, but the real problem are these... Frown | :(

In WinXP I used ShowWindow and FindWindow. If anyone could lend a hand, it would be great. Ah, almos forgot, I'm using VS2005

Thanks in advance,
Caio

Re: Trying to hide taskbar and desktop in Vista and Seven

Bassam Saoud7-May-10 9:29

Bassam Saoud

7-May-10 9:29

This is not a database question, I think you need to move it to the apropriate forum.

Re: Trying to hide taskbar and desktop in Vista and Seven

Chris Meech7-May-10 10:41

Chris Meech

7-May-10 10:41

Not a good Sh@rpShooter, you missed your target. Smile | :)

Chris Meech
I am Canadian. [heard in a local bar]

In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

Re: Trying to hide taskbar and desktop in Vista and Seven

Peace ON7-May-10 20:01

Peace ON

7-May-10 20:01

You can find the solution in following article.

Hiding the Taskbar and Startmenu (start orb) in Windows Vista[^]

And please post your message under proper thread. This is "General Database" thread.

Hope this will help!

Jinal Desai - LIVE
Experience is mother of sage....

MS-SQL Sever Version Question

gmhanna7-May-10 6:12

gmhanna

7-May-10 6:12

Hi,

I've recently upgraded to VS2010 which includes SQL Sever Express. I also have access to every version of SQL Sever, but I'm not sure which version I should be running so let me explain what I'm doing.

I would like to develop applications that use SQL Server as the database engine and distribute these as commercially available. The applications are simple applications such as a Recipe Manager which also may hook into an food inventory manager. So I don't need something with lots of bells and whistles. I'm also going to develop some SQL Web Applications, which may use a few databases as well. I have an IIS Web Server on another machine.

Here's what I'm thinking but I could be totally off base.

On my development machine, I would run either SQL Express or SQL Developer, not sure which is the right choice here. Is setting up SQL Developer more complex than SQL Express? Also, does SQL Developer let you distribute SQL Express with the installer of your application?

On my Webserver, I was thinking of running either SQL Web, or SQL Enterprise, I'm not sure of the right choice here. Also, is one version more difficult to setup and configure than another?

Thank you for your input...

Glenn

Re: MS-SQL Sever Version Question

Corporal Agarn7-May-10 8:44

Corporal Agarn

7-May-10 8:44

Setup is similar for any version. Since Express is free so I would suggest using that, with the the end user having the option to connect to other SQL servers.

Also if you program using a different version than you plan to distribute you will have problems. We currently use 2008 for development and 2000 for production (working on upgrading), this has caused some problems.

As to distribution I cannot help you.

Re: MS-SQL Sever Version Question

Andy_L_J9-May-10 20:29

Andy_L_J

9-May-10 20:29

You can distribute SQL Express with your Application - the distribution licence is free.

I suggest developing with the tool the user will be using (or that your app wil be using) - SQL Express.

SQL Developer is a Full Enteprise version with user license restrictions I believe - 1 Developer, you will still have to Deploy your databases to another Production Server with the appropriate licensing.( I use SQL 2008 Standard as I don't need the Mirroring and some other stuff available in the Enterprise version).

I don't speak Idiot - please talk slowly and clearly

'This space for rent'

Driven to the arms of Heineken by the wife

how do I find the IP of the 2005 sql server instance?

Tunisien867-May-10 3:32

Re: how do I find the IP of the 2005 sql server instance?

7-May-10 3:32

Hi guys,
I need to find the IP address of an INSATNCE of sql server 2005.

But I have also a SQL 2005 instance installed taht's named FOO\SQL2005. I
need to use the IP address in a connection string as follows (using it to connect to an sql sever remote database .mdf)

string sConnection = "Data Source= 192.168.1.1,1433;Initial Catalog=GMAO;User ID=sa;Password=sa;";

I have no idea how to find the IP address fo the 2005 instance. ipconfig wont' do that.

So how do I find the IP of the 2005 sql server instance?

Thanks,

JHizzle7-May-10 4:09

Re: how do I find the IP of the 2005 sql server instance?

7-May-10 4:09

Use ping FOO on a machine that resolves it?

Tunisien867-May-10 4:15

Re: how do I find the IP of the 2005 sql server instance?

7-May-10 4:15

Hi,
Sorry for the instance name I gave.How do I know the name of the instance I work with???
When I open sql server management studio,it writes ADMIN-PC (SQL Server 9.0.1399 - sa).Is that the instance??
Thanks

Peace ON7-May-10 4:22

Peace ON

7-May-10 4:22

You can know instance name of sql server by using following command.

SELECT @@SERVERNAME AS 'Server Name'

Hope this will help!

Jinal Desai - LIVE
Experience is mother of sage....

Re: how do I find the IP of the 2005 sql server instance?

Tunisien867-May-10 4:28

Re: how do I find the IP of the 2005 sql server instance?

7-May-10 4:28

Hi,
where I write this commande?In my csharp code?or in the cmd tool?
Thanks

JHizzle7-May-10 4:36

Re: how do I find the IP of the 2005 sql server instance?

7-May-10 4:36

In a new SQL Query window.

Tunisien867-May-10 4:51

Re: how do I find the IP of the 2005 sql server instance?

7-May-10 4:51

Hi JHizzle,
I create a new sql command like this:

string adr="SELECT @@SERVERNAME AS 'Server Name';";
            string sConnection = "Data Source= adr,1433;Initial Catalog=GMAO;User ID=sa;Password=sa;";

When running the application, this error appears:

Sql server adress not found:adr,1433

added to this notification:

Warning	1	The variable 'adr' is assigned but its value is never used

What is the problem??
Thanks

JHizzle7-May-10 5:03

Re: how do I find the IP of the 2005 sql server instance?

7-May-10 5:03

Ok, wait, back up here.

Do you or do you not have remote access to the server via SQL Server management studio or query analyzer? The previous answer should have been run using a query window within either of these.

What does you actual connection string contain: is it the SQL server name or its IP address? If it's the name and it works from your deelopment box, use that in a command prompt with the ping command to grab the IP address.

Tunisien867-May-10 5:10

Re: how do I find the IP of the 2005 sql server instance?

7-May-10 5:10

Hi,
I have remote access to the server(I go to :right click on the server name in sql server managment->connections here I find that remote connections to the server allowed).I don't understand what u mean by query analyzer??
My string connexion should contain the SQL server 'IP @ like this:

string adr="SELECT @@SERVERNAME AS 'Server Name';";
            string sConnection = "Data Source= adr,1433;Initial Catalog=GMAO;User ID=sa;Password=sa;";

Thanks

JHizzle7-May-10 5:20

Re: how do I find the IP of the 2005 sql server instance?

7-May-10 5:20

Ok, I think I know what you're meaning now. Have you tried just assigning Data Source as ADMIN-PC?

The brackets after are just a versioning thing within SQL. If you want the IP address, command prompt -> ping admin-pc

Tunisien867-May-10 5:38