SQL server – Management Studio tool
Hi, Thanks for your help, But on SQL Server (SQLEXPRESS) it prompts for only account name and password but no IP so I still can login to my clients server to access thier database. Please how do it. Thanks Chuk

Answer Question   |  September 24, 2008  12:37 AM
SQL Express, SQL Server Management Studio

retrieving data from SQL express
i have sql 200 and express 2005 runing on one machine and all is working but for some reason i cannot retrieve data anymore hence it says the data is being used by another instance.

Answer Question   |  September 28, 2008  1:23 PM
SQL 2000, SQL Express, SQL Express 2005

Backup/Restore a DB from Microsoft SQL Enterprise Manager to SQL Server Management Studio Express
Hi Is it possible to copy a DB from a server that has a genuin SQL Enterprise Manager to a server that has SQL Server Management Studio Express installed? Both servers are on the same net. I get following error when trying: Restore failed for Server ‘PROGTSTSQLEXPRESS’. (Microsoft.SqlServer.Express.Smo) System.Data.SqlClient.SqlError: The backup set holds a backup [...]

Answer Question   |  August 29, 2008  12:12 PM
Backup, SQL Enterprise Manager, SQL Express, SQL Server backup and restore, SQL Server Management Studio

Using VB.NET to find local subscriptions on SQL Express
I have several different SQL Express databases using pull subscription replication with a SQL Server. Different computers will have different databases to replicate with; some have more than one. Is there a way in VB.NET to find all the local subscriptions on the computer running SQL Express?

Answer Question   |  June 13, 2008  6:27 PM
SQL Express, SQL Server, VB.NET

Critical error in event logs
Why do I get this message; “SQLVDI: Loc=CVDS::Cleanup. Desc=Release(ClientAliveMutex). ErrorCode=(288)Attempt to release mutex not owned by caller.”?

Answer Question   |  April 29, 2008  2:24 PM
SBS, SBS 2003, SBS 2003 logs, SQL, SQL error messages, SQL Express

Installing Terminal server to existing domain
I have a client who has Server 2003 R2 installed running 2 line of business applications on SQL Express databases, plus Exchange. They have installed a Second server as a Terminal Server to provide access for remote workers. Do I have to reinstall the applications on the Terminal Server, or is there a way to [...]

Answer Question   |  March 5, 2008  7:07 AM
Exchange, SQL Express, Terminal Server, Windows Server 2003

Need help with running an external SQL query from within VB.Net code.
Hi all, I’m in a bit of a bind and new to SQL. I have built a DB using the SQL Manager and it works perfectly in my code. I have used SQL Manager to build the SQL to rebuild my DB as I want to use it in my VB.Net code. When I execute [...]

Answer Question   |  December 21, 2007  9:36 PM
SQL Express, SQL Manager, SQL Server errors, VB.NET

connecting VB2005 Express with remote msSQL2005 Express server
I’m trying to do the above with no sucess although I can connect msQuery, create msAccess projects, and ODBC with the remote server. The remote server is already configured to accept remote connections.!!! the message is that the remote server do not allow remote connections!!! any ideas

Answer Question   |  December 2, 2007  8:07 AM
Connect, Remote access servers, SQL Express, SQL Server 2005, VB 2005, Visual Basic

I can update the dataset, but not the database
Posted on behalf of BodjorB: I have been trying to update a database in a program i developed using Microsft Visual Basic 2005,SQL Express — whenever I enter data and click on Update, this updates the dataset, but the database is not updated. What am I forgetting?

Answer Question   |  October 5, 2007  12:37 PM
Database, SQL Express, Visual Basic