Server Configuration

Install SQL2008 Std edtn x64
Hello, Iam trying to install SQL2008 Std Edtn 64-bit edition on Windows 2008 64-bit. When I put in the SQL install CD, I see a 'setup.exe'. Is this the same for 64 bit as well means will the setup automatically detect OS 64bit and install SQL likewise? I went into the 'x64' folder and tried to execute 'setup... 17 Nov 2009 21:59

SQL 2008 Installation Error - There was an error generating the XML document. Error code 0x84B10001.
Hi, I am encountering an installation issue during I am installing SQL Server 2008 Standard/Enterprise Edition on a Windows Server 2008 R2 Enterprise. I have no problem to get through all the setup dialog boxes until I hit the section to setup user accounts for accessing different SQL services. The error, "T... 17 Nov 2009 03:58

upgraded from MSSQL 2000 to MSSQL 2005 now database's users have
Hello. I updated the MSSQL 2000 server to MSSQL 2005 server now the database's users have no login names. I found a way to list orphaned users sp_change_users_login 'Report' but it only listed dbo and there are actually five listed with MSSQL Server Management Studio Express. I tried this sp_change_users_login ... 16 Nov 2009 23:35

KB955706 Error Code 0x2B2F
I had the same problem and this worked for me...go to the following link: http://kbalertz.com/Feedback.aspx?kbNumber=968749 Carole-Anne;-))) ebchanc wrote: KB955706 Error Code 0x2B2F 01-Apr-09 Ive got a new computer and am trying to stay up to date with all the windows updates. I have downloaded th... 14 Nov 2009 18:53

Clearing procedure/query cache mid-stream?
We are running a big (6 million entities) conversion for a customer. Rather than BCP or anything "streamlined" we need to use our standard INSERT procedure to ensure complex business rules are enforced. The procedure is quite complex. Many checks are done prior to the actual record INSERT. Some of these chec... 14 Nov 2009 04:39

Convert RTF to plain text in sql
Can you post the rest of that script Andy. What you posted appears to be incomplete. Thanks From http://www.developmentnow.com/g/118_2007_8_0_0_1011896/Convert-RTF-to-plain-text-in-sql.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/ ... 13 Nov 2009 11:04

Thanks
Running the SQL 2005 Management Studio 2005 Express as ADMINSTRATOR solved my problem under windows vista and even under Windows Seven. Thanks a lot for the quick solution. Jeffrey Williams wrote: Re: Unable to stop service SQLSERVERAGENT 18-Oct-08 John Bell wrote: This is NOT a bug. Since you are ... 13 Nov 2009 06:37

Upgrade Old DB Structure to New DB while keeping all data intact
I have a DB at location that uses a database that was created about a year ago. In a test environment we have made numerous upgrades to that exact db with new procedures and a couple new columns in certain tables. What is the most efficiant way to upgrade the Old DB while keeping all data intact. I was thinkin... 12 Nov 2009 23:00

Windows/SQL Authentication...
Friends, I always read that "Windows Authentication" security is much more secure than "SQL Server Authentication" security. (Although I don't quite understand why, exactly.) I also seem to remember reading that SQL Server Authentication might be "deprecated" at one point and eventually go away. (Although ... 13 Nov 2009 07:43

Low performance on SQL Server 2008 Std 64 bit
Hello! I have installed a Windows Server 2008 64bit with SQL Server 2008 Standard edition + Microsoft Business Solution Navision 5.0 SP.1 My boss ha launched a procedure directly on server which usually takes about 18 hours on our production server (Windows 2003 / SQL Server 2000). Today he tells me that th... 11 Nov 2009 22:31