This article illustrates the necessary settings to enable remote access to SQL Server Express 2005. 1. Go to Start–All Programs–Microsoft SQL Server 2005–SQL Management Studio Express and follow the instructions…
Question: Can I set a Select() and an Update() in the same SQL clause, similarly to the example below? Update EQUIPMENT Set EQUIPMENT.EQUIPMENT=’‘, EQUIPMENT.DISABLED=, EQUIPMENT.CLASS_EQUIP=CLAS_EQUIP.INDEX, EQUIPMENT.SECTOR=SECTORS.INDEXWhere EQUIPMENT.INDEX= and CLAS_EQUIP.CLASS_EQUIP=’‘ and…
Question: How can I point to the local computer in the Database? Solution: To do so, go to Server field in the Database’s proprerties, erase the computer’s name and then…
Question: How can I set up an SQL query to return data whenever a historic field of type date/time has a certain value? Solution: For a Microsoft SQL Server…
Question: Can I update SQL Server v. 2000 to v. 2005 in E3? Is there any incompatibility? Is it necessary to reconfigure E3? Solution: Yes, this update can be done…
Question: Why do Access files not reduce their sizes after its records are deleted? Is there another way to make them release this space? Solution: This is Access’ normal behavior.…
Question: What are SQLEXPRESS’s size limits? Solution: SQLEXPRESS 2005/2008 supports 1 CPU, 1GB RAM, and has a 4-GB storage capacity per database. SQLEXPRESS SQLEXPRESS 2008 R2 supports 1 CPU, 1GB…
Question: Why can I only establish connection with a SQL Server Express database locally, and not in a computer other than the one where this DB is running? Solution: In…
Question: What is the maximum size for an Access database? And how often can it record data?Solution: The maximum recommended size for an Access database is approximately 200 MB. The…
Question: How can I tell whether a query’s DELETE command was successfully sent to the database? Solution: To do so, you can use the return of query’s EXECUTE command to…