Topic profile page for SQL Server 2005.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: SQL Server 2005.
Topic "Sql server 2005" was discussed 16,868 times on 702 sites in last 3 months
Started 17 hours, 11 minutes ago (2009-11-27 00:17:00)
by Ken G
It appears that numerous people have had the same problem that I had where this update failed at every attempt to install it. I tried many of the suggestions in the various newsgroups without success, then today I looked at the SQL services under Control Panel/Administrative Tools/Services and saw that SQLExpress and SQL Active Directory...
Started 1 day, 10 hours ago (2009-11-26 07:06:00)
by Johnson
Hi, Is there any whitepaper or facts about SQL SErver Compact Edition 3.1 has better performance than SQL SErver 2005 Mobile? Currently I am using SQL Server 2005 Mobile and my database performance is very very bad. I am looking for upgrading of db if performance is better. Please advise before I make the upgrade....
Started 1 day, 16 hours ago (2009-11-26 01:08:00)
by Mark
My ultimate questions will be: Can SQL SErver 2000 and 2005 run on the same ssbs2003 server? and, regardless, Should I/ can I uninstall SQL Server 2005 and go back to SQL Server 2000. Moving from SBS2000 Premium to SBS2003 Premium on a new server. We were using SQL Server 2000 on the old server for a few things: Backup Exec, Prolog (construction mgmnt software), Great Plains...
Started 1 day, 21 hours ago (2009-11-25 20:16:00)
by Conan Kelly
Hello all, I'm trying to set up an SSIS Package where the 1st data flow task will read from a text file, perform all necessary transformations, and then have the results available to the 2nd & 3rd Data Flow Task's as source data. I guess I could set the package up to create a pseudo-temp table ([ClientDB].[sDELETE].[CoreData]) and send all my results from the 1st task to this table...then ...
Started 1 day, 22 hours ago (2009-11-25 19:17:00)
by Mark
My ultimate questions will be: Can SQL SErver 2000 and 2005 run on the same ssbs2003 server? and, regardless, Should I/ can I uninstall SQL Server 2005 and go back to SQL Server 2000. Moving from SBS2000 Premium to SBS2003 Premium on a new server. We were using SQL Server 2000 on the old server for a few things: Backup Exec, Prolog (construction mgmnt software), Great Plains (...
Started 2 days ago (2009-11-25 16:38:00)
by Rickshawrentals
I'm wondering if anyone can help an increasinly depressed programmer/DBA find out exactly what might have been altered by the last round of server updates -- specifically the SQL Server 2005 ( KB970892 ) from october 2009. My netadmin gave me the link to the microsoft site, but I'm not used to looking at these and I can't figure out exactly WHAT was changed. We had another issue where the ...
Started 2 days, 1 hour ago (2009-11-25 16:16:00)
by mark
My ultimate questions will be: Can SQL SErver 2000 and 2005 run on the same ssbs2003 server? and, regardless, Should I/ can I uninstall SQL Server 2005 and go back to SQL Server 2000. Moving from SBS2000 Premium to SBS2003 Premium on a new server. We were using SQL Server 2000 on the old server for a few things: Backup Exec, ...
Started 4 days, 4 hours ago (2009-11-23 13:14:00)
by Asifchouhan
Hi all, I have downloaded fresh copy of SQL Server 2005 Express Edition from Microsoft Website and started installing. In last step when installation wizard automatically starts the SQL Service at that moment my computer restarts. And after restarts, atleast after 1 minute my system restarts again without any notification. This continues for several times. Is this due to some ...
Started 3 days, 18 hours ago (2009-11-23 23:22:00)
by Kraftsmanship
Hi, I am converting an Access 2003 database that was divided into a front end and back end. The back end has replicated tables that were used by the Access front end to synchronize to a similar Access application used by field persons on tablet PCs. I successfully un-replicated the backend and moved it to SQL Server 2005, so the Access front end on the desktop works smoothly with the SQL...
Started 1 week ago (2009-11-20 15:18:00)
by Colombian Gringo
Security Update for SQL Server 2005 Service Pack 3 (KB970892) Windows has been attempting to install this update since it was downloaded by Microsoft Update on 10/17/2009. Each attempt to install the update has resulted in a failure with the following message: Installation status: Failed Error details: Code 737D Update type: Important Any ideas?
Started 3 days, 4 hours ago (2009-11-24 13:22:00)
by hrmartin
I have purchased 'Beginning SQL Server 2005 Programming' and I like it so much I want to purchase Mr. Vieira's book 'Professional Microsoft SQL Server 2008 Programming'. Should I also purchase 'Beginning SQL Server 2008 Progrqmming' ? Are there enough additions to the 2008 version to justify buying both books? Your input is greatly appreciated.
Started 3 days, 14 hours ago (2009-11-24 02:48:00)
by sadianaz
I have a project with postgre sql database. Now whole project need to be hosted at new server. New hosting do not support the Postgre database. I have converted the database into SQL Server 2005 by using a tool. But the user defined functions are not converted. I never worked on Postgre, so I am unable to covert these functions. Can any one help me in converting them?
Started 4 days, 6 hours ago (2009-11-23 11:02:00)
by Robert Aldwinckle
(cross-post added to SQL Setup) "CBear" wrote in message news:8106DA8D-1AE6-4AB6-8402-7F3C3C4F32DE@microsof t.com... >I am unable to download or install this update; Security Update for SQL > Server 2005 Service Pack 2 (KB970895). > The error message is (733F, unknown error). http://social.msdn.microsoft.com/forums/...
Started 3 days, 22 hours ago (2009-11-23 19:24:00)
by elsenorjose
How can I split the values in a field that is comma-delimited into their own rows? I have a table that has an ID field stored as a delimited field like this: CODE 123,456,789,012 I need it to display as: CODE 123 456 789 012 There are other fields in the table I need as well but I am stuck on the syntax to split out this particular field. Is there a simple select statement I can ...
Started 3 days, 5 hours ago (2009-11-24 12:22:00)
by sparkbyte
This is a cross post from VBSCRIPT. I need a VBscript that will query SQL2005 for the user tables in a database and then open an MDB (Access2003) file and import all matching tables. I have an Access database that needs to be migrated to MS SQL server but it has grown so much that it is now spread across multiple MDBs. I have the portion of the script written that will enumerate all files ...
Started 1 week ago (2009-11-19 20:25:00)
by Joe K.
I am trying to set up SQL Server 2005 mirroring for testing on the same Windows 2003 server. I have created two separate SQL Server 2005 database instances. After setting up the mirroring between the two instances. When I tried to Start Mirroring after the configuration I received the error listed below. One or more of the sever network addresses lacks a fully qualified domain name (FQDN ...
Started 3 days, 19 hours ago (2009-11-23 21:50:00)
by Wale
Hello guys, A week ago I posted this question: - Sql Server in Stand by mode? Really? Help!?! . It was about the difficulty I was encountering with restoring Sql Server 2005 Transaction Logs to my 2008 Sql Server database. We are trying to keep our Sql Server 2008 database in sync with our client's 2005 database. Replication isn't really an option with these guys so I thought I would ...
Started 2 days, 22 hours ago (2009-11-24 18:51:00)
by Surya Halim
I am running a batch INSERT statements off a file on Sql Server 2005 and the queries ran for a while then stopped with Query completed with errors next to an exclamation mark in the Results tab. The Results tab had nothing in it so at this point, I am clueless as to how to even begin to figure out which statement causes the whole batch to fail. Tried running Sql Server Profiler with trace running...
