SQL studio manager installation issue
Hi group, I am installing MS Studio manager 2005 but this will get recomment me to install MSXML 6 ,i installed this but then it recmoment to install Power shell ,i install this too but it recomment to install something new tooo. I installed windows new windows XP 2007SP2.  this error occur 1st time. I [...]

Answer Question   |  May 24, 2011  2:20 AM
PowerShell, SQL Server, SQL Server Express 2005, SQL Server Management

Can’t log in after upgrading SQL Server 2005 express to SQL 2005 standard
I have upgraded SQL Server Express 2005 to Standard 2005. Every thing is updated and all Services are well running, But not able to login because I have got only Configuration Tools in Menu- Start->Programs->MSS 2005->Configuration Tools. and if I try through Run SQLWB,it’s shows not avalable. Kindly help how can I will get all [...]

Answer Question   |  November 1, 2010  6:18 AM
SQL Server, SQL Server 2005 Standard Edition, SQL Server administration, SQL Server Express 2005, SQL Server Upgradation, SQL Server upgrades

SQL Server 2005
Is user cloning the only way to use windows authentication in sql server?

Answer Question   |  October 9, 2010  3:34 PM
SQL Server 2005, SQL Server 2005 connectivity, SQL Server Express 2005, Windows 7, Windows authentication

Trimming Values with SQL Server Express 2005
I have a column whose values range from 10-15 characters and whose last 7 characters I would like to get rid of. Can someone please show me how to do this? I thought it would be RTRIM but that didn’t work for me. I can’t use LEFT or RIGHT before the column because the column [...]

Answer Question   |  June 29, 2010  6:40 PM
RTRIM, SQL Server Express 2005, SQL Server Functions, TRIM function

Merge synchronization using only Sql Server Express 2005
I’m developing a database application using VB.net. I would like to use SQL Server Express for the database so that my customers won’t have to purchase additional software along with the cost of my software. One of my requirements is that the application can use merge synchronization. Will merge synchronization work using RMO or some [...]

Answer Question   |  May 4, 2010  8:49 PM
RMO, SQL Server Express, SQL Server Express 2005, SQL Server replication, SQL Server synchronization

Problems installing BCM for Outlook 2007
I have purchased 9 seats though volume liscensing for Outlook 2007 with BCM.  The first 7 installs with out a problem.  The last 2 have thrown this error: Setup failed to install the required component Microsoft SQL Server 2005 Express (MSSMLBIZ). Business Contact Manager for Outlook 2007 cannot continue. See C:Program FilesMicrosoft SQL Server90Setup BootstrapLogSummary.txt [...]

Answer Question   |  March 29, 2010  1:58 PM
BCM, Email, Outlook 2007, SQL Server Express 2005, WinXP

sql server express 2005 cannot see drive on my server (drive q)
I have installed sql server express on my local computer and now I would like to install it on the server (q). When I go to install it, it is not seeing the q drive. What could be causing this?

Answer Question   |  December 9, 2009  4:50 PM
SQL Server 2005, SQL Server Express, SQL Server Express 2005

Issues rebuilding system database on SQL Server Express 2005
I am having some trouble rebuilding the system databases on my SQL Server Express 2005 instance. While I have had a total system failure, the backups have been good. I have restored the operating system but obviously there are no SQL system databases present (they were open at the time of the backup). So now [...]

Answer Question   |  July 7, 2009  2:32 PM
SQL Server 2005, SQL Server database, SQL Server databases, SQL Server Express, SQL Server Express 2005

SQL SERVER EXPRESS 2005 FREEZE
I have a server machine running Windows Server 2003 and sqlserver express 2005 for a client-server application. All clients machines access the server thru a router fine with good response time but if the internet conecction fails suddenly the sqlserver freeze. Any sql command takes a long delay. What could be the reason ?. What [...]

Answer Question   |  April 26, 2009  1:38 PM
SQL Server 2005 Express, SQL Server errors, SQL Server Express, SQL Server Express 2005