What are my options for achieving a cold backup server for SQL Server Express instance running a single database? I have an SQL Server 2008 Express instance in production that currently represents a single point of failure for my application. I have a second physical box sitting at the installation that is currently doing nothing. I w...
Scenario: I have created a database table. And when I tried to add a primary key (using the SQL Server Management Studiio) to the table, it failed with an error message "Saving changes is not permitted. The changes you have made requrie the following tables to be dropped and re-created. You have either made changes to a table that can't ...
The snapshot says is it all - I used to be able to attach a database, but after i detached today then tried to attach, i kept getting this error: http://img197.imageshack.us/img197/2574/attacht.jpg ...
I have two computers that share the same Internet IP address. Using one of the computers, I can remotely connect to a SQL Server database on the other. Here is my connection string: SqlConnection connection = new SqlConnection(@"Data Source=192.168.1.101\SQLEXPRESSNI,1433;Network Library=DBMSSOCN;Initial Catalog=FirstDB;Persist Security...
I want to be able to look at a .mdf before trying to attach it and determine if it will be possible to attach it without it's .ldf (this can be done if it was detached correctly). Currently, I am trying to attach the .mdf and if it was detached incorrectly and needs the .ldf to reattach it will give an error message that isn't very he...
I have asked this question before but not for sql server express. It seems that web services is not an option for syncing sql server express and iphone. Besides that it is not a necessity to sync within 3G or a Wifi connection. It is good enough to connect the iphone to the pc so that it can find the sql server through the network (prob...
In my code I'm attempting to use a transaction using TransactionScope with Entity Framework. While in this transaction we are opening a regular SQL connection to a seperate server and database. When the conn.Open() is called we get an Error: "Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enab...
I have a SQL Server Express database that has a query that should return about 230 thousand rows. Problem is the query returns about 5 more rows each time you run the query. What would cause something like this? I ran 'DBCC CHECKDB' but that did not change the behavior. Any ideas. thanks ...
I'm trying to delete a couple of rows USING SQL Server management studio, for 2 rows only i get the message No rows were deleted A problem occurred attempting to delete row #X Error Source: .Net SqlClient Data Provider Error Message: String or binary data would be truncated The Statement has been terminated Correct the errors and ...
What permissions should be granted to the remote user to do anything with the database "123" in SQL Server 2005 Express using SQL Server Management Studio Express such that the remote user cannot do anything to any other database? I would also like that the remote user cannot see the other databases. That is "123" is for the user login...
I was trying to remove my recent connection list by deleting the mru.dat (in Application Data folder under windows xp) file as pointed out in numerous tutorial over the internet(I just googled it) but was unable to find it. How am I supposed to clear it? Please help. ...
I am trying to add the NETWORK SERVICE login cause I still can’t connect to the AdventureWorks3 database. But I want to add this NETWORK SERVICE login via SQL Server Authentication and not Windows. When I select Windows authentication, it lets me create this login. But when I select SQL Server Auth, it gives me the following error: Crea...
I want to buy a new laptop to do .NET web development and am wondering what version of the Windows 7 OS I need to buy. The options are Windows 7 Home premium 64 bit or I pay $120 more and get the Windows 7 Professional 64 bit, which I really dont want to pay for if I dont need it. I would like to Install Visual Studio 2010, SQL Server 2...
I'm in a situation where I need to create a partial copy of a database from a remote SQL Server (2005/2008 Express Edition) and store it in a local SQL Server (2005/2008 Express Edition) database. The local copy will have the same schema definition, but contain only parts of the data from the remote database. The local database has to ...
SO I am just getting started with this. New to .NET, SQL Server, C#, VB.NET, etc and the closest thing I have to related to this is some experience with MS Access and the VBA that relates to that and MS Office automation. So I do have Visual VB.NET 2008 Express installed, SQL Server 2005 express installed, and I do know how to start a b...
What kind of error occurs? What do users experience? Can you access the database using tools and what if you get it back under the 4GB / 10GB limit? ...
I am connecting to a SQL Server Express 2005 on another PC on our company LAN. On my PC (which has Windows7) the connection is immediate. On our tester PC (who has Windows XP), the connection takes about 5 to 6 seconds every time. This is the same network and the same server. I am not talking about a connection through an application, ...
Hi all, We are facing a strange performance problem with "SQL Server Express 2005" in a very simple condition. We have a table with: [timestamp], [id], [value] columns. and only one primary unique index on [timestamp]+[id]. The table contains around 68.000.000 records. The request is: SELECT TOP 1 timestamp FROM table WHERE id=1234 O...
HI, folks, Previously, I had a SQL Server 2008 installed, but then I deleted it, and installed SQL Server 2008 Express Management Studio. And now I can't connect to local computer. I get error : A network-related or instance-specific error occured while establishing a connection to SQL server. The server was not found or was...
I installed Microsoft SQL Server 2005 Express edition on my Vista Ultimate computer. However, when it opens I enter my computer name / SQLEXPRESS. When I click the Connect button, it gives me an error message. Under the configuration tools I cannot find the SQL Server Surface Area Configuration. It only has SQL Server Error and Usage R...