SQLServerCentral.com / SQL Server Express / SQL Server 2005 InstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 08:55:34 GMT20How to replace multiple items in a column in sql server express tablehttp://www.sqlservercentral.com/Forums/Topic1779653-324-1.aspxHi :-)Can anyone help me with a job I have to do - I have an sql server express db where 1 table lists certain users data - in particular one of the columns in that table is called email and within that column are users email addresses.There are 300 rows/email addresses in that column that I need to change to a different email address.Any ideas how I do that?Much appreciated :-):-):-)Thu, 21 Apr 2016 04:08:28 GMTironryonEncryptByKey and DecryptByKey Newbie???http://www.sqlservercentral.com/Forums/Topic319116-324-1.aspxThis is my first attempt encrypting/decrypting data in a SQL 2005 DB.I found some very useful info here:<A onclick="return openNew(this.href);" href="http://www.sqlservercentral.com/columnists/mcoles/sql2005symmetricencryption.asp" target=_blank rel=nofollow>http:<WBR>/<WBR>/<WBR>www.<WBR>sqlservercentral.<WBR>com/<WBR>columnists/<WBR>mcoles/<WBR>sql2005symmetricencryption.<WBR>asp</A>but, I'm unsure of my results. Here's the code so far that I'm testing in SQL Querry Analyzer:CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'p@ssw0rd'-- Create a CertificateCREATE CERTIFICATE MyCert WITH SUBJECT = 'My DB Access', EXPIRY_DATE = '10/31/2010'-- Create a Symmetric KeyCREATE SYMMETRIC KEY MySymKey WITH ALGORITHM = TRIPLE_DES ENCRYPTION BY CERTIFICATE MyCertOPEN SYMMETRIC KEY MySymKey DECRYPTION BY CERTIFICATE MyCert--Adding DataOPEN SYMMETRIC KEY MySymKey DECRYPTION BY CERTIFICATE MyCertINSERT INTO table1 (col1) VALUES (EncryptByKey(Key_GUID('MySymKey'), 'ThisAndThat.com'))Result: unreadable encryption code--Reading DataOPEN SYMMETRIC KEY MySymKey DECRYPTION BY CERTIFICATE MyCertSELECT DecryptByKey(col1) FROM table1Result: 0x54686973416E64546861742E636F6DQ. Why aren't my results; "ThisAndThat.com" ????Mon, 30 Oct 2006 12:28:00 GMTKevin SnyderSchedule DBCC Checkdb in SQL 2005 Express?http://www.sqlservercentral.com/Forums/Topic1737424-324-1.aspxI've just inherited a number of SQL Server 2005 Express installations. Whilst I am able to schedule backups for them using scripts/windows scheduler (there is no scope for installing any tools), can I schedule DBCC CheckDB to run?If anyone can point me to any existing scripts (Google is failing me), I would very much appreciate it.ThanksBexTue, 17 Nov 2015 08:28:02 GMTBexMSMXL3.dll The operation timed out. XMLHTTPhttp://www.sqlservercentral.com/Forums/Topic987911-324-1.aspxHey guys,I'm not sure what this sp does. a previous developer created it and it has stopped working. I'm tryin to fix it but I'm having no luck. from what I understand it qeuries a url and gets the response xml back.[code="sql"]DECLARE @url varchar(300) DECLARE @win int DECLARE @hr int DECLARE @text varchar(MAX)SET @url = 'http://test.co.za/v1/runimport.asp'EXEC @hr=sp_OACreate 'MSXML2.ServerXMLHTTP',@win OUT IF @hr &lt;&gt; 0 EXEC sp_OAGetErrorInfo @win EXEC @hr=sp_OAMethod @win, 'Open',NULL,'GET',@url,'false'IF @hr &lt;&gt; 0 EXEC sp_OAGetErrorInfo @win EXEC @hr=sp_OAMethod @win,'Send'IF @hr &lt;&gt; 0 EXEC sp_OAGetErrorInfo @win EXEC @hr=sp_OAMethod @win,'waitForResponse', NULL, 6000IF @hr &lt;&gt; 0 EXEC sp_OAGetErrorInfo @win/*EXEC @hr=sp_OAGetProperty @win,'ResponseText',@text OUTPUTIF @hr &lt;&gt; 0 EXEC sp_OAGetErrorInfo @win*/IF object_id ( 'tempdb..#xml' ) is not null DROP TABLE #xml CREATE TABLE #xml (data VARCHAR(MAX) NULL) INSERT #xml ( data )EXEC @hr=sp_OAGetProperty @win,'ResponseText' SELECT * FROM #xml DROP TABLE #xmlEXEC @hr=sp_OADestroy @win IF @hr &lt;&gt; 0 EXEC sp_OAGetErrorInfo @win [/code]I changed the code a bit. I did some research and it said the ResponseText cannot be more than 8000 chars. was getting an error so the temp table seems to have fixed it.however now I get an msxml3.dll errorr saying the operation timed out.I would really appreciate some help as this fix is urgent and I'm badly stuck. thanks guysFri, 17 Sep 2010 00:23:10 GMTniteshrajgopalCustom Installhttp://www.sqlservercentral.com/Forums/Topic1690726-324-1.aspxHi,If you install SQL Server Management Studio Express 2005, will it overwrite any installed instances?Can you do a custom install?Tue, 02 Jun 2015 03:30:11 GMTspannerincMicrosoft SQL Server Management Studio Express - datetimehttp://www.sqlservercentral.com/Forums/Topic415793-324-1.aspxHow do I make Microsoft SQL Server Management Studio Express display Datetime variables in a table in the format of my choice ( when viewing those timedate variables on Studio Express)Currently they display as nn/dd/yy hh:mm:ss AM/PMI would much prefere to see them as yyyy/nn/dd HH:mm:ss( I appreciate they are stored ion the database as Timedate (double integer) -- I am talking aboit how the application STudio Express choses for format the date & time when it displays the values in the tables)Sun, 28 Oct 2007 11:14:17 GMTsql-532250SQL Server 2005 Express installationhttp://www.sqlservercentral.com/Forums/Topic1688700-324-1.aspxHi,I developed a setup where i need to install SQL Server 2005 Express edition. This should work in all the OS + Language combination. This is pretty working well in all the OS combinations testedAt one point of time, while testing in Windows 7 Chinese, SQL Server installation stopped suddenly. I examined summary log file and noticed that OS description is written as "Windows XP". This is very strange and i don't find any explanation for this.Is anybody faced similar issue like this? Any help / suggestions to overcome this issue is very much appreciated.Thanks in AdvanceVenkatesanTue, 26 May 2015 07:34:11 GMTK.S.VenkatesanNeed urgent helphttp://www.sqlservercentral.com/Forums/Topic1681048-324-1.aspxHello all.I am having some issues about SQL Server Configuration Tools. I am using SQL Server 2005 Express edition SP 4 on my Windows 7 Ultimate 32-bit machine.I am unable to run any of those tools, SQL Server Configuration not SQL Server Surface Area.SQL Server is running and every required service is running also.Sincerely grateful for any kind of helpFr. Ivan DelicSerbiaWed, 29 Apr 2015 01:52:12 GMTpriest Ivan DelicUpdate statement times out on a small tablehttp://www.sqlservercentral.com/Forums/Topic1646539-324-1.aspxHello all,I have a portal web site that shows the state of about 20 client computers in real time. I use SQL Server Express 10.50.4000.0 that runs on Microsoft Windows NT 5.2 (3790) server as a back end. Client computers (win 7) are connected to the network through wireless connections.I have a table on the server with one row per client computer. Each client computer updates its own row every second with the latest data. There should be no locking issues because each machine updates its own row.CREATE TABLE [dbo].[Table_Name]( [col1] [char](12) NOT NULL, [col2] [varchar](20) NULL, [col3] [int] NULL, [col4] [varchar](20) NULL, [col5] [int] NULL, [col6] [int] NULL, [col7] [int] NULL, [col8] [char](1) NULL, [col9] [int] NULL, [col10] [int] NULL, [col11] [int] NULL, [col12] [int] NULL, [col13] [int] NULL, [col14] [int] NULL, [col15] [datetime] NULL, [col16] [int] NULL, [col17] [int] NULL, [col18] [int] NULL, [col19] [int] NULL, [col20] [int] NULL,PRIMARY KEY CLUSTERED ( [col1] ASC)The portal web site runs a select of all the rows every 2 seconds. The machines and the site run 24/7.Everything works fine, except I am getting timeout errors: [i]Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.[/i] Sometimes I get an additional [i]A severe error occurred on the current command. The results, if any, should be discarded. [/i] I am getting about 10-15 errors every day, at random times.My assumption is that because the table is so small, it fits into one page, and when sql server places the lock for an update, it locks the page, and that page being the only page in the table, it locks the whole table.Since this application is just a portal, losing a random update is not a big deal - it only means that one of the little squares on the portal web site will 'skip a beat'. But I would really like to get rid of the timeout errors. I know that i can an update with NOLOCK, but that I would like to know ahead of time if this is what I need to do to get rid of timeouts. On every sql forum everyone advises against the NOLOCK, so I would like to hear from an expert that this is what I need.Could anyone please help me out.Thank you,Helen.Fri, 26 Dec 2014 08:03:07 GMTgoussarovaSP4 on Expresshttp://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 GMTsqlquest2575sql server 2005??????http://www.sqlservercentral.com/Forums/Topic1447440-324-1.aspxhello,i have big problems using sql server 2005 with access 2010, actually the data base was attached and detached from access 2007, and i was obliged to install another server in my personal computer with access 2010, since then i can't open my project using this one.i've created another sql instance "mycomuter\sqlexpress" and i switched to tcp/ip mode using port:1433.i have no problem with attaching my data base but i can't open it on access 2010.it says : " [DBNETLIB][ConnectionOpen(Connect())."....what should i do , I've tried everything but i can't fix it.i'll appreciate your help.thx.Mon, 29 Apr 2013 04:38:36 GMThninousserestore databasehttp://www.sqlservercentral.com/Forums/Topic1639960-324-1.aspxSystem.Data.SqlClient.SqlError: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database. (Microsoft.SqlServer.Express.Smo)Sat, 29 Nov 2014 05:19:22 GMTmukesh28infoDatabase backup maintenance failedhttp://www.sqlservercentral.com/Forums/Topic1627931-324-1.aspxHi everyone, I'm new here but appreciate if anyone can help me out on this.Found this error since 19th Oct. Previously the backup maintenance plans were perfectly fine.Executing the query "BACKUP DATABASE [TeamMate_Production] TO DISK = N..." failed with the following error: "Read on "E:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\TeamMate_Production.mdf" failed: 1(Incorrect function.)BACKUP DATABASE is terminating abnormally.10 percent processed.20 percent processed.30 percent processed.40 percent processed.50 percent processed.60 percent processed.70 percent processed.80 percent processed.90 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.Also, I execute DBCC ChECKDB and found 4 consistency errors. Below are the errors for your reference:Msg 8966, Level 16, State 2, Line 1Unable to read and latch page (1:367495) with latch type SH. 1(Incorrect function.) failed.Msg 8929, Level 16, State 1, Line 1Object ID 1426104121, index ID 1, partition ID 72057594054901760, alloc unit ID 72057594057457664 (type In-row data): Errors found in off-row data with ID 2520252416 owned by data record identified by RID = (1:348730:10)Msg 2533, Level 16, State 1, Line 1Table error: page (1:367495) allocated to object ID 1426104121, index ID 1, partition ID 72057594054901760, alloc unit ID 72057594057588736 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1426104121, index ID 1, partition ID 72057594054901760, alloc unit ID 72057594057588736 (type LOB data). The off-row data node at page (1:367495), slot 0, text ID 2520252416 is referenced by page (1:367418), slot 0, but was not seen in the scan.Wed, 22 Oct 2014 19:37:50 GMTliana.dinaPlease help me out in thishttp://www.sqlservercentral.com/Forums/Topic1601042-324-1.aspxDear All,Table having data like:(Employee) (Project) (Allocation) (Allocated_From) (Allocated_To)(E1) (P1) ( 36 ) ( 2014-08-08) (2014-10-30)(E1) (P2) ( 40) ( 2014-09-08) (2014-11-30)Scenario-1If i search E1 Employee From(2014-08-08) to (2014-11-30)want output like(Employee) (Allocated_From) (Allocated_To) (Allocation)(E1) (2014-08-08 ) (2014-09-07) (36)(E1) (2014-09-08 ) (2014-10-30) (76)(E1) (2014-11-01 ) ( 2014-11-30) (40)Scenario-2If i search E1 Employee From(2014-05-01) to (2014-12-15)output like(Employee) (Allocated_From) (Allocated_To) ( Allocation)(E1) (2014-05-01) (2014-08-07) (0)(E1) (2014-08-08) (2014-09-07) (36)(E1) (2014-09-08) (2014-10-30) (76)(E1) (2014-11-01) (2014-11-30) (40)(E1) (2014-12-01) (2014-12-15) (0)Scenario-3If i search E1 Employee From(2014-05-01) to (2014-10-15)output like(Employee) (Allocated_From) (Allocated_To) (Allocation)(E1) (2014-05-01) (2014-08-07) (0)(E1) (2014-08-08) (2014-09-07) (36)(E1) (2014-09-08) (2014-10-15) (76)RegardsNarayananFri, 08 Aug 2014 00:46:26 GMTvemula.narayananHow to use dbo procedure to execute for different schema?http://www.sqlservercentral.com/Forums/Topic1605729-324-1.aspxI am using SQL Server 2008 R2, I have a schema [dbo], and in that schema, I have created a stored procedure dbo.GetAccount:[code="other"]Create procedure dbo.GetAccountAsBeginSelect * from tblAccountNetEnd[/code]Then, I have created a schema [ABC] with user named UserABC.Now, I would like to login with UserABC and execute dbo.GetAccount for schema [ABC] to get all user of it and don't want to change code of dbo.GetAccount. So, how can I do?Thanks for your help.Thu, 21 Aug 2014 04:10:28 GMTphuchy220284getting null values while imporing from excelhttp://www.sqlservercentral.com/Forums/Topic1589195-324-1.aspxhi,I am using following query... SELECT * FROM OPENROWSET('Microsoft.Ace.OLEDB.12.0', 'Excel 12.0;DATABASE=E:\EXCELFILES\EXCEL_2014.xls', 'Select * from [sheet1$]')in my sheet one column contains numeric values, but some of the rows are string. when importing this data numeric values coming properly but string values imported as nulls.ex: value -------- 10 15 20 str 25imported as value -------- 10 15 20 NULL 25can any one have idea on this....thankyou.Thu, 03 Jul 2014 23:12:12 GMTvissuHow to convert sql server express data to MS Access (.mdb) formathttp://www.sqlservercentral.com/Forums/Topic1584002-324-1.aspxAnybody,Does anyone know of a way that I can pull all of the data from all of my tables in my Sql Server Express 2008 database and convert it to a .mdb format? My company is taking over the support of a web application and moving it to a new server. The new server has a Sql Server Express instance running on it. The application is currently hosted at a location that has a full-blown version of Sql Server and accomplishes this task via SSIS. Currently, the user of the application can click a link on the website that allows them to download a zipped .mdb file onto their local machines. Does anyone know of a way to do this without using SSIS? Please. I am at witts-end.Thanks,BarryThu, 19 Jun 2014 11:58:09 GMTbarry 50045Microsoft SQL Server 2008 and 2008 R2 compatibility issue in Visual studio 2010http://www.sqlservercentral.com/Forums/Topic1578746-324-1.aspxWhile working on windows form application i am facing issues as Microsoft SQL Server 2008 and 2008 R2 compatibility in Visual studio 2010. I am using a .mdf file.Mon, 09 Jun 2014 04:21:48 GMTgamechangermayaOLE DB provider "SQLNCLI" for linked server "(null)" returned message "Unable to complete login process due to delay in opening server connection"http://www.sqlservercentral.com/Forums/Topic1554707-324-1.aspxHi folks,I have a back-office server running Windows XP Professional SP3 with SQL 2008 Express R2 server and 3 clients running Windows XP Embedded with SQL 2005 Express.The POS application (MS Retail Management) throws the following error message when running a sync process with the SQL 2008 and SQL 2005 server...[i]OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Unable to complete login process due to delay in opening server connection"[/i]I reviewed some posts and they all point to install the SQL Server 2008 R2 Native Client OLEDB, I did and I still get the same error when running the sync process.I should add these hosts are behind the firewall and only connection allowed from clients to the back-office server is TCP 1433.Any pointers, ideas or suggestions are much appreciated.Thanks,...AlexTue, 25 Mar 2014 15:31:33 GMTAlex W. CaldasSQL 2008 SSMS Server Management Studio crashes all the time since last week.http://www.sqlservercentral.com/Forums/Topic743851-324-1.aspxSQL 2008 Express Server Management Studio SSMS crashes all the time with the following message:SSMS - SQL Server Management Studio has encountered a problem and needs to close. We are sorry for the inconvenience.What can I do??? Please Help! Is this a .NET Framework issue??!! How can I get more on this error??Thanks so much!!!Mon, 29 Jun 2009 11:42:48 GMTAlan LevinShould I backup the transaction log?http://www.sqlservercentral.com/Forums/Topic1548871-324-1.aspxWe're recently deployed a new application which uses SQL Server 2008 R2 Express for local storage. (Yes, I know that this forum is only for SQL Server 2005 Express, but I couldn't find an appropriate forum for SQL 2008 R2 Express.) Now, the express versions of SQL Server I know are not full fledged versions of SQL Server. In particular, there's no SQL Job Agent for SQL Express. I bring this up because normally I put the backup of databases and what's relevant to my question, the backup the transaction logs, into a SQL Job I schedule in SQL Job Agent in regular SQL Server.So my question is, should we be backing up our SQL Server 2008 R2 Express databases and transaction logs? Especially to keep the transaction logs from growing too large on the users' machines? If so, how is that done?Fri, 07 Mar 2014 12:52:21 GMTRod at workRebuild Script Has Been Running 24 Hourshttp://www.sqlservercentral.com/Forums/Topic1548708-324-1.aspxI am using SQL Express 2005. A database has reached its maximum size and needs to be shrunk. Prior to shrinking I checked the database and found several error in the index. So I did a backed up and ran the following script to repair and rebuild alter database sbsmonitoring set SINGLE_USERDBCC CHECKDB (sbsmonitoring, repair_rebuild)alter database sbsmonitoring set MULTI_USERThe script has been running for 24 hours.Is it normal to take this long to repair and rebuild a 4 gig database?At what point do I take some action and what steps would I take to correct the situationThanksFri, 07 Mar 2014 06:20:36 GMTppierce10Replicate Sql Express table to Non-Express databasehttp://www.sqlservercentral.com/Forums/Topic1544713-324-1.aspxHi,I have a SQL 2008 Express table that I would like to replicate to a sql server 2008 database on a remote server. Since Express does not have the publisher function, is there an alternate method in replicating a sql Express table to a non-Express database?Thank You,nuchbcMon, 24 Feb 2014 14:14:22 GMTNoochTrying to install SQL Server Exp 2008http://www.sqlservercentral.com/Forums/Topic1543215-324-1.aspxMy box is running on Windows XP SP3, so I can't run SQL Server 2012 Express. I downloaded the SQL Server 2008 Express exe installation file from cnet (SQLEXPR_x86_ENU.exe), and double-clicked it. It seemed to install, but ended by opening a window, "SQL Server Installation Center", which is nothing more than a few links and tools. There's nothing to start SSE, nor does SSE appear in my start &gt; programs menu. Nor does it list under the installed programs when I go to "Add or Remove Programs" in the control panel, so I can only assume the installation isn't complete. I went looking in the SQL Server folder itself for a launch script, but I don't want to go through double clicking unknown exe files.I came across the footnote below on http://msdn.microsoft.com/library/ms143506%28SQL.100%29.aspx. I'm just trying to install SSE without advanced services or tools. Do I need the tools to have a visual GUI? In any event, I have Windows installer 4.5 and .NET Framework 2.0 SP2, so I'm not sure what the problem is."SQL Server Setup will not install the following required components for SQL Server Express ,SQL Server Express with Tools, and SQL Server Express with Advanced Services. You must install these components manually before you run SQL Server Setup: SQL Server Express — .NET Framework 2.0 SP2 and Windows installer 4.5. On Windows Vista, use .NET Framework 3.5 SP1. SQL Server Express with Advanced Services — .NET Framework 3.5 SP1, Windows Installer 4.5, and Windows PowerShell 1.0. SQL Server Express with Tools — .NET Framework 3.5 SP1, Windows Installer 4.5, and Windows PowerShell 1.0."Wed, 19 Feb 2014 14:06:06 GMTchristophe.masoHow to debug stored procedure in SQL Server Expresshttp://www.sqlservercentral.com/Forums/Topic313996-324-1.aspxHi there,Is there anyone know how to debug a stored procedure in MS SQL Server Management Studio Express version? I've the problem to debug my stored procedure. Please help!Many thanks,ACSat, 07 Oct 2006 11:19:00 GMTArthurCUnable to open the physical file "". Operating system error 2: "2(The system cannot find the file specified.)". (Microsoft SQL Server, Error: 5120)http://www.sqlservercentral.com/Forums/Topic1530325-324-1.aspxTITLE: Microsoft SQL Server Management Studio Express------------------------------Attach database failed for Server 'NGOCHOANG-VAIO\BMSSERVER'. (Microsoft.SqlServer.Express.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)------------------------------Directory lookup for the file "D:\BMSMoi2013\DATA2013\BMS_2013.mdf" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft SQL Server, Error: 5133)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5133&LinkId=20476------------------------------BUTTONS:OK------------------------------Screen : [img]http://imagizer.imageshack.us/v2/800x600q90/35/wiok.png[/img]Pls help me! Email : ngochoang297@gmail.comSkype : Robertsnguyen:-)Mon, 13 Jan 2014 08:45:46 GMTngochoang297Error: 5133 when i attach database!http://www.sqlservercentral.com/Forums/Topic1530518-324-1.aspxTITLE: Microsoft SQL Server Management Studio Express------------------------------Attach database failed for Server 'NGOCHOANG-VAIO\BMSSERVER'. (Microsoft.SqlServer.Express.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)------------------------------Directory lookup for the file "D:\BMSMoi2013\DATA2013\BMS_2013.mdf" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft SQL Server, Error: 5133)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5133&LinkId=20476------------------------------BUTTONS:OK------------------------------Screen :[img]http://imagizer.imageshack.us/v2/800x600q90/35/wiok.png[/img]Pls help me!Email : ngochoang297@gmail.comSkype : Robertsnguyen [Smile]Mon, 13 Jan 2014 19:41:08 GMTngochoang297When i run setup of sql server 2008 R2 on windows 7 it shows error "Windows is unable to start correctly 0Xc0000005"http://www.sqlservercentral.com/Forums/Topic1526735-324-1.aspxWhen i run setup of SQL Server 2008 R2 on windows 7 it shows error "Windows is unable to start correctly 0Xc0000005". Please propose any solutionsI will be very thankful to all of youTue, 31 Dec 2013 06:15:32 GMTAwais NazimList of SQL Server Express gotchas?http://www.sqlservercentral.com/Forums/Topic1513094-324-1.aspxIs there a list anywhere of the different behaviour of SQL Express?It's things like the Auto Close setting defaulting to on whatever you choose in the Model database.Is this a one off or are there lots of these?(Not the size/memory limits)Mon, 11 Nov 2013 05:45:56 GMTJames_UK_DevGetting a "not a valid login" error when installing SQL 2008 R2 Expresshttp://www.sqlservercentral.com/Forums/Topic1512372-324-1.aspxI've got a SQL script to create a database and populate it with the necessary tables, views and stored procedures. I've also added what I thought would be the necessary SQL code to create 2 new logins. But whenever I run this on a machine, I always get this error (I'll show just one error, but it's the same for the other login):[quote]'intake' is not a valid login or you do not have permission.[/quote]Now, as it so happens, I always create these installations with the logged in user having administrator rights on that instance of SQL 2008 R2 Express, so I don't believe they don't have enough permissions. I'm doing this on Windows 7 Professional machines.I'm beginning to wonder, would I be better off writing a SQL script to create the 2 logins, run that first, and then run the SQL script to create the database?Thu, 07 Nov 2013 10:29:54 GMTRod at workCannot find SSMS on server to connect to SQLExpress2005http://www.sqlservercentral.com/Forums/Topic1511054-324-1.aspxHi everyone,I have a SQL Express 2005 instance on our Blackberry server. I can see the location of the database and log files on the E drive and the error logs etc but I can't connect to the instance as I cannot find any software on the server to let me to do so. I also don't have access to the server myself via windows authentication and we don't know the sa password so cannot connect from my own SSMS on my laptop. I've searched both C and E drive for ssms, all .exe's and found no SQL softwareAny ideas?thanksGMon, 04 Nov 2013 04:55:39 GMTG_DubyahInstalling SQL 2008 Express on a PC with the Native Clienthttp://www.sqlservercentral.com/Forums/Topic1508514-324-1.aspxHello,I've been having fits trying to install SQL 2008 Express on a virtual machine. It always gives me an error that it cannot find sqlncli_64.msi and says the network resource where it resides is no longer available. However, I was not installing off the network.As a test, I tried removing the Microsoft SQL Server 2008 R2 Native Client first, and then SQL 2008 Express installed without a problem.Does anybody have an idea of how I can have both of these on the same computer? I would try installing in the other order but our standard image has the Native Client on it already.Thanks.Fri, 25 Oct 2013 09:59:04 GMTherronsSQLExpress and localhosthttp://www.sqlservercentral.com/Forums/Topic1507678-324-1.aspxAll:I am a newbie to networking and SQLSEREVER. I have installed SQLExpress 2008 on my laptop and I am not connected (wired or wireless).I would like to access it using a link like [b]http://localhost:1433/SQLEXPRESS. [/b]I am not able to make it work.Why I need this:------------------------------------------My plan is to connect JIRA to SQLEXPRESS and the JIRA setup is looking for a link like http://localhost:1433/SQLEXPRESS to connect to SQLEXPRESS.----------------------------My settings:---------------------------------------TCP/IP enabled( IpAddresse/IPAll : TCP Dynamic Port &lt;empty&gt;, TCP PORT : 1433)The services SQLSERVER and SQLBRowser are both running.-------------------------Is there anything else I should be doing. Any help is appreciated.Thanks for your help.BzooWed, 23 Oct 2013 08:39:09 GMTbilljasidatabase 'master' is not valid 9003 error Help!!!http://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 GMTfuatm16unable to delete, File is openhttp://www.sqlservercentral.com/Forums/Topic1500726-324-1.aspxHi am delete database but it says:cannot delete database because the file is open in sql server, I can see the database from:C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATAbut unable to deleted through right click- delete. plse advise.Thank you for your time.Wed, 02 Oct 2013 04:56:15 GMTPiyaKaGharSQLCMD capture output from :ServerList to a file?http://www.sqlservercentral.com/Forums/Topic416263-324-1.aspxIs there a way to have the output from :ServerList redirected to a file?I tried :ServerList -o C:\Test.txtand:serverlist :Out C:\Test.txtTks.Mon, 29 Oct 2007 18:39:48 GMTJohn Griffithsnot able to connect to the server in MS sql Management Studios 2005http://www.sqlservercentral.com/Forums/Topic1492554-324-1.aspxI downloaded and installed MS sql management studio(MSSMS2005) from Microsofts's site. followed every instruction which was showed on the webpage.. now when i try to open MSSMS2005, a windows pop in and asks for server name.. and there is no name available in the drop down list for selection..kindly help me outSat, 07 Sep 2013 15:13:24 GMTsagarmanocha57new comer of sql server 2005http://www.sqlservercentral.com/Forums/Topic1387790-324-1.aspxhow to study sql server 2005, as a dotnet developer what are the concepts should know and what are the concepts in sql server 2005Thu, 22 Nov 2012 02:52:46 GMTboobalanmca07Unable to Access Analysis Services.http://www.sqlservercentral.com/Forums/Topic1484220-324-1.aspxHi,I have installed SQLExpress 2012 on my local machine. I am able to access the server to check the database. When i try to access the analysis services, i get the message stating the user needs atleast read access on one of the databases. This is another error message i get A connection cannot be made. Ensure the server is running. No Connection could be made because the target machine actively refused it. 127.0.0.1:2383.My Firewall connections have been checked it is fine.Any Suggestions?Regards,Renato.Wed, 14 Aug 2013 05:46:43 GMTrenato_mech_334How do I give all logged in users CRUD privileges to a database?http://www.sqlservercentral.com/Forums/Topic1480624-324-1.aspxI've got a SQL Server 2008 R2 Express database that we're going to be using for an application we're re-writing. Currently we're using entity framework 4.2 to access it, but the connection string uses SSPI, so (as I understand it) that means it's using the currently logged in user. I thought I had that fixed, but apparently I don't. I want to make it so that all users properly logged into their Windows account will be able to do normal CRUD operations as well as run user defined stored procedures, in that SQL Express database. How do I accomplish that?Never mind, I've asked this question already.http://www.sqlservercentral.com/Forums/Topic1471731-324-1.aspxFri, 02 Aug 2013 15:10:53 GMTRod at work