Hello, I am contracting someone to build an application under .NET and we are trying to agree on what the database for it will be. The software will record information in a database and this database will be stored onto the local workstation. This software would also be scalable in that the database...

I'm trying to figure out ASP.NET. Using IIS6 and SQL 2000 database (not MSDE). I have the following web.config file in the root of the web site, 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: yet I'm continually presented with the error: Server Error in '/' Application. -------------------------...

I'm working on a Java project in Maven, trying to initialize my test database to a known state before each test runs. I know that that step hasn't been completing properly, because one of the tests requires a specific record not be in the database, and asserts against that fact before it actually...

Our company has a MS .NET application on a MS SQL db. Some of our larger clients have been getting a "Deadlock" error message when they have more than 20 concurrent users on the system (the error information is attached). I am interested in any insight you may have into what causes this error...

Hi: I am working on linking a table in Access to a Sharepoint List. Deep within the bowels of access(!) I found the Macro action, "TransferDatabase". Here are the Action Arguments: Transfer Type: Link Database Type: WSS Database Name: http://gaisvr1/Team1;LIST=INS1;View=All Items;RetrieveIds...

Hi there, First of all I am a novice who is doing his best to learn this cool SQL stuff. I have nearly finished my project but I have one last hurdle to get over and cannot for the life of me work it out! OK here goes..... I have a table called: usedbikes_adverts In that table is a field called: PICTURE_REFERENCE...

How is the 2 gig limitation defined? does it include linked sql tables and the data in them or just access based tables and the data in them. I attempted to run a make-table query that has been running well forever and got a "invalid argument" message. I then proceeded to test new make-table...

Hi All I need to write a daily job that will update the SLA value field on record and add one day to it only when its 24hr or more from the date it was submitted. How would i do that? So far i have this: 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: UPDATE Ticket SET SLADay = CASE WHEN SLADay is null THEN 0 ELSE SLADay...

I have a table that has historical user records. This is imported. It contains a columns as follows: RecordId, UserId, AnotherId, LastName, FirstName, AcctType, etc...., ChangeDate RecordIdis the primary key I need to get the most recent record for each UserId. I need the entire record. There may be...

In a form, How do I return an Address (on the same form), from a Name picked from a combo box (again on the same form). It's a small invoice database that I wrote for my small business. I made a customer table with names, address, phone number, etc. I have the invoice form, using a combo box, enabling...