InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 13:12:21 GMT20http://www.sqlservercentral.com/Forums/Topic1298393-324-1.aspxHi,how to read this XML in sql 2005 and store the data into temptable.Please help me.'<DocumentElement> <QuestionList> <QuestionId>Q1000</QuestionId> <Title>Apple /Title&gt <Sequence>3</Sequence> <MergeSequence>1</MergeSequence> </QuestionList><QuestionList> <QuestionId>Q1028</QuestionId> <Title>Banana/Title&gt <Sequence>3</Sequence> <MergeSequence>2</MergeSequence> </QuestionList> <QuestionList> <QuestionId>Q1029</QuestionId> <Title>orange/Title&gt <Sequence>3</Sequence> <MergeSequence>3</MergeSequence> </QuestionList> </DocumentElement>'[b]Output[u][/u][/b][u]QuestioID Title Seq  MerSeq [/u]Q1000 Apple 3 1 Q1028 Banan 3 2 Q1029 Orange 3 3 ThanksNarayananFri, 11 May 2012 01:55:55 GMTvemula.narayananhttp://www.sqlservercentral.com/Forums/Topic1227677-324-1.aspxHi experts,I am testing the connection between 2 SQL server express 2008 instances: one on win7 32bit the other win7 64bit. Windows authentication, same domain. The user is th edb owner on both instances. Error about SQLNCLI10OLEDB provider ... authentication failedCannot initialize the data source object......Invalid authorization specificationYour help would be much appreciatedThank youjustotiThu, 29 Dec 2011 01:47:05 GMTjustotihttp://www.sqlservercentral.com/Forums/Topic599479-324-1.aspxI ve just rebooted the server. After it reboots SQL Services not started and i got these errors on the eventviewer. Please help me:((Event Type: ErrorEvent Source: MSSQLSERVEREvent Category: (2)Event ID: 17058Date: 06.11.2008Time: 09:27:35User: N/AComputer: VVSTR01Description:initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(error not found).Data:0000: a2 42 00 00 10 00 00 00 ¢B......0008: 08 00 00 00 56 00 56 00 ....V.V.0010: 53 00 54 00 52 00 30 00 S.T.R.0.0018: 31 00 00 00 00 00 00 00 1.......Event Type: ErrorEvent Source: MSSQLSERVEREvent Category: (2)Event ID: 17053Date: 06.11.2008Time: 09:27:38User: N/AComputer: VVSTR01Description:UpdateUptimeRegKey: Operating system error 5(error not found) encountered.Data:0000: 9d 42 00 00 10 00 00 00 B......0008: 08 00 00 00 56 00 56 00 ....V.V.0010: 53 00 54 00 52 00 30 00 S.T.R.0.0018: 31 00 00 00 00 00 00 00 1.......Event Type: ErrorEvent Source: MSSQLSERVEREvent Category: (2)Event ID: 9003Date: 06.11.2008Time: 10:34:41User: N/AComputer: VVSTR01Description:The log scan number (347:192:1) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup. Data:0000: 2b 23 00 00 14 00 00 00 +#......0008: 08 00 00 00 56 00 56 00 ....V.V.0010: 53 00 54 00 52 00 30 00 S.T.R.0.0018: 31 00 00 00 00 00 00 00 1.......Sat, 08 Nov 2008 13:39:57 GMTfuatm16http://www.sqlservercentral.com/Forums/Topic1254816-324-1.aspxHi there,This is my first post so I'm not sure if I'm putting it in the right place. I'm working with a reporting server that I only have read access to, so I cannot create tables or procedures etc. What I'm trying to do is compare values returned from 2 datasets and then display it appropriately in a table. The 1st dataset grabs a list of dates that match if certain criteria are matched, and the second one does the same but with different criteria. I then want to be able to display a list of these dates in a table, excluding any that match between the 2 datasets. Can anyone advise me please?Regards,JackMon, 20 Feb 2012 09:51:46 GMTjackn 40579http://www.sqlservercentral.com/Forums/Topic1281374-324-1.aspxThere is only one database.I have got 1 table with the fields qid,qans.One more table with the fields qid,uans,result.I want to compare each record of qans and uans and if they match then answer should be 1 and it should store value 1 in result respective row.If it does'n match then it should store value 0 in the result field of respective row.How to write this code and where?Wed, 11 Apr 2012 02:22:43 GMTsolvedpaerhttp://www.sqlservercentral.com/Forums/Topic1269502-324-1.aspxI thought this was going to be fairly straightforward, but it seems I am wrong !!!I have written a small VS2010 C# Express program that accesses & updates a SQL Server 2008 R2 Express database on this PC. It's my home desktop machine & the idea is that I will be sending the Project to a friend in the UK for him to use on his stand-alone PC (a laptop I think, if that's at all relevant). So, to test how I would do this, I am trying to deploy it on my (again stand-alone) laptop here in Ireland.From within VS2010 C# Express I clicked Project / Publish & followed the Wizard until it created a Folder called Application Files, a "ClickOnce Application Deployment Manifest" file and a Setup file all within my Published Projects Folder.I assumed, presumably incorrectly, that this would create an executable version of my Program on the laptop, and install all the necessary .Net Framework & SQL Server software that it needed (assuming it wasn't already there) and the SQL Server Express database. I then copied these 3 files to a USB and ran the Setup on my laptop. It installed a number of things and then came up with an MS .net Framework Error message saying "Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately. Cannot open database XXX requested by the login. The Login failed. The Login failed for user AAA" Indeed, if I click Continue, the program starts to run and works until it tries to access the database, when I get the same message. Can somebody please explain clearly what I am doing wrong, or what I need to do to resolve this problem ?!?I am especially confused by the fact that I can't find the database, which is named KAELC_DB.mdf on this PC, or any reference to it on the laptop after installation. This would obviously be a major contributor to the fact that I am getting database errors, but surely the database is part of the project ?!?!?Tue, 20 Mar 2012 06:52:32 GMTgary.p.heathhttp://www.sqlservercentral.com/Forums/Topic1269470-324-1.aspxI have a user that I installed SQL Server 2005 SP4 Standard Edition on their new server. They have since created three SQL Server 2005 Express named instance. They can connect to the default instance that I created using SQL Server 2005 SSMS from their workstation, but they are unable to connect to any of the named Express instances. I can connect to all instances from the server. Please advise as to a solution. Thank you in advance.CharlieTue, 20 Mar 2012 06:06:50 GMTrummingshttp://www.sqlservercentral.com/Forums/Topic989494-324-1.aspxI maintain our company's sales force automation package, which supports over 100 salespeople nationwide. This application uses SQL RMO to sync the client data up to our server once the rep triggers a sync process at the end of their business day. The field units use 32 bit laptops running XP, and use SQL Express 2005 for their database platform.Recently, our development machines here at corporate were replaced with 64 bit machines running Windows 7. Since then, I have been unable to run this project in Visual Studio. The issues comes when the program hits the first reference to MergeSynchronationAgent, where I get the following:Message: "Class not registered"StackTrace: " at Microsoft.SqlServer.Replication.MergeSynchronizationAgent..ctor()\r at Microsoft.SqlServer.Replication.MergePullSubscription.get_SynchronizationAgent()\r at ReplicationAgent.MergeAgent.ProcessReplication() in D:\\Projects\\{ProjectName}\\ReplicationAgent\\ReplicationAgent.cs:line 77"I have tried to install the 32 bit version of SQL Express on my (now 64 bit) development machine, but the installer will not allow this. When I install the 64 bit version I get the above error during debug. My understanding was that the only difference between the 32 and 64 bit versions of SQL Express were the presence of additional files in the 64 bit version that would allow it to run on a 64 bit OS. That being the case, I'm not sure what I'm missing here. I've verified the assemblies exist in the SDK folder, and have installed the following as described in other posts:Microsoft Core XML Services (MSXML) 6.0 Microsoft SQL Server 2005 Management Objects Collection Microsoft SQL Server Native Client This sounds like it should be a fairly common issue, but I've had the toughest time finding a definitive solution. Any help would be appreciated. I cannot push changes to the field to accomodate a fix for my development machine, but surely there must be a way to develop and run this application on a 64 bit machine, while still targeting a 32 bit user environment.Thanks!Mon, 20 Sep 2010 09:27:28 GMTCharles-126316http://www.sqlservercentral.com/Forums/Topic1261389-324-1.aspxhi Please solve this error ?I want to read the mdb file and push the data to tables in Sql Server 2005 i am using the code like:exec sp_linkedserver 'linkedadvisor','Acess','Microsoft.jet.oledb.4.0',@mdbfilepathor select * from opendatasource('Microsoft.jet.oledb.4.0','datasource='path')...tbl_nameI am getting an error like "Msg 7303 Level 16, State 1 Cannot initialize the datasoure oblect ole db provider 'Microsoft.jet.oledb.4.0' for linked server "null"but its working in Sql Server 2008Tanks & RegardsNarayananSun, 04 Mar 2012 22:26:25 GMTvemula.narayananhttp://www.sqlservercentral.com/Forums/Topic1256219-324-1.aspxNoob to using SQLCMD and getting this when running script from Powershell. Any help would be greatly appreciated!!!!PS C:\> SQLCMD -S CONTOSOWXP01\SQLEXPRESS CREATE LOGIN [NewUser] WITH PASSWORD = 'password', DEFAULT_DATABASE=[Mydatabase], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFFSqlcmd: 'CREATE LOGIN [NewUser] WITH PASSWORD = password DEFAULT_DATABASE=[Mydatabase] CHECK_EXPIRATION=OFF CHECK_POLIC=OFF': Unexpected argument. Enter '-?' for help.PS C:\> -?Missing expression after unary operator '-'.At line:1 char:2+ - <<<< ?PS C:\>Wed, 22 Feb 2012 12:08:24 GMTsclavoiehttp://www.sqlservercentral.com/Forums/Topic1259723-324-1.aspxHi,I have a windows 7 home premium 64-bit laptop and i want to install SQL Server 2005 Express edition-(server and client). how can i install.please provide me the install guide and also the download links for the SQl server 2005 Express.Please do me needful.Regards,Sarath Babu VellampalliWed, 29 Feb 2012 10:36:09 GMTbslchennaihttp://www.sqlservercentral.com/Forums/Topic1255080-324-1.aspxHi ,Please find the logic for the below table in sql 2005.(without using the while loops)Input OutPutRow Person Row Person Count1 101 1 101 11 102 1 102 11 103 1 103 12 101 2 101 22 102 2 102 22 104 2 103 13 101 2 104 13 103 3 101 33 105 3 102 2 3 103 3 3 104 1 3 105 1Tue, 21 Feb 2012 02:58:52 GMTvemula.narayananhttp://www.sqlservercentral.com/Forums/Topic875215-324-1.aspxWe have an application with an embedded SQL Server Express which is showing the above error when trying to run reports created by the application. I cannot see anything on the SQL Express Management Studio.Can anyone help? A bit of a panic going on here!Tue, 02 Mar 2010 08:32:00 GMTS Hodkinsonhttp://www.sqlservercentral.com/Forums/Topic1156347-324-1.aspxDoes anyone know where I can find information or tell me how to export a SQL table from a DB on server 1 to another server? All my searches have showed me export to excel. Any help will be appreciatedExample:I need to export a table from Database A on SQLServer1 to Database B on SQLServer2Mon, 08 Aug 2011 13:09:29 GMTchad-573735http://www.sqlservercentral.com/Forums/Topic1229472-324-1.aspxI was able to log in this morning as <Domain>\Administrator to my 2005 SQL Express server with Management Studio. I made a backup of a database then renamed an existing database. I tried to continue working on another database and suddenly the <Domain>\Administrator role/account is no longer on the server. I cannot access the server now. Any idea wha may have caused this Admin account to go away? I can still remote into the server with the Admin account but cannot access the SQL server. I have tried restarting the service several times.Is there a way to restore this account? The person that configured and set up the SQL server is no longer with the company and so we do not have the sa password. I have other "User" level accounts that I can log in with, but they have limited access to specifc databases.Tue, 03 Jan 2012 11:33:21 GMTjustin.jones 10898http://www.sqlservercentral.com/Forums/Topic1227900-324-1.aspxI have a Client PC running Windows 7 64 Bit.I'm local admin on the machine but I'm denied the permission to change the password, add myself to the sysadmin role etc...The Image used for this PC has SQL Server Express Edition.The password is not known by anyone.Is it safe to use any of the Third Party Software to change SA SQL Server Password?Thu, 29 Dec 2011 09:48:51 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic1227240-324-1.aspxhello helloi have voice chat serves in my server run at win server 2003 and sql 2005but todayno site work in my serverif i enter any site have errorhttp://173.242.123.162/demo/i think problem in sql 2005how i can resolve itthis is errorLogin failed for user 'BMC'. [CLIENT: <named pipe>]For more information, see Help and Support Center atotherThis instance of SQL Server has been using a process ID of 1288 since 02/02/33 11:35:54 م (local) 03/02/33 07:35:54 ص (UTC). This is an informational message only; no user action is required.Wed, 28 Dec 2011 02:09:23 GMTtemoinlovehttp://www.sqlservercentral.com/Forums/Topic1223178-324-1.aspxI ran into this problem where the database became full and locked up.I ended up deleting some historical data that was not needed to clear up some space. To my surprise after I executed the limited truncation on the tables, the database actually grew in size.When I looked more closely I realized that the transaction log had grown supstantially, almost doubling the size of the DB as a whole.I went and executed a shrink on the transaction log file. Now the DB is below 2 GB (this is MSDE, but same applies to 2005 express with a limit of 4 GB).My question: what is the best way to clear up space in MSDE and SQL Express DB? Is shrinking the transaction a legitimate approach, or does it affect performance.We need to mitigate this, until we upgrade to full SQL server. Your feedback is greatly appreciated.Fri, 16 Dec 2011 09:10:57 GMTtechzone12http://www.sqlservercentral.com/Forums/Topic1211523-324-1.aspxI've a table created in a database in SQL Server 2005 .A field having datatype varchar(50) which contains date (ex. 20071015) in yyyymmdd format.I want month and year(Oct 2007).Please any body let me know how to do this ASAP.Thanks VSPThu, 24 Nov 2011 03:20:09 GMTvikramp 2790http://www.sqlservercentral.com/Forums/Topic958148-324-1.aspxHello,I have SQL Server 2005 Express edition on Windows Vista and for some reason I can't view the Maintenance Plan option.I have searched on-line and found several topics about this that suggested I added the user into the sysadmin role. I don't know how many times I have tried but I can't seem to find it. Initially I thought I missed something during installation so I uninstalled and installed it several times. I'm new at this and I'll try any advice you can give me.Thank you.Fri, 23 Jul 2010 11:53:09 GMTLiftHigherhttp://www.sqlservercentral.com/Forums/Topic1187500-324-1.aspxGreetings, I have a pos application that is connected to a SQL Server 2008 R2 Express database. The application gives our sales staff the ability to keep notes on their clients. Lately we are running into an application error when the notes field reaches a certain capacity (data length 8000). Is there a way to increase the amount of data the text field can contain?If it is not possible to increase the text field limit, I am also considering upgrading to MS SQL Server 2008 R2 for Small Business. If I make the upgrade will this solve the text field limitation and end my application error?Thank you for your help!!JasonSat, 08 Oct 2011 09:31:42 GMTjason 28928http://www.sqlservercentral.com/Forums/Topic1059090-324-1.aspxThe transaction log in MSDB is 106% full and Log_Reuse_wait_Desc is 'Check Point'. The server is restarted every night and still has the same error. I cann't do backup or shrink log file because the Log is full. Any idea to solve the problem?ThanksFri, 04 Feb 2011 17:00:40 GMTclare.xiahttp://www.sqlservercentral.com/Forums/Topic1184299-324-1.aspxI have developed the windows service & in windows service used the SQL server database .when i will start the computer my windows service get started but it will not connect to the SQL server .it display the following message"Cannot open user default database. Login failed.Login failed for user 'NT AUTHORITY\SYSTEM'."I want to start my service when my computer starting.how to establish the connection to SQL server database from windows service when starting the computer ?Mon, 03 Oct 2011 01:09:57 GMTvrush3189http://www.sqlservercentral.com/Forums/Topic876894-324-1.aspxI'm looking at a server that had SQL 2005 Express with Advanced Services installed. I didn't do the installation.How can I tell if Reporting Services was actually installed?Thanks.RogThu, 04 Mar 2010 09:04:22 GMTRoger Abramhttp://www.sqlservercentral.com/Forums/Topic1181140-324-1.aspxHello Friends, I want to update sp4 on SQLExpress 2005 edition. Do I need to reinstall the SQL server Express edition in order to update the patch on this one? Please help me on this one.When I go to the following link I get a couple of download options. I am not sure which one to choose.http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=184#system-requirementsFile Name Size SQLEXPR.EXE 54.0 MB Download SQLEXPR_ADV.EXE 254.0 MB Download SQLEXPR_TOOLKIT.EXE 224.0 MB Download SQLEXPR32.EXE 35.0 MB DownloadMon, 26 Sep 2011 10:15:34 GMTsqlquest2575http://www.sqlservercentral.com/Forums/Topic1181134-324-1.aspx!!!Mon, 26 Sep 2011 10:05:42 GMTjdsethihttp://www.sqlservercentral.com/Forums/Topic1172102-324-1.aspxI am trying to sort out if this is an sql or asp problemThe below procedure worked fine with sql 2000 and IIS6It is not working correctly(detail below) with sql express and IIS7 I have a stored procedure....ALTER PROCEDURE [dbo].[sp_newcart] ASbegininsert into cart (date_created)values (getdate()) select max(cart_id) from cartend(the cart_id auto increments 1)when calling from asp I cannot get the max(id)..I get " Item cannot be found in the collection corresponding to the requested name or ordinal"though it inserts okWhen I comment out the insert... it will return the current max(id) fineExecuting the procedure within sql server manager works okany direction?Thu, 08 Sep 2011 13:21:58 GMTjdeerehttp://www.sqlservercentral.com/Forums/Topic1041770-324-1.aspxDear Sir,I am in big trouble I am using SQL Server Express Edition Version 9.00.3042.00When I am restoring my database size approx 6GB then giving below the message as System.Data.SqlClient.SqlError: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database. (Microsoft.SqlServer.Express.Smo)If it's not possible in this edition then what edition I should be used for big database size.so, How to restore please help Thanking YouDebasis BagMon, 03 Jan 2011 05:18:28 GMTdeba_20032004http://www.sqlservercentral.com/Forums/Topic1140851-324-1.aspxI am trying to install 2005 SP4 + Q2494123 on a SQL 2005 Express RTM 9.00.1399.06. When I run this it says there's nothing to upgrade as it's already at the version 9.00.1399.06?This is the link I'm using:http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=184#system-requirementsThe SP should take it to 9.00.5292.What am i missing here?ThanksSteveWed, 13 Jul 2011 04:20:51 GMTSteve Hindle-535638http://www.sqlservercentral.com/Forums/Topic1154722-324-1.aspxI'm getting ready to start work on a re-writing one of our major applications. The old app is written in VB6 (actually, it started life in VB5), and the new app will be a WPF app. The database I've decided to use for this app is SQL Server 2008 Express R2. We'll install it on all of our users machines, as well as laptops that go off site for several months at a time. Anyway, in helping my co-workers to setup their development systems with SQL Express, I've noticed that not everyone can install SQL Express 2008 R2 as the default instance. This causes me a [u]lot[/u] of concern, because the new app should have only 1 connection string. I'm used to writing apps with only 1 connection string, normally put into some configuration file, etc.Anyway, is there a way I can get around the fact that different machines may have different instances of SQL Express installed, and that I may have to specify different connection strings in the configuration files? I would like to have a turnkey solution that one could easily install, but am afraid that setting up the finished app on users machines may require more hand editing than I care for. How can I get around this?Thu, 04 Aug 2011 21:13:52 GMTDoctor Who 2http://www.sqlservercentral.com/Forums/Topic1155852-324-1.aspxHi,i have to import data from xl sheet into the database, in Xl sheet there is only 1 column of data (approx 2000 rows) to be imported into a single table in a Database say "DA". Lets call this table in DA as "X". X contains a list of 10-20 different fields within it however i need to add the list from XL sheet to field say "10" in table X of database DA.This field "10" at the moment contains 20 records say from p1 to p20... So thus i have to import those 2000+ rows in the field "10" and replace + add the existing recordset in Field "10".Also while doing so, the other fields 1-9 and 11-20 needs to be updated too, though most of the fields are NULL but some 3-4 fields out of the 20 fields contain a value which ofcourse will be repeated for again for about 2000 records set as well (it has only 1 value in it for all the recordset.How do i perform this whole operation and at the same time update all the other fields with its respective or NULL values ?I have access to only SQL Studio Express and thats the only tool i have to work with.regardsabhiMon, 08 Aug 2011 01:25:09 GMTabhishekm30http://www.sqlservercentral.com/Forums/Topic1154680-324-1.aspxHi Guys Have SQL Server 2005 Express 32 bit installed on win-7 64 bit.after installation when i am trying to create new data base its doesn't allow me to do .Error show: create database permission denied in database 'master' (microsoft sql server error:262)So any Ideas ?pls reply me ASAPThanksThu, 04 Aug 2011 16:08:16 GMTlogicinside22http://www.sqlservercentral.com/Forums/Topic1150626-324-1.aspxI recently got started with Visual Studio 2005 to build websites. Everything was going pretty smoothly. I set up user security for my site using the Website Administration Tool and it automatically created an SQL Server database in my APP_DATA folder called ASPNETDB.MDF.However the next step was to start importing my data into the SQL Server database. I did some searching online and it appeared that in order to export data from Access to SQL Server, I needed SQL Management Server Express, so I downloaded it and installed it.When I opened up SQL Management Server Express, I noted that my website database was not there so I had to "attach" it, which I did. Then I was able to go into Access, create an ODBC DSN and start exporting the tables I needed. I then re-opened up Visual Studio and was happy to see that my tables had successfully been imported into my ASPNETDB.MDF database. However, now I cannot connect to the SQL Server database. I have tried everything. When I try to create a new data source, it says "database schema could not be retrieved" and login failed for user COMPUTERNAME\USERNAME".Then when I go back into the website administration tool, it tells me that it could not establish a connection to the database and that I should use aspnet_regsql command-line utility. When I do this, it also errors, saying:[quote]"An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 262 and the SqlException message is: CREATE DATABASE permission denied in database 'master'.Creating the aspnetdb database..."[/quote]I have even tried uninstalling SQL Management Express and creating a brand new website but I still get the same errors. I really hope I do not have to reinstall Visual Studio all over again to get it back working because that took forever.I am really shocked that all of this has been so difficult, even the very most basic website requires importing data from an external source, so why is it so difficult to accomplish with Visual Studio?Any help to my predicament would be greatly appreciated.:-)Thu, 28 Jul 2011 18:54:22 GMTgarethmann101http://www.sqlservercentral.com/Forums/Topic757837-324-1.aspxAs everyone knows, SQL Server Express does not have a SQL Server Agent nor does it have the innate ability to send an email based on events or triggers.My question is, has anyone successfully built a SP or Trigger that will send an email to one or more individuals based on either an event occurrence or a data update in a table from either SQL 2005 or 2008 Express? If so, can you explain how to do it?Wed, 22 Jul 2009 14:01:40 GMTrobert.johnson2http://www.sqlservercentral.com/Forums/Topic820372-324-1.aspxHi all,I amnew to this env. How can i backup SQL Express 2005 database. I tried installing SSMS but it did not let me. How can i do backup from command level?ThanksTue, 17 Nov 2009 13:37:16 GMTpat-261672http://www.sqlservercentral.com/Forums/Topic1141496-324-1.aspxHi all,thanks for reading my comment.We are working with SQL Server 2005 Express Version and I was amazed of the growing up Database in the System.In one year only the DB was growing up to over 1GB and there comes up many problems in case of access to the DB, now.We want to Shrink the DB but doesn´t know how to do that in the correct way.Some Information about the POS-System, where the DB runs:IBM SurePOS 300 with 40GB Memory on Harddisk, 1GB RAM (some Stations are installed with 2GB RAM), Windows XP, SP3.If you have any Information, please write back in this Forum.Thank´s a lot!Regards,AndreasThu, 14 Jul 2011 00:49:43 GMThorkyhttp://www.sqlservercentral.com/Forums/Topic1139263-324-1.aspxWhen I try to run the SQL Server 2008 Express install, for the management studio only, it is failing on one PC. The PC is running Windows XP, and the version of management studio that I am trying to install is 10.0.1600.22, file name is SQLManagementStudio_x86_ENU.exe. This has worked fine on 4 other PCs so far, but will not run on this one.I installed the Windows Installer 4 and Powershell before trying to install Management Studio. When I try to install Management studio it extracts the files to the random temp folder, but as soon as it finishes extracting, a CMD prompt pops open and immediately closes, then the temporary installation files that it just extracted are deleted. I have tried to see what the CMD prompt displays, but it is never open long enough to see what it says. I looked for the log files, but "C:\Program Files\Microsoft SQL Server\100" never gets created, and I can't find any other log files.I have tried restarting, and doing a cold boot, but that made no difference. I also tried installing from the command line:SQLManagementStudio_x86_ENU.exe /q /FEATURES=SSMS /ACTION=InstallThis also did not help.I am not closing the SQL Server Installation Center, in fact, it never seems to actually start.Has anyone seen this before?Fri, 08 Jul 2011 15:35:59 GMTjames.underwoodhttp://www.sqlservercentral.com/Forums/Topic1135157-324-1.aspxI'm trying to write a simple app, using Visual Studio 2010, to test accessing a SQL Server 2008 Express database. I've tried using Windows Authentication, but that fails, all of the time. I had created 2 SQL Logins and users for my SQL Express database, and assigned to both of them the database that I want to use, as their default database. Saved the changes.As luck would have it, I've been wrapped up with end-of-fiscal-year activities totally unrelated to this work. Have been for weeks. But today I thought I'd give it another try. I got into SSMS and tried to open the SQL 2008 Express database, using Windows Authentication. But now I can't even do that! I get this error:"Cannot connect to MYPC\SQLEXPRESSCannot open user default database. Login failed.Login failed for user 'MYDOMAIN\rod'. (Microsoft SQL Server, Error: 4064)"Great scott, this is how I created the thing in the first place, and man I put in a heck of a lot of time designing that SQL 2008 Express database!!! Almost 100 tables, views and stored procedures, and now I can't even open it using the very same authentication method that I used to create it?! What's going on here???If I choose one of the 2 SQL logins/users that I created, I get much the same error message:"Cannot connect to MYPC\SQLEXPRESSCannot open user default database. Login failed.Login failed for user 'intake'. (Microsoft SQL Server, Error: 4064)"("intake" was one of the SQL logins I created.)So, have I lost about 2 weeks of work setting up the database? It looks like I can't get into SQLEXPRESS at all on my PC anymore. Why is that? Frankly, I'm extremely frustrated with this thing. THis is meant to replace a mission critical application, and if I cannot open it is SSMS, there's no way I'll ever be able to open it in any app I write. I need help, please.I'm working on a Windows 7 Ultimate machine, 32-bit. I've got SQL Server 2008 R2 Developer Edition installed, and that's the SQL Server Management Studio version that I use to access everything. I installed SQL Server 2008 Express onto my machine, and that's what I'm trying to use as a local data store, which I'd like to use for installing on user machines. (I didn't install SQL Server 2008 Expression R2, for no reason other than I just didn't, but I was thinking it wouldn't matter.)Fri, 01 Jul 2011 09:52:14 GMTRod at workhttp://www.sqlservercentral.com/Forums/Topic1085701-324-1.aspxI have MSSQL 2005 Express Edition installed on my Windows XP sp3 computer.I just installed MSSQL 2005 Express Edition sp4 but when I run @@version I get the following:Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 20 2010 Coyright (c) 1988-205 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600 Service Pack 3).I believe that 9.00.5000.00 is 2005sp4RTM but I am wondering why it shows "(Build 2600 Service Pack 3)" when it should be Service Pack 4.I am not certain if everything is okay or not.Any information on this would be appreciated.ThanksHowardTue, 29 Mar 2011 10:29:01 GMThmbtxhttp://www.sqlservercentral.com/Forums/Topic1126136-324-1.aspxI don't know if this is possible but I'm going to ask anyway. Right now we have an SQL database (SQL Server express 2005) that is used for our Cencon locks. This is a mission critical data base for us. What I need to know is, is it possible to sync this database with another database I created on a different server as a backup? I can always do a restore from a backup copy of the database, but I was hoping that there was a way to automatically sync them at regular intervals.I looked at doing a cluster server but this is the only thing that we need to sync, so the expense out weighs the benefit.Thanks,Michael D. WinnWed, 15 Jun 2011 15:27:14 GMTmwinn