I'm a newbie.How many number of tables are recommended in a SQL Server Express database? mainly attaining best performance speedwise as an objective. Is it generally recommend to use two databases as compared to one for a single application? Your quick response will be highly appreciated ...
Hello Everyone, I have a strange problem with an Access adp project. There is a main form with a header and a details sections on a page. The detaisl section is made up of a tab control that has 7 tabs to it. Only the 1st tab shows up if I connect the project to a REMOTE SQL Server 2005 Express database. The same details section w...
How is it possible to run a stored procedure at a particular time every day in SQL Server Express Edition? Notes: This is needed to truncate an audit table An alternative would be to modify the insert query but this is probably less efficient SQL Server Express Edition does not have the SQL Server Agent Related Questions: How can ...
How is it possible to run a stored procedure when SQL Server Express Edition starts? ...
Is it possible to run multiple stored procedures that run 'in the background'? The stored procedures must be launched from a single, master stored procedure, in the same way that multiple worker threads are spawned. For example: CREATE PROCEDURE MyLauncher AS BEGIN BEGIN @EXEC MyBackgroundSP01 -- Runs in parallel to the othe...
It is possible in SQL Server Express have a log of all operations "SELECT / UPDATE / INSERT / DELETE" being made. Thank you. ...
What is the preferred method for installing software that requires SQL Server Express? Should you mount the database using a new account created by an admin that installs the software? If we use the SA account there is no problem at install time, but at runtime there is an error indicating an issue with the LDF file. ...
I need to create a TSQL script to backup a db on a remote SQL Server Express (2005). I have a SQL Server 2005 on another box. Not sure how I can run the script from this SQL Server 2005 to do the backup job. The script is something like this: RESTORE DATABASE [myDB] FROM DISK = N'C:\Tmp\myDB.bak' WITH FILE = 1, NOUNLOAD, STATS =...
Hi, I have created a windows service which interacts with SQL Server Express Edition. I want to ship this to my test machine which doesn't have any form of SQL Server installed. Is there an easy way of shipping SQL Server Express Edition with my service? Is it possible to make this part of a Setup Project? Thanks. ...
I have a typical dev scenario: I have a SQL 2008 database that I want to copy every so often to my local instance of 2008 Express so that I can do dev, make changes, etc. to the local copy. I have some constraints though: the source db is part of a live e-commerce site in shared hosting so I can't detach it and the hosting service wants ...
Hi there I have an asp.net page with a gridview and a couple of input text boxes and a search button. Once I put something on both text boxes and press search, I get a result list (gridview) from a MS SQLExpress 2008 database. Everything runs great BUT for some unknown reason the search stops working every now and then. I type values o...
We require programmatic access to a SQL Server Express service as part of our application. Depending on what the user is trying to do, we may have to attach a database, detach a database, back one up, etc. Sometimes the service might not be started before we attempt these operations. So we need to ensure the service is started. Here is w...
Hi, I am developing an application which needs to backup data between SQL Express 2005 and SQL Server 2008. My client runs with an installation of SQL express 2005 and needs to periodically back up data to a server database running on SQL Server 2008. The client db also receives some new data from server and needs to update itself. The ...
I am running SQL Server 2008 Express and can connect to it fine using port forwarding through my router, AND when I am on the same subnet. However when I am on a different subnet, I can only connect to it right after I restart the SQL Server Agent. After the restart, I can connect to it, however if I close the connection, I have to res...
This is the query I'm using: DELETE TB1.*, TB2.* FROM TB1 INNER JOIN TB2 ON TB1.PersonID = TB2.PersonID WHERE (TB1.PersonID)='2' It's working fine in MS Access but getting error (Incorrect syntax near ','.) in SQL Server Express 2005. How to solve it? Please help. ...
We have a team of sales persons who travel often carrying a laptop loaded with Sales data in a SQL Server Express database. What are the options available to encrypt a SQL Server Express database? ...
I've got the main report displaying just fine. Can't get the subreport to display data. Parameters are setup and linked appropriately, but still nothing. Am I missing something obvious? Is there a bug I'm not aware of? Anyone else fighting with this? I'm using Visual Web Developer Express 2008 on a SQL Express 2005 database. ...
I am using the Database explorer/designer of Visual C# 2008 Express Edition with SQL Server Express 2008. I created a table and want to add an index. But the index would exceed 900 bytes. One workaround is to use included columns in an index. Unfortunately, the "Included Columns" property is disabled in the Index designer and I haven't...
Hello all, I have a PHP script that queries SQL server using SQLCMD - I am using SQL Server Express 2008. Most of my queries go through to SQL Server fine but sometimes I get this: sqlcmd return output is: Array ( [0] => Msg 4060, Level 11, State 1, Server ABS-PC\SQLEXPRESS, Line 1 [1] => Cannot open database "test_v02" reques...
We have a job which runs every morning in CruiseControl.net to import a datafile into a DB. Our problem seems to be that some nights the DB goes to sleep over night. When we run the script in the morning our connection times out while we wait for the DB to warm up. We've tried upping timeouts etc. but with no luck. Is there a way to tell...