Service Packs and Patches Interview Questions 

The OS in my computer is win XP service pack 2 & 256MB ram + 2.6 ghz speed + 40GB HD.The problem in detail is the query analyser part of SQL server 2000 opens only for Administrator account not for all the rest accounts. so is there any remedy to this profile conflict that can help me to manage my PC's in the lab ?

Hi there, I am having problems installing SQL Server 2005 Developer Edition. I am using Windows XP Media Center Edition with Service pack 2. The only setup file that SQL Server let's me run is the x86. It doesn't let me install Itanium and it doesn't let me install x64.

So, I am trying to install x86 and the install program runs, then I click Install, it installs the SQL Server native client just fine, but when it starts installing Microsoft SQL Server 2005 Setup Support Files, progresses for a while and then it stops and an error appears telling me: Error 1603 Installing Microsoft Sql Server 2005 Setup Support Files. See Log File for details..

I checked the log file and this is what the log file says:

Error String : The installer has encountered an unexpected error. The error code is 2908. Could not register component {1F3316BE-825B-4390-A9D2-AF3EECCAE9F6}.
Error Number : 2908

I don't know how to solve this problem. Does anyone know what to do? I really want to install SQL

Alright; here is my problem. I recently bought ACT 2006 and tried to install. I had no such luck. I keep getting an error message that says need to unistall an ACT7 instance of Microsoft SQL server 2000. Now, I looked at downloading a service pack for the server, but I don't know what server I have. I would guess the 2000 edition. I am running Windows XP office edition and it is on a fairly new laptop. Can anybody help me. If I knew what server I have I could get the updates for it and from what I have read on other forums, that should fix the problem.

i wnat to install SQL server on my Windows XP service pack 2 OS.but it show it will not suppoet on it..what to do..is it not possible to install it on Windows XP.Please tell me what to do.is windows XP doesent work as server too?

I was just wondering, how you can do it, can you do it with the Evaluation Edition or do you need the full version? Do you NEED Service pack 4, can you link me to a guide or tell me how to do it please =D

Trying to install a program that requires the SQL server with a service pack 3. I am sure I need to update this with Microsoft, but how do I know what I have already?

1 start button >all program>microsoftsqlserver server network utility
2 you will find in lift side of windows disable and in right side enable
3 just move TCP/IP to right side by click on TCP/IP and enable
4 in client use steep 1 but open Clint network utility

I'm setting up a SQL server with VS on it (for SSIS) and want to install latest service packs.
I assume I need to install both SQL SP2 and VS SP1 but the boss seems to think there should be only one service pack for this configuration - hmmm, I'm thinking NO just let me get on with it!
Any recommendation on which SP to install first?

Hi,
I used SQL 2000 SP3.when I restore database my databse table is blank and showing loding.....What is the problem.......?

Thanks
sanjay

Execute the following

select @@version

and look at number, for example

Microsoft SQL Server 2000 - 8.00.2039 ...

i have been trying to install "SQL Server 2005 Service Pack 2 doesn't install" for like a month ..... it never works! i get that automatic update shield icon thing in my bottom right toolbar and i click it....it says installing "security update for SQL Server 2005 Service Pack 2 doesn't install" but after about 30 mins it finishes and says:
the following updates could not be installed "security update for SQL Server 2005 Service Pack 2 doesn't install"

i don't do anything whilst its downloading i normally go do something else but it's now bugging me so plz help!

I have a windows xp media center edition 2002 with a service pack 2 on a HP pavilion, I was wondering how can you tell if the sql server is patched or not? Any help would be appreciated.