SQL server

What is SQL server 2005 Compact Edition and do I need it?


Yaso_Kuuhl wrote:

Hi Wikipedian, the link below leads to an article on SQL from the website from which your nickname originates ;-D

http://en.wikipedia.org/wiki/SQL_Server_2005_Compact_Edition

 

And here's the Microsoft link:

http://www.microsoft.com/sqlserver/2005/en/us/overview.aspx

 

I believe developers and companies use SQL. Got the following from the article to which the Microsoft link leads:

 

Microsoft SQL Server 2005 is a comprehensive, integrated data management and analysis software that enables organizations to reliably manage mission-critical information and confidently run today’s increasingly complex business applications. SQL Server 2005 allows companies to gain greater insight from their business information and achieve faster results for a competitive advantage.

Message Edited by Yaso_Kuuhl on 10-14-2009 12:15 AM

 

So is it a security vunerability to have it installed?  Remove it?

What is SQL server 2005 Compact Edition and do I need it?

Are you asking because of the service pack (3) which was released for SQL via Windows Update today, on patch Tuesday? :-) If you install this service pack, then this closes the security issue...

You can read details over here:

http://www.microsoft.com/technet/security/bulletin/ms09-oct.mspx

 

Go to "Affected Software and Download Locations", and then to "Microsoft Server Software". 

Message Edited by Yaso_Kuuhl on 10-14-2009 12:24 AM

I always check for windows update on the second Tuesday of the month.  I always do this manually (as automatic always interupt what I’m doing and tends to install the update on the next day).  I keep a mental note, second Tuesday of the month, update computer (although it doesn’t rhyme! :smileywink:)

I read somewhere that if you want to memorise a (fresh) piece of information (like a shopping list), then inventing a melody or song for it helps ;-)))

So, you can sing (whether just in your mind or out loud is up to you...): "It is Microsoft patch Tuuuuuueeeesdaaayyyyyy...." :-D


Wikipedian wrote:
What is SQL server 2005 Compact Edition and do I need it?

 

SQL = Structured Query Language used for managing databases.

It is on your system because, at some stage, you have installed an application that needs SQL installed in order to be able to run.

e.g. Microsoft's Business Contact Manager