When I try to add a new Sql Server Database file to my Visual Studio project, it tells me that I need to have Sql Server 2005 Express installed even though I have Sql Server 2005 Developer already? Is this by design and if so, why did Microsoft do it? and if it is not by design, what is the solution to fix it? ...
I have a MS SQL 2005 database with a table Test with column ID. ID is a identity column. I have rows in this table and all of them have their corresponding ID autoincremented value. Now I would like to change every ID in this table like this: ID = ID + 1 But when I do this I get error: Cannot update identity column 'ID'. I've trie...
We have a server that is running Microsoft SQL Server 2000 and would like to setup Umbraco 4.0. I tried the web install, but it choked on the MS SQL 2005 Express install. So I next tried the manual installation of MS SQL 2005 Express, which choked also with an error indicating that there was incompatibility issue because we already have ...
I would like to list what instances of SQL 2005 Server (Express Editon) are installed on local or remote machine (my app is in Native C++). I found that i can make it by SQLDMO, however it seems that SQLDMO does not see SQL 2005 Express Edition and call to ListAvailableSqlServers returns empty list. How can i make it? Playing with syste...
Hi, I have a program that is filling a DB in a single thread. I Use one connection for all queries. Thats so i will be able to run them all in transactions. Every second I get a new set of files that has to be entered into a SQL Server 2005 Express. The Application can run for 24 to 36 hours and than suddenly get a "EAccessViolation" ...
I have this query as a stored procedure: SELECT ID FROM dbo.tblRentalUnit WHERE (NOT EXISTS (SELECT 1 AS Expr1 FROM dbo.tblTenant WHERE (dbo.tblRentalUnit.ID = UnitID))) In Microsoft SQL Server Management Studio Express, it executes in 16 ms. When I have it in a typed d...
Hi All, We are using SQL Sever 2005 replication for out application. Every thing is working fine without any problems. However, recently we ran into a situation to which I have no solution. We use merge replication with the publisher(sql server 2005) in one geography and the subscribers(sql server 2005 express) in multiple other geogra...
I have a stored procedure that takes no parameters, and it returns two fields. The stored procedure sums up all transactions that are applied to a tenant, and it returns the balance and the id of the tenant. I want to use the record set it returns with a query, and I need to join it's results on the id of the tenant. This is my current...
I am attempting add a tableadapter to a stored procedure in my SQL Server 2005 Express. The stored procedure, however, uses a temporary table called #temp. When creating the table adapter, Visual Studio complains "Unknown Object '#temp'" and says that the stored procedure returns 0 columns. This is problematic because I use that stored p...
I have 5 queries I'd like to join together. Basically what they do is they go though the database and select how much a tenant has paid, and how much a tenant owes based on how long ago he or she was charged. I have four categories Charge < 30 days old Charge < 60 AND >= 30 days old Charge < 90 AND >= 60 days old Charge > 90 days old ...
I haven't seen anything that says SQL Express 2005 is not supported for use with Team Foundation Server 2005. However, when I attempt the installation I get all sorts of errors "SQL Agent service not installed", "SQL Server 2005 Analysis Services service is not installed", etc. Is SQL Server Standard or higher, required? ...
Folks, Visual Studio installed SQL Server Express on my computer, which to date has satisfied my needs. I now need to do remote database support so need the full version of management studio. I tried to install the standard version but it is blocked, apparently because Express has newer versions of the files. Can I do this? Will they pl...
Hi, I am struggling with an MS SQL 2005 Express issue. A query like the one below works perfect when Windows Regional Options (control panel) is set to English (United States), but it fails when set to Italian (and maybe other languages). UPDATE MyTable SET StartDate='2009-07-14 12:05:30' WHERE ID=7 I tried also many different date-t...
I wanted to add my colleague's information in my database for testing purposes. Since he his from Vietnam, his name has a special Vietnamese character in it ('ơ'). When I updated the database, the character was transformed to a regular 'o'... How can I store that kind of special character inside SQL Server Express 2005? ...
Hey all, I have a linq app using C# express2008 and sqlserver express 2005 (mdf file connection) I followed the regular dml generation and vanilla datacontext. However i created a repository class to manage the Linq stuff. In using the functions, selecting data works fine, updating data works in the app.But when i check the data in the ...
I need to backup SQL Server database. Is it possible to do this automatically without human intervention at regular intervals? If so yes then please suggest me how to do it and I'm using SQL Server 2005 Express Edition. ...
hi to all, i m creating an application, inwhich client has to acces a database stored in a remote location connnected through a live ip. how can i connect simply with a database server placed in LAN. both using sql server 2005 express edition. please refer me or help me on this ...
Can you please explain how to setup a linked server between a SQL Server (A) and a SQL Server Express (B) scenario. Server A is SQL Server 2000, whereas Server B is SQL Server 2005 Express. I have set these up in the past, but none where connected to a SQL Server Express version. Thanks, Billy ...
Hello, I originally installed the Visual Studio 2008 SP1 Express editions. I also installed SQL Server 2005 Express as I had some 2005 databases. Later I needed to install both VWD 2005 Express and VB 2005 Express as well. Now when I am using VWD 2005 and try a to add a SQL Datatabase as a new item, I get the error: "this server is no...
I managed to find an old Axapta version to practice some programming and learn Axapta a little. The problem is I can't get it started. I had installed SP1-2-3 and started it, it is supposed to create the database. Well it creates some tables then I get a syntax error from SQL Server. I am told even SP1 was enough for SQL 2005. The error ...