I am pulling my hair out here... I don't seemt o be able to solve this issue. I am Developing a new website using Sql Express. But I get this error sporadically claining that the "file is in use by another process".
Thinking it is the Express management Studio I shut it down.... Nope still errors..
Ok maybe it is the XSD designer.... So I close that XSD designer window in visual Studio.... nope still erroring.
hmmm... Maybe I'll shutdown Visual Studio and try that... Nope still gives the error.
Ok let restart the SQL Express Services.. Nope still errors.
OK OK REBOOT... Now it works for about two testing iterations. Then it starts all over....
What is locking this file? Is their any tools out there to tell me what is locking the File?
I am using XP Home Edition, VS 2005 Statndar Edition with Sql Express...
I find that after the website has been running for a while I can no longer open the database using SQL Server Management Studio Express (I get an error indicating that the physical file has been locked). Even if I shutdown and restart both IIS and SQL Server, it remains locked and can only be opened once I find and "End Process" all the sqlservr.exe instances from the Task Manager.
Is this a known issue? Any way to find out what is locking the database, or any specific configuration to check?
A client of mine has an update to the software they use which requires SQL ports to be pinholed on the router to allow direct connctions from point of sale terminals. I'm not happy with the idea but thats not my call. Is there a way to restrict IP addresses that can connect to SQL Express ? (without havng to get them to buy a new router)
I am currently developing an data collection application that utilizes SQL Express 2005, I do not have the funds atm to upgrade to another version. I will be offering a free/crippled version of my application available for download. I do not want the free version to require the user to install SQL Express 2005 to use the data base. My question is this, I am wondering if I can take the database file itself and lock it, then use it like a flat file. I have seen this done with Microsoft Access before, but i want to use SQL because of the other versions are using it and will make the process of users upgrading less painful. Thanks in advance.
I'm having an issue where a folder that I'm accessing in an SSIS package gets locked up and cannot be deleted by my package later in the process.
1) I use a File System task to rename the folder. At this point, it appears to become locked and cannot be deleted.
2) Later I attempt to delete the folder using another File System task object. I get the error '[File System Task] Error: An error occurred with the following error message: "The process cannot access the file because it is being used by another process."'.
My package accesses the folder via a drive mapping. This seems to be part of the problem, as it's possible to delete the folder directly but not via the drive mapping. Even once the package completes it's still not possible to delete the folder in Windows Explorer via the drive mapping.
I have an SSIS package doing a bulk insert from a file. Then later on I'm trying to delete that file (in a file delete task), but I'm getting an error:[File System Task] Error: An error occurred with the following error message: "The process cannot access the file 'xyz' because it is being used by another process.".I'm wondering if there isn't some way to 'tweak' the bulk insert syntax so that it doesn't lock the file?
Hi, I was sent a .bak file which I need to open and place in sql server express. I googled this but did not come up with any clear instructions. Can some please give me a good link that explains this. Thanks
Hi all, I have the "Northwind" database in my Sql Server Management Studio Express.
In my C:ProSSEAppsSamplesForChapter02Chapter02 folder, I have the following 2 files: (1) ListColumnValues (MS-DOS Batch File) sqlcmd -S .sqlexpress -v DBName = "Northwind" CName = "CompanyName" TName = "Shippers" -i c:prosseappschapter02ListListColumnVales.sql -o c:prosseappschapter02ColumnValuesOut.rpt (2) ListColumnValues (Microsoft SQL Server Query File) USE $(Northwind) GO SELECT $(CompanyName) FROM $(Shippers) GO When I ran the following SQLcmd: C:ProSSEAppsSamplesForChapter02Chapter02>ListColumnValues.bat I got the following "ColumnValuesOut.rpt" with error messages:
'Northwind' scripting variable not defined. Msg 102, Level 15, State 1, Server L1P2P3SQLEXPRESS, Line 1 Incorrect syntax near '$'. 'CompanyName' scripting variable not defined. 'Shippers' scripting variable not defined. Msg 102, Level 15, State 1, Server L1P2P3SQLEXPRESS, Line 1 Incorrect syntax near 'CompanyName'.
I copied these T-SQL statements from a book and I do not know how to correct them. Please help and tell me how to correct these errors.
How do I move a tab serperated file into a table in SQL express using sql express? I need simple fast way to to this.
I can export all my access file into tab or comma files and then build the new tables and import them. I tried upsizing the table in access but sql express will not accept them at all and I cant find a way around it.
I am at the moment participating in a project and we have run into a few difficulties which I'm hoping you guys may be able to help with.
In short, we are attempting to construct an online manager game related to cycling. Although the database has been created already in SQL Server Express and some of the website has been made, we also would like to create an executable file (written in Visual Basic) which can be placed on the server and scheduled to execute once a day. The file should read data from the database and perform its defined calculations, before writing back to the database again for further use on the website.
The problem at the moment is that I can't figure out how to make the file recognize the database in such a way that I am able to use read/write statements with SQL directly. I have tried looking numerous places online but all sources show examples of creating web forms and using buttons and such to call functions whereas I simply want one compiled executable.
If you have any advice or recommendations on how I may tackle the problem I would appreciate the help greatly.
Essentially it a question of what is needed (perhaps in terms of code) for me to make the VB file in such a way that I can do SQL queries on it independent of any user interaction. We want the code to handle the database updating on its own each day.
Hello, I'm have developed a web site with .Net 2.0 and Sql Express. To make a loooong story short, I have managed to lose the myDB.ldf file. I still have the .mdf file but can not get my app to connect due to the .ldf missing. Please help if you can. Many thanks!!! The error I get is: "Cannot open user default database. Login failed.Login failed for user 'myComputerUser'.File activation failure. The physical file name "D:WebProjectswebProjectApp_DatamyDb_log.ldf" may be incorrect. "
I have an app that i use to connect to the database file locally. The app collects the information schema tables data. Once i have connected to the file once i cannot come back and connect again because it says the file is in use. but if i close the app and reopen i can connect just fine.
This happens with every db file i connect to. I can connect to several different files in a row but as soon as i try to connect a second time it pops up in use.
What am i missing? It has to be something in my app since it releases it as soon as the app is closed. Let me know what else i need to provide on how the app runs if noone has come across this issue yet. One other note is that i am connecting to it in a background worker. I have already tried to dispose of the background worker but that is not what is holding the file.
How do I move a tab serperated file into a table in SQL express using sql express? I need simple fast way to to this.I can export all my access file into tab or comma files and then build the new tables and import them. I tried upsizing the table in access but sql express will not accept them at all and I cant find a way around it.Thanks
I need to be able to update a database in SQL Server Express from an Access database that a user will be uploading. Can anybody give me some suggestions about how to accomplish this besides reading in each record and updating the SQL server one record at a time. David
Hi, i'm still rather new to sql server and sql server express. My problem is that I have 50 fixed width files(actually was LIS file type, converted to txt using notepad). Each text file has about 50 columns of data. What would be the best way to get this into sql server db?
We use SQL Express in our Applikation in file mode. Users can create databases in different folders and pathes. Each time a user loggs into our applikation, we attach the db he choosed, and every time he closes the applikation, we detach the db.
While this works fine in Windows XP, we have serious problems with Windows Vista.
We tried a connectiong string with "attachdbfilename", "sp_attach_db" and SMO server.AttachDatabase
Where could we get some more advice for our problem. It is in fact an issue of UAC.
I am having a hard time finding the executable file to start sql express 2005 or SQL exress 2005 with advance services. I installed the SQL express and had the desktop icon....but I thought i would need to uninstall it before installing SQL 2005 with advance services. Now I can not find anything to start the program.
Hello Everyone, I am trying to restore a bak file which came with code for a tutorial. I think it is safe to restore, but sql server 2005 express has the following problem when I try to restore it. TITLE: Microsoft SQL Server Management Studio Express------------------------------ Restore failed for Server 'BOBSQLEXPRESS'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476 ------------------------------ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:Program Files (x86)Microsoft SQL ServerMSSQL.1MSSQLDashboard.mdf'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476 The links given for help have no information about the problem and I'm not really sure where I should be looking to solve this. I'm a newbie to databases so if you could provide a step-by-step answer that would be best. Thanks in advance. Robert
Hi All, I have a .sql file with all my queries written in it. Now I want to know, Is it possible to run this sql file in SQL Server 2005 Express Edition like we can do in Oracle? If it is possible then tell me how to do it?Thanx in advance for any kind of help.Regards,Paramhans Dubey.
Hi,i have a MDF sql server express database used by an asp.net application (located in local dir App_Data on the same computer as the Sql server).I would like to integrate it into Sql Server express. I mean: NOT only attach it, but transform it as it was created direclty into Sql server and not in Visual Web Developper tool.In Studio Management, i rightclicked on Databases and i took 'Attach'. Now i can see and manage that database from Studio Management, but it still refers to the local path of the MDF file. I see that by doing this query: select * from master...sysdatabases How can i make it a full database of Sql server?Thanks Tartuffe
I'm a little stuck here. How can I import a flat tab delimited file into a SQL 2005 Express table? The standard DTS and import features are not there :-(Thanks,Casey
I am just starting to learn SQL 2005 Express. After opening the Management Studio Express, I right Click on the Databases node and create new database. then create a name etc. The problem is that when I click ok to create the new database, I get a warning saying that Input a filename. However when I click on filename (after filepath) it is greyed out and I cant add a filename.
I have database written in SQL SERVER 2005 since last two year .Now the Database size become 33MB, and the log file become 450 MB . The log file is too large for me . Do you any know how clear the log file in SQL SERVER 2005 EXPRESS SP2 ?.Thanks
This might be obvious - but if so I've missed it so far.
Is it possible to connect remotely to an Express database used in a website which is created in the App_Data folder by VWDEE 2005 and attached by filename?
As far as I can tell these databases don't have a name and aren't mounted until an attempt is made to access them. I certainly can't see any sign of it in SQL Management Studio.
I'm a newbie. I have googled many web sites,but i can't find the help that how to upload or store files(include images) into a database with Asp.Net 2.0. Although i have found few samples about storing images into database,but the sample applied with Asp.Net 1.0 or 1.1 technology... In microsoft MSDN,i found the help about FileUpload control,but the sample is about how to upload files to servers's folder with saveas() method. Who can help me ?Give me a refer sample about upload files to database with Asp.Net 2.0. Is it need to use stream or what other method? By the way, i want make a document managment system with vwd and sql express. Thank u very much if u can give me a help.
